How Many Indexes Is Too Many?

Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete:

A Tidy Database is a Fast Database: Why Index Management Matters

Learn about the ways in which you might better manage indexes for a better performing and efficient database.

Backing up the Database Encryption Key

Incremental Statistics

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.

How to Delete Large Amounts of Data in Microsoft SQL Server

A short look at some of the options for deleting lots of data from a SQL Server table.

Cleaning Up Your Database

How many of us clean up our databases and is it worth it? Steve has a few thoughts.

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

Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes

This article explores how raising the Cost Threshold for Parallelism (CTFP) affects missing index recommendations in SQL Server along with examples.