SIN and COS read angles in radians and return float. These explicit degree conversions show signs, axis angles and fractional results at a chosen decimal display scale.
SQL SERVER – Dynamic Case Statement – FIX : ERROR 156 : Incorrect syntax near the keyword
Using CASE in ORDER BY to switch between ASC and DESC gives Error 156: Incorrect syntax near the keyword. I show two ways to write a dynamic case that works.
Planning a Move Off an Old SQL Server Version
Plan a move off an old SQL Server version with a complete inventory, compatibility testing, a supported target, and a dated exit plan.
SQL SERVER – SELECT 1 vs SELECT * – An Interesting Observation
SELECT 1 vs SELECT * inside IF EXISTS: I ran 4 tests and both gave the same result and the same execution plan cost. Can you find a case where they differ?
Templates and Snippets in SSMS
Templates and snippets in SSMS turn repeated SQL patterns into editable starting points while keeping environment assumptions visible.
ROUND or Truncate: Keep Decimal Width in View
ROUND or truncate is a choice about the result, not its display format. This complete decimal example checks positive and negative values while preserving enough width for thousands.
SQL SERVER – Understanding Licensing Models
The licensing structure has evolved to reflect advances in technology and diverse use cases. Below are the primary licensing models available: