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 […]

Index fragmentation on all databases

The script returns all the fragmented indexes on all databases on the instance you run it. Can be run on multiple instances in the same time using central management capability.

Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation

Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the desired rows and changes them while synchronously writing to the transaction log […]

Indexes: When Column Selectivity Is Not Always A Requirement

While preparing for my SQL Saturday Salt Lake City presentation, Climbing the B-Tree, I ran into one of the “word of mouth” facts that the first column of an index should be highly selective, i.e., it should only point to one or a few rows. This is not always the case and I’ll show you […]

Unique Clustered Columnstore Index

Two Important ‘ONLINE’ Column-Level Operations in SQL Server

Today Kendra talks about two of the online options used when working with indexes.

Updating Statistics