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.