Category Archives: Uncategorized

Subqueries for XML blobs without self-referencing

Posted on December 18, 2021 by ph1lqu1nn

One of the issues I see several times within SQL Server is people creating SQL Subqueries that reference the parent query so that an XML blob can be created. In this example The simple table query returns the table contents … Continue reading →

Posted in Uncategorized | Leave a comment

Auditing Your Database Changes

Posted on September 11, 2013 by ph1lqu1nn

SQL Server can capture Database level Trigger information using XML.  I personally use this on my home PC’s because I’m poor and can’t afford one of those amazing DB Source control products that are out there on the market. I’m … Continue reading →

Posted in Uncategorized | Leave a comment

Recursive XML branches

Posted on August 19, 2013 by ph1lqu1nn

One of the main features of XML is that it handles hierarchical data structures.  I agree that so does SQL either using the hierarchy variable or creating a Recursive CTE.  but nothing compares to the simplicity  of the XML format … Continue reading →

Posted in Uncategorized, XML | Leave a comment

Reducing size of a nonclustered index with Filtering

Posted on December 4, 2011 by ph1lqu1nn

SQL Server 2008 has a very nice new feature that enables a partial index to be created based on a specific where clause. I have recently used this as an solution checking a table that contained an isSent flag. by creating a … Continue reading →

Posted in database performance, filtered indexes, non-clustered Indexes, SQL, Uncategorized | Leave a comment