While that does allow a single procedure to act on multiple tables, you're still only getting a single table per insert statement. You're just rigging the insert statements to sort...

Limiting parallel execution only eliminates deadlocks if the deadlocks are being caused by parallel execution. There are plent of instance where it's not.

In addition to use MAXDOP on the query,...

Right! Time to bring in the HR department.

Thanks.

I'm actually...

Since your databases are already offline, you've got failed installs and failed uninstalls on the same server, manually digging out will take way too long. I'd suggest backing up any...

You must mean really big tables.

But even then, the processing should be taking place on the server. I've seen things lock up when the data starts to come back from...

Cool. Glad I could help a little.

Just as a quick check, run sp_who2 to see what's happening on the server.

If you really can't figure stuff out from the suggestions so far, I'd look into checking on...

You absolutely can do it and it will work fine. Just understand, you will see contention on resources between the two servers, especially as the load increases on them. Make...

chris.stuart (4/3/2009)

---

I need to insert 800 million records (15 years worth of data) from my staging database to my final EDW database. The transform of the data in the table...

Yep. One at a time.

You can have a procedure that affects lots of tables, but that procedure will have individual statements for each table within it.

DISTINCT and GROUP BY are both methods of aggregating data. In general terms, neither is going to perform better than the other one.

In general practice, you need to structure...

That is strange behavior. I've never seen anything like it. If you can, post the code. If it's huge, post it as an attachment.

Do you have lots of PRINT statements...

Perry Whittle (4/2/2009)

---

once you start the restore process if you then kill it you have to wait for it to roll back, this could take some time, hence why it...

I'm not sure, I haven't used this myself, and I don't see anything in the documentation. One point, Books Online suggests using the dynamic management function sys.dm_io_virtual_file_stats instead of...