Viewing 3 posts - 1 through 3 (of 3 total)
Thank you Jeff, that is a good article. A few more considerations:
- adding with (nolock) in the select max subquery halves the time in the while loop approach here from...
June 18, 2014 at 11:55 am
#1722924
Our 2000 server was upgraded to 2008. There is a certain step in a DTS now SSIS package that updates a table, setting parents for child records, that used to...
June 15, 2014 at 7:12 am
#1721791
Thank you for the article, very useful.
Is it safe to say that it only applies to SQL Server 2005 & 2008 but not to 2000?
December 6, 2010 at 7:49 am
#1259027