WAITFORis a very useful command to prevent further operations from occurring until a certain amount of time has passed (
WAITFOR DELAY) or until the clock strikes a specific time (
WAITFOR TIME). These commands are covered quite well (including pros and cons) in a previous tip, “SQL WAITFOR Command to Delay SQL Code Execution.”
WAITFOR DELAYis also commonly used to “let SQL Server breathe.” For example, when performing some operations in a loop, on a resource-constrained system, an artificial delay can potentially allow for more concurrency, even if it makes the intensive operation take longer.
But these commands can also be used to synchronize multiple query windows for local testing and debugging, and I thought I would share a recent example.
Click through for some of the ways you can use
WAITFOR in your scripts.