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

That answer leaves umpteen things unanswered. You statement could be this:...

Nothing personal here but you have made design and indexing choices that tell me that you have absolutely no hope of successfully interacting with a 14B row FAT table. ...