Check out your local user groups
Look out whats happening in the SQL world at www.sqlrelay.co.uk www.sqlserverfaq.com-
Recent Posts
Archives
Categories
Meta
Category Archives: Uncategorized
Auditing Your Database Changes
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
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
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