A cursor in SQL Server took 260 milliseconds where one SELECT took 4. Why the gap exists, how to turn a loop back into a set, and the three cases where a cursor really is the right answer.
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 – 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.
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name – Part 2
Readers improved my script to find column used in stored procedure. Imran Mohammed shares newer scripts to search stored procedure for column name.
SQL SERVER – Generate Script for Schema and Data – SQL in Sixty Seconds #021 – Video
Need to move part of a database along with its data? SQL in Sixty Seconds #021 shows how SSMS can generate a script for Schema and data together.
SQL SERVER – Remove Debug Button in SSMS – SQL in Sixty Seconds #020 – Video
The SSMS debug button sits next to Execute and looks like a play button, so people click it by mistake. This short video shows how to remove it.