15 May 2018 · 5 min read
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 →
15 May 2018 · 8 min read
How to Find SQL Agent Tasks and Schedules
Query SQL Server Agent jobs and schedules directly from msdb using a single T-SQL script. Identify overlapping jobs, disabled tasks and performance issues fast.
Read article →
15 May 2018 · 4 min read
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 →
21 Oct 2017 · 6 min read
Gettin’ Techie SET STATISTICS TIME
SET STATISTICS TIME reveals exactly how long SQL Server spends parsing, compiling and executing your queries. Learn to read the output and diagnose slow query performance with confidence.
Read article →
← Previous
Page 2 of 2