Tag Archives: sql

Performance: Alter a table’s clustered index in SQL Server while keeping the table online

Back in the old SQL Server 2000 days, creating an index was a major operation that would prevent queries and data modifications until it had completed. Unless the index could be created in a few seconds, any new indexes had … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Performance: Query the sqlserver plan cache to find queries that use a particular index

Part of keeping a SQL Server database running smoothly is to keep indexes well tuned. As database schemas or usage change, indexes that were once important may fall out of use. Eliminating unnecessary indexes helps speed up inserts/updates/deletes, and it … Continue reading

Posted in Uncategorized | Tagged , , | 3 Comments