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 – 2008 – 2005 – Find Longest Running Query – TSQL
My company owner asked which query runs longest and I found no ready script, so I wrote one: the Longest Running Query with its average and maximum time.
Rolling Date Ranges Forward Without Hard-Coded Years
Replace hard-coded years with indexed date ranges for current periods, full months, year-to-date comparisons, and any requested year.
SQLAuthority News – Recap Year 2008 – Two Most Important Event of My Life
Recap year 2008: the two most important events of my life were my SQL Server MVP award and marrying Nupur on December 12. Happy New Year to all.
SQLAuthority Author Visit Report – Tech Meetings – Recession – Job Market – Consolidation of Servers
In this blog post, I will discuss various topics which are related to various DBAs and Developers discussed in the recent market.
Is a Certification Worth It, and What to Study Instead
Decide whether a SQL Server certification supports your next role, then build practical study projects around recovery, security, and tuning.
SQL SERVER – Fix : Msg 15151, Level 16, State 1, Line 3 Cannot drop the login ‘test’, because it does not exist or you do not have permission
Msg 15151 said it cannot drop the login ‘test’, even for a sysadmin. The message was misleading: an open SSMS session for that login was blocking it.