DBCC CHECKDB

Orphaned Distribution Transactions

Learn about orphaned distribution transactions in SQL Server and how you can clear them.

Show Database and Log sizes, free space and location

This script helps to identify which database/log takes most of the disk space and how much is free.

How to Change the SQL Server Name after Renaming the Windows Host

This article shows how to change a SQL Server name after changing the Windows machine name.

Endpoints

List of Stored Procedures modified in past 7 days

Provide list of Stored Procedures that have been changed in past 7 days.

Throttle a Query in Mid-Execution

Resource Governor provides a great mechanism for throttling resources, but it doesn't always allow granular control. Read about this trace flag that allows you to dynamically alter the resource usage of a query.

Database Mirroring

Brent Ozar's Six Scary SQL Surprises

In lesson 3 of the Top 5 Hard-earned Lessons of a DBA series, Brent Ozar exposes six common but scary surprises that can lurk behind the façade of SSMS. Read it now, and learn hard lessons the easy way.

Thesaurus Files