Is there to way write a T-SQL command to just make it sleep for a period of time? I am writing a web service asynchronously and I want to be able to run some tests to see if the asynchronous pattern is really going to make it more scalable. In order to “mock” an external service that is slow, I want to be able to call a SQL server with a script that runs slowly, but isn’t actually processing a ton of stuff.
