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.

Posted with : Tech, SQL Server