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.

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.

How to Add a New Shared Disk to a WSFC as a SQL Resource

Adding a new shared disk to Windows Server failover Cluster is not a complex process but special care must be taken when you want to use the new disk for any existing SQL Instance. In this article, we will show you all the required steps to add the disk to WSFC and then to properly assign it to an existing SQL role in the WSFC.

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.