Stephen A. Fuqua (SAF) is a Bahá'í, software developer, and conservation and interfaith advocate in the DFW area of Texas.

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.