Query performance decreases when sys.dm_db_index_usage_stats has large number of rows

Consider the following scenario: –In Microsoft SQL Server 2005, you frequently perform DDL operation that involve dropping and recreation of lot of tables (especially temporary tables in tempdb database). –You have a large number of entries (100,000 or more) in the sys.dm_db_index_usage_stats

Read More - Register for Free Membership