No business impact at all - ran this through the middle of the business day with no lock issues. Give it a try and let me know.

At the time the IT budget was non existent. It happens and DBAs need tools to shrink database in times like that. The tone was meant to be...

Get a new CFO I guess.

Thanks for the comments.

In this case the data was ancient unread so removing the rows was needed. There was a significant performance improvement by removing the rows. Alas...

In the process of analyzing the data I focused on inserts/deletes as that is how our system are designed, in the actual migration on the critical high volume DBs I...

Hi Andy:

Yes - ours is a high insert OLTP environment, percentage of updates on our systems is low so for this migration it didn't matter. But tracking updates is...

Thanks for the comment.

I've had inconsistent result with -skiperrors, altering the stored procedures always works. This approach is at the table level so it limits the impact to just...

Yes the synch would apply on failed updates and inserts. I'll check out your web site. Thanks,

Thanks for the comments. In my shop it's usually 1 article that has issues due to rows being changed on the subscriber, and that's another article, so I use...

I use the filter in Redgate to limit the number of rows - this runs quick enough on large table:-). Make sure to pick the primary key for best...

Thanks for all the comments. I add that my shop doesn't ever go offline - we are truly 7*24*365. The article discusses one technique to remove obsolete rows...

I see the issue here, yes the left over rows aren't deleted on purpose. My goal is to remove 50 million rows using 2000 row chunks so yes there...

Well your view was not defined as discussed in the article, for more fun try these statements and the data is returned in order - always.

CREATE TABLE t1 (x INT...

BTW - Ceiling works here because these are integer variables.

Thanks,

Try this.

CREATE VIEW dbo.test as (SELECT top (100) * from table ORDER BY primary_key_column). Look at the result they will be ordered.