If you just want the query to wait, use something like this:
WAITFOR DELAY '23:59'
Or, if you want to crash the system, use something like this (This is just an example, be as aggressive with the 10000 or the number of cross joins, and the columns in the table.)
CREATE TABLE #tmp (id INT IDENTITY(1,1));
INSERT INTO #tmp DEFAULT VALUES
SELECT * FROM #tmp a CROSS JOIN #tmp b CROSS JOIN #tmp c