--create table and load it
CREATE TABLE dbo.Nolockontedere (
ID INT IDENTITY PRIMARY KEY CLUSTERED,
junk CHAR(1) NOT NULL)
GO
INSERT dbo.Nolockontedere (junk)
SELECT TOP 1000000 'a' AS junk
FROM master.dbo.spt_values a
CROSS JOIN master.dbo.spt_values b
GO
--Now, run a loop
DECLARE @dt DATETIME
SET @dt = DATEADD(SECOND,10,GETDATE())
DECLARE @counter INT
SET @counter = 0
DECLARE @trash int
WHILE GETDATE() < @dt
BEGIN
SELECT @trash = ID
FROM dbo.Nolockontedere
WHERE ID = CONVERT(INT,RAND()*1000000)