Index Rebuilds Make Even Less Sense with ADR & RCSI

Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works.

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.

Prevent Duplicate Records in SQL using Filtered Index

In this article, I share how an SQL Server filtered index solved the problem of preventing duplicates for new rows in a table.

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.

Types of indexes available in SQL Server 2019

How Bad are Bad Page Splits – The Rest of the Story

In Part 1 of this article we looked at a specific use case (probably exaggerated) that gave us an idea about how CPU and IO performance might be affected by a bad page split. We continue this analysis looking at what really happens to the data on the leaf pages of a clustered index with […]

Building SQL Server Indexes in Ascending vs Descending Order

In this tip we look at the impact of building SQL Server indexes in ascending versus descending order and the impact.

“Included columns” for non-clustered indexes explained

Learn about the advantages and disadvantages of using INCLUDE columns in your index.

Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]

Collect SQL Server Index Usage Information for all Instances with PowerShell

In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.