A ratty-looking red diskette

T-SQL Tuesday Retrospective #010: Indexes

(You can see previous T-SQL Tuesday retrospectives by visiting this link.) In September 2010, Michael J. Swart (blog | Twitter) invited us to talk about indexes. Indexes are strange things. You never need to explicitly create one to create a fully-functional database, but if you want a database to perform well, they’re indispensable. Many words
-> Continue reading T-SQL Tuesday Retrospective #010: Indexes

Post image

Duplicate Index Finder updated

The SQL Server 2000 Duplicate Index Finder has been updated. I presented the newest version tonight at the SQLskills.com immersion event open night. Grab the scripts here. Changes include a workaround for appending RID and UNIQUIFIER identifiers to indexes. From what I can tell, it is version-complete now. Unless any bugs creep up again, of
-> Continue reading Duplicate Index Finder updated

Remove duplicate indexes in SQL Server 2000

With permission from Kimberly Tripp, the creator of the fantastic duplicate index finder for SQL Server 2005 and 2008, I have ported this duplicate index finder to SQL Server 2000. I am fortunate in many respects, in that SQL Server 2000 does not support included columns, nor disabled indexes, so the scripts themselves were straightforward.
-> Continue reading Remove duplicate indexes in SQL Server 2000