DBCC CHECKDB running slow can trace back to the MAXDOP option. A CHECKDB with no MAXDOP option uses the server’s max degree of parallelism, and one with its own option overrides it. This post times CHECKDB on a 2 GB database with four settings, adds PHYSICAL_ONLY, and lists the other causes to rule out.
SQL SERVER – How to Find Free Log Space in SQL Server?
Free Log Space is reusable capacity inside an allocated transaction log. I measure disk space and file size separately.
Restore Database Wizard Slow to Open in SSMS
The Restore Database Wizard reads the backup history stored in msdb before it opens. When that history has grown for years, the wizard is slow. This post counts the history, deletes it in monthly steps with sp_delete_backuphistory, shows how to clean one database’s history, and sets up a regular cleanup so the wizard stays fast.
How to Search Special Characters in Table Column? – Interview Question of the Week #172
Can you find [blog.] in a column with LIKE? Most people I interview cannot. Here is how to search Special Characters in a table column the right way.
SQL Server – Performance Comparison of Function Trim and LTRIM(RTRIM)
A workshop question: what is the performance comparison of function TRIM and LTRIM(RTRIM) in SQL Server? Here are the test results.
SQL SERVER – Split Comma Separated Value String in a Column Using STRING_SPLIT
To Split Comma Separated Value String inputs, I use STRING_SPLIT with CROSS APPLY. The example associates each class with its student.







