Author Archives: ph1lqu1nn

XML .value simple syntax

There are several ways to get .value to extract an item of information from xml.  in the following article I will show some of the syntax and reasons why some methods are better than others. All the calls in this … Continue reading

Posted in SQL, 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

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