SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • Take it a step further with the index DMV's

    In SQL 2000 I wanted to find unused indexes but found it to be difficult. I had to capture a huge trace that fully represents the workload and “trust” that the ITW knows what it’s talking about. You could also use the scan started trace event filtered by dbid, objectid, indexid. This procedure was very...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Sun, Nov 25 2007
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems