July 2005 - Posts

• Don't rely on undocumented features

  I'm as guilty as anyone, but, with the advent of Yukon, I think we're really to the point where many of the undocumented features the user community has come to rely on are no longer needed. The SQL Server development team has made a concerted effort Read More... Posted Wednesday, July 20, 2005 5:41 PM by khen1234 | 4 Comments

• A WAITFOR UNTIL implentation for T-SQL

  You've probably encountered situations where you needed to pause the execution of a stored procedure until some condition became true or needed to run some code when a condition became true. If the condition is time-based, WAITFOR TIME | DELAY can come Read More... Posted Friday, July 08, 2005 5:41 PM by khen1234 | 2 Comments