June 2008 Archives

MSSQL 2005: Indexed Views

June 16, 2008

Good article on using indexed views: Indexed Views Basics in SQL Server. Similar good coverage in Ben-Gan's Inside Microsoft SQL Server 2005: T-SQL Programming. Problem: both specify that the hint WITH(NOEXPAND) needs to be used when executing a query against the index on anything other than Enterprise and Developer. However, I've found that it is also required for Enterprise.

About this Archive

This page is an archive of entries from June 2008 listed from newest to oldest.

May 2008 is the previous archive.

July 2008 is the next archive.

Find recent content on the main index or look in the archives to find all content.



OpenID accepted here Learn more about OpenID
Powered by Movable Type 5.12