A Patch Test Environment must match production data, settings, jobs, and versions closely enough to reveal real patch risks.
SQL SERVER – Validating Unique Column Name Across Whole Database
A Unique Column Name check lists existing matches across visible database metadata. I use it as an inspection, not an enforcement guarantee.
SQL SERVER – Replace a Column Name in Multiple Stored Procedure All Together
A beginner on a development server asked how to replace a column name in Multiple Stored Procedure code all together. Here is the quick way I suggest.
Why CAST to a Short VARCHAR Returns a Star Instead of an Error
Understand why a short VARCHAR returns a star for an integer, compare Unicode errors and string truncation, and size conversions safely.
Effect of Collation on Result Sets in SQL Server
The effect of collation on result sets is easy to see once you run the same query against two collations. This post builds a small demo and shows how sorting, comparing and grouping change. It also explains collation conflicts, including the one temp tables cause.
SQL SERVER – SSMS Automatically Generates TOP (100) PERCENT in Query Designer
Why does Query Designer in SSMS keep adding TOP (100) PERCENT when you create a view? A forum question, the full scenario, and what is going on.
SQL SERVER – SQL Server Statistics Name and Index Creation
Guest author Sandip hit Msg 1913 while creating an index, because an index or statistics with that name already existed. A lesson on statistics name and index creation.