Jack Corbett (4/22/2011)

---

Lots of good advice here. The one thing I learned back when I used linked servers is that you should do as much work on the linked...

P.S. I specifically recommend that you do not REORGANIZE your indexes. Reorganization (defragmentation) takes about 8 times longer than rebuilding, if pages in the table are exclusively locked, the reorg...

There are so many, and they are so situation-specific, that this open-ended question goes WAY beyond what a forum post...

Grant Fritchey (4/21/2011)

---

Usually others say this, but it's my turn. It really sounds like you're completely over your head here. I'd suggest hiring, even part time, a pro, someone who...

Steve I really don't understand how you can expect us to help you with so little information given, especially in your first post! Help us help you! 😉

1) as someone else said, update stats on all tables and try again

2) you may have reached what is known as a "tipping point", wherein the number of rows in...

For one of the first times I can ever think of I will differ from Grant! I never leave maxdop at 0. On your config (with LOTS of...

You have TWO sections of "bunches of logic". The question here is if those two sections take much work. If they do, then the cost of a recompile (unless...

Glad to help!

I have had great success at clients using replication to help avoid cross-server data access...

VERY impressive splitter improvements there Jeff! Well done!!

There is an alternative - 2 of them actually. The first is to not do this kind of multi-datatype-column design. 😎

The other is to use my favorite 4 letter...

If you need to stay online while this is going on, you must batch the updates into smaller groups of say 1000 to 5000 records at a time using an...

1) Your best bet BY FAR is to have a qualified professional remote into your machine and debug the perf issue. Probably take under an hour for said individual...

I would...