Uncover SQL Server Missing Indexes

In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.

SQL Index Rebuild vs Reorganize Comparison

This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.

Enable a Disabled Index

Disable All the Indexes

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.