RBarryYoung (2/6/2010)

---

Well, I am no fan of loops, but since the goal IS to slow things down, this ought to do it:

CREATE PROC EXERCISE_TEMPDB_SILLY AS

SET STATISTICS TIME ON

SET STATISTICS IO ON

CREATE TABLE #temp(RecNo INT PRIMARY KEY CLUSTERED, Data varchar(80))

INSERT INTO #temp SELECT -1, CAST(NewID() AS varchar(80))

DECLARE @cnt AS INT

SET @cnt = 0

WHILE @cnt > -1

BEGIN

Print 'Loop ' + CAST(@cnt AS VARCHAR(9))

INSERT INTO #temp

SELECT RecNo-Power(2,@cnt) , Right(Data + CAST(NewID() AS varchar(80)), 80)

FROM #temp

SET @cnt = @cnt+1

END