Tag Archives: sqlserver

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 →

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 →