The queries are not the same. You are sorting by constant and you should order sort by the id in order to get the same results, right?

g.britton (9/4/2015)

P Jones (3/6/2013)

WHILE 1=1

BEGIN

DELETE TOP (5000) FROM table WHERE .....

IF @@ROWCOUNT < 5000 BREAK

END

and you can add a WAITFOR to delay between iterations

Adjust the 5000 to suit...

Thanks a lot. You may want to edit the article a little bit since on Window 8.1 you can choose from two types of VM generations (and of course I...

As far as I know Red Gate SQL Test is based on this.[/url]

Thanks for the questions. The subquery in ORDER BY clause is possible.

I really want to see the performance difference between index on int/bigint column and datetime2 column.

What about a new tutorial using `Gzip` and SQL Server 2012?

What about supporting UTF-8 compression, too - compress `NVARCHAR(MAX)`, too.

We are using the sp_whoisactive stored procedure. You can check it:

http://sqlmag.com/sql-server/spwhoisactive

or downloaded it from here:

http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx