Sometimes you just need a slow query to simulated a real big load of data being processed by the SQL-Server. You could either fill-up you database with a whole shit-load of data, or you use WaitFor Delay
instead:
WaitFor Delay '00:00:10'
Will pause the execution of the SQL-statement for 10 seconds – well, isn’t that sweet.