SQL Server Forced Plans Overwite the Query Hash

A 16-year old SQL Server bug that means 'forced plans' have the query plan hash in place of the expected query hash. Includes an explanation and discussion of the term 'morally equivalent plan'.

Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.

This article shows how to attach an MDF with or without a log file.

The New Log File

Renaming a Database

How Do You Patch 100 Database Servers?

The challenges of managing lots of system are significant and there aren't easy solutions, but Steve has a few thoughts on what you can do.

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.