GilaMonster (7/31/2014)

---

salomon.frid (7/31/2014)

---

I am aware of that one, just some people in my shop have told me that is not the preferred way of doing this ...

So according to your local experts, WAITFOR is not the best way to wait for a period of time...

And their reason is?

Do they recommend against using kettles to boil water too?

Any alternatives?

Well, I suppose you could put a WHILE loop 1 to a few million with a select statement inside. That'll certainly cause a delay....

Or write the whole thing in C# and use it's sleep function. Or call out directly to the Windows API and it's thread suspend (but that could have some horrible side effects)