Disabling Indexes

Index cleanup : Harder than it looks

I’m not the first person to write about cleaning up unused or redundant indexes.

SQL Server Filtered Index Essentials Guide

Learn about using filtered indexes for SQL Server tables and some of the potential issues you might be faced with when using a filtered index.

Adding a PK - II

Adding a PK - I

SQL Server Resumable Index Operations

The ability to pause and then resume index rebuilds has been added to SQL Server. This is a fantastic feature, and with the release of SQL Server 2019, we can now replicate it on the actual create index process. Learn how to use this feature in this short article.

SQL Server Indexes to Improve Query Performance

In this article, we look at how to design SQL Server indexes and why the way an index is created makes a difference in query performance.

Fully Indexing Views

Index Type Limits

More on Column Choice and Order for Multi-column Non-Clustered Indexes

In the last year I’ve published articles on indexes to include Indexes: When Column Selectivity Is Not Always A Requirement – SQLServerCentral and Query Optimizer Suggests Wrong Index and Query Plan -- Why? – SQLServerCentral. This article is a continuation of just how the optimizer interacts with the index wizard. We’ve all heard and read […]