Would like to add to the ETL discussion. One of the primary reasons for ETL is to extract data from OLTP systems and minimize the impact of long running...

Nice article!

Solomon, here's the article I wrote that similar but instead uses change tracking. [/url]

I've got to echo the previous comments. Thanks alot! I only wished I had found it sooner. Added to the briefcase.

Ron, there are several benefits in using a remote log shipping monitor. They include

1. Centralized monitoring and alerting solution. If you have several instances participating in log...

Hi Rick. That's still a viable option but we wanted to avoid locking the table and minimize downtime during these changes.

Very cool ssandler! I didn't even think of using merge.

Great suggestion Thomas! I may do that in the near future.

Hi Dan. In this example we are going from nvarchar data types to varchar. The Person.Person_nonunicode table contains these changes.

Edit. Step 3 at the bottom of the article states "Add all constraints to the new table and all referencing Foreign Keys. These were added with the "no check"...

We've implemented it in our QA environment for a division within our company. Ramping up for a deploy across the enterprise.

I purchased this book a couple of months ago. It has several useful techniques that could go along with this topic. Refactoring Databases: Evolutionary Database Design

Solomon, this is a great post and thanks for sharing! Just this last week I took a similar approach with 4 large tables that had multiple columns being changed...

Great article! I haven't seen this issue as of yet in my environment using "WITH RECOMPILE".

Environment - SQL Server 2005 x64 sp3 cumulative update 6

Id agree with Grant here. We were having the exact same issue as you are currently seeing (with the arithabort off). After careful consideration I added to the...