Top Wait Types and Descriptions
Learn how to read SQL Server wait statistics and identify the wait types that actually matter, with inline descriptions built into the query result set.
Read article →
SQL Server Fixed Server-Level Roles
SQL Server includes 9 fixed server-level roles that are commonly misused. Learn what each role does and how to apply them correctly to protect your instance.
Read article →
How to Find Which Files Belong to Which SQL Database
Learn how to map SQL Server database files to their databases using a simple JOIN on sys.master_files and sys.databases, ordered by file size to spot problems fast.
Read article →
How to Find and Alert on Deadlock Conditions
Deadlocks can silently wreck application performance. Learn four practical methods to detect and alert on SQL Server deadlock conditions before they escalate.
Read article →
How to Drop and Recreate Foreign Key Constraints in SQL Server
Learn how to safely drop and recreate foreign key constraints in SQL Server using system catalogue views to generate precise ALTER TABLE scripts automatically.
Read article →
How to Check Fragmentation Level of a Database
Index fragmentation builds silently and drags down SQL Server performance over time. Learn how to check fragmentation levels and identify which indexes are worth acting on.
Read article →
How to Temporarily Disable Check Constraints and Database Triggers
Learn how to temporarily disable check constraints and triggers in SQL Server for bulk loads and migrations, and how to re-enable them safely without risking data integrity.
Read article →
How to Find Longest Running Queries
Learn how to find your longest running SQL Server queries using sys.dm_exec_query_stats, so you can identify the top resource consumers and fix performance problems fast.
Read article →
How to update DB File Growth Settings for ALL Databases at the same time
Running with SQL Server's default autogrowth settings is quietly hurting your performance. Learn how to bulk-update file growth settings across all databases using a single T-SQL script.
Read article →
How to Find the Up-Time of a SQL Server Instance
Learn how to find SQL Server instance uptime with a simple T-SQL query and why it matters for accurate DMV data, wait statistics analysis, and detecting unexpected restarts.
Read article →
How to Fix Very Large MSDB Database
A bloated MSDB database can cause maintenance jobs to fail and monitoring alerts to fire. Learn how to identify the cause and fix it safely.
Read article →
Surround Yourself with Smart People
The most effective organisations know the limits of their own knowledge and bring in the right expertise at the right time. Here is why that matters for your database environment.
Read article →