Nice new functionality in SQL 2008, Filtered Indexes are indexes defined with a WHERE clause!
Nothing further here until I have time to explore, implement and write my own experiences...
http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/07/11/filtered-indexes-really-cool.aspx
http://sqlfool.com/2009/04/filtered-indexes-what-you-need-to-know/
http://www.mssqltips.com/tip.asp?tip=1785
No comments:
Post a Comment