Explain GO T-SQL confusion with batch boundaries, GO repetition, variable scope, semicolon errors, and a procedure creation example.
SQL SERVER – ReadOnly Databases and Notes Using Snapshots
Can you get the ReadOnly error without marking the database ReadOnly? Yes, using snapshots. Here is a script that shows the behavior step by step.
Building the Restore Script for the Latest Backup Chain From msdb
Do not type a restore sequence by hand at 2 AM. Let msdb tell you the order, and prove the script works before you need it.
Interview Question of the Week #008 – Write Scripts to Convert String to Title Case or Proper Case
Convert string values to title case with a corrected function, ordered SQL Server aggregation, and clear limits for personal names.
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.
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.