The order of operations in SQL Server follows PEMDAS, so 6/2*(1+2) returns 9. This post walks through the precedence rules with tested queries. It also covers integer division, the negative number trap and AND before OR.
SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet
I often get questions that how to fix the issue where excel loses decimal values when values are pasted from SSMS Resultset.
Keeping a Patch Test Environment Honest
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.
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.