Learn how to drop an index in SQL Server using T-SQL or SSMS, what to consider before dropping an index, and how to monitor the effects on your database.

@Mode = 3: Missing Indexes - an inventory of indexes SQL Server is suggesting. Also great for copy/pasting into Excel for later analysis. sp_BlitzIndex focuses on mainstream index types. Other index ...

SQL Server 2012 includes a lot of new and exciting features. One feature that has caught the imagination of many in the user community is the high-performance feature called Columnstore Indexes.