Running @@IDLE returns a number that is hard to read. Here is what this system function measures and how to turn it into idle time you can understand.
How to Introduce Time Delay Between Two T-SQL Commands? – Interview Question of the Week #091
How do you introduce a Time Delay between two T-SQL commands? An interview question developers ask often, answered with WAITFOR DELAY.
SQL SERVER – Puzzle – Change in Date Format with Function
SELECT GETDATE() shows both date and time. A simple Date Format puzzle: show only the date part using a function. How many ways can you find?
SQL SERVER – Puzzle – Playing with Datetime with Customer Data
A customer sent me code that converts datetime values stored in his data. This puzzle is about playing with datetime conversions. Guess the output first.
SQL SERVER – Find Week of the Year Using DatePart Function
I plan my blog a week at a time. Here is a query using the DATEPART function to get the week of the year plus the first and last date of that week.
SQL SERVER 2016 – STRING_SPLIT Function Performance Comparison – Notes from the Field #118
Splitting strings once meant temp tables or CROSS APPLY. In Notes from the Field #118, Kathi Kellenberger compares STRING_SPLIT performance in SQL Server 2016.
Interview Question of the Week #046 – How @@DATEFIRST and SET DATEFIRST Are Related?
How are @@DATEFIRST and SET DATEFIRST related? One sets the first day of the week for your session, the other reads it back, and language matters too.