Why does revision 12 sort before 7? Because the parts are text. Here is how PARSENAME fixes it, and where it trips you up.
SQL SERVER – Difference Between ORIGINAL_LOGIN() and SUSER_SNAME()
What is the difference between ORIGINAL_LOGIN() and SUSER_SNAME()? A quick script with context switching shows when the two return different logins.
SQL SERVER – Query to Get Unique Distinct Data Based on Condition – Eliminate Duplicate Data from Resultset
DISTINCT and GROUP BY do not always help. I use ROW_NUMBER to eliminate duplicate data and keep only the record with the highest price.
SQL SERVER – Answer – How to Convert Hex to Decimal or INT
Readers sent great answers on how to convert Hex to Decimal or INT in SQL Server. Here are their solutions, with due credit, using 0x00000100 as the example.
SQL SERVER – How do I Record Video and Webcast – Milestone – 2200th Blog Post – SQL in Sixty Seconds #022 – Video
My 2200th blog post and the 22nd SQL in Sixty Seconds episode: a short video on how I record video and webcast content, plus thanks to the people who help.
Exchange Spill: When Parallel Streams Write to tempdb
Tempdb writes during a parallel query, with no sort warning in sight? Here is a demo that spills every time, and how to find the operator.
SQL SERVER – Observation of Top with Index and Order of Resultset
Adding an index can change which rows TOP returns when there is no ORDER BY. I share three real cases where the order of resultset was blamed on the wrong thing.