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.

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.

Managing Backup History Options in MSDB

The Last DBCC Date

Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes

Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.