Fast ordered delete

Fast ordered delete | Microsoft Share Point

Fast ordered delete | Microsoft Share Point — Thu, 21 May 2009 04:23:58 GMT

PingBack from http://microsoft-sharepoint.simplynetdev.com/fast-ordered-delete/

re: Fast ordered delete

Grumpy Old DBA — Thu, 21 May 2009 14:57:31 GMT

such a simple solution - I've just been working around applying an update based upon a TOP which of course will not take an order by - this makes a simple way around it - thanks.

DELETE TOP x rows avoiding a table scan

SimonS Blog on SQL Server Stuff — Fri, 22 May 2009 16:11:13 GMT

The simplest way to delete the top X rows is use to use a derived table. delete t1 from ( select top

re: Fast ordered delete

sunwei — Wed, 03 Jun 2009 18:01:03 GMT

Another way is using CTE

with d as

(

select top (10000) a from t

)

delete from d;

re: Fast ordered delete

LuborK — Wed, 10 Jun 2009 03:50:09 GMT

Thank you Simon and sunwei for you additions to my blog. Both derived tables and CTEs are great alternatives for views and I'm happy to see that they both work also in the case of the "efficient" delete!