WAITFOR makes a T-SQL batch pause for a set time, or until a clock time, before the next statement runs. I show both uses with small examples.
SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2
Which way to select only date part from DATETIME is faster? After more tests on large tables, I now suggest the DATEADD and DATEDIFF method over CONVERT.
SQL SERVER – Interview Questions and Answers – Part 6
Part 6 of my SQL Server Interview questions and answers covers SQL Server 2008, starting with what the master, msdb, model, tempdb and resource databases do.
SQL SERVER – Few Useful DateTime Functions to Find Specific Dates
Useful DateTime functions from Vivek Jamwal: find today, yesterday, and the first and last day of the current or last week and month with DATEADD.
SQL SERVER – Get Date Time in Any Format – UDF – User Defined Functions
Nanda shared a detailed UDF to get date time in any format you need. Save it in your code bookmarks, download the script and try my examples.
SQL SERVER – 2008 – Get Current System Date Time
Several ways to get the current system date time in SQL Server 2008, from GETDATE to the newer functions, with a quick video on the topic.
SQL SERVER – 2008 – Find Current System Date Time and Time Offset
SQL Server 2008 adds SYSDATETIMEOFFSET, which returns the current system date time along with its time offset from GMT. One line shows how.