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.

Disable All the Indexes

Auditing SQL Server – Part 4 – Database Configuration Audit

This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits.

Disabling Indexes

Setting Emergency State

Index cleanup : Harder than it looks

I’m not the first person to write about cleaning up unused or redundant indexes.

Database Options and Numeric Roundabort

DBCC TRACESTATUS

What happens when we drop a column on a SQL Server table? Where's my space?

You have dropped a column and wondering why you haven't recovered any space? Let's take a look.