John Sterrett shows how to capture a workload and find your top offenders in SQL Server 2012 right inside Management Studio, without writing any T-SQL.
SQL SERVER – Notes and Observations on ReadOnly Databases in SQL Server
Can you create temp tables, stored procedures or shrink files in ReadOnly databases? I answer these reader questions with simple examples.
BULK INSERT With FORMAT CSV and FIELDQUOTE for Quoted Files
A comma inside a quoted name can break a CSV load without any error. Here is how FIELDQUOTE fixes it, and how to validate what arrives.
SQL SERVER – Quiz with DATEADD Function – SQL Puzzle
The DATEADD function returns the last day of the month when the day does not exist, so one month after January 31 is February 28. This post keeps the quiz, runs every query on SQL Server 2025 and explains the month rule and the Msg 517 overflow with the real results.
SQL SERVER – Installation Error – INSTALLSHAREDDIR parameter is not valid because this directory is compressed or is in a compressed directory
SQL Server setup failed saying the INSTALLSHAREDDIR parameter is not valid because the folder is compressed. Here is how removing that attribute fixes it.
Interview Question of the Week #007 – How to Reindex Every Table of the Database?
Reindex every table selectively with SQL Server catalog checks, quoted identifiers, and a clear choice of rebuild or reorganize.
SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated
Msg 8152, String or binary data would be truncated, is an error most developers have seen. Here is what causes it and why the setting that hides it needs care.