That warning is pretty straight forward. Somewhere in the code a string is getting placed that's just too long.

Also, on a side note, instead of using @@IDENTITY, I'd suggest you...

San (4/6/2009)

---

Dear All,

Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME...

I liked the podcast even more than the editorial.

I don't think you were only pointing at those asking questions when you suggested we needed to treat others as we...

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...