Just saw this on Hacker News and immediately thought of this long running thread: http://mattgemmell.com/2008/12/08/what-have-you-tried/[/url]

The Hacker News comments are interesting as well.

After taking a step back and re-reading your op it seems like the biggest hurdle here is scanning through all the tables. Or at least, setting that up for...

Tom Brown (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

Tom Brown (9/6/2012)

---

Anyone from the UK remember BT Phone Day - back in the 1990s sometime, the UK phone company changed all number prefixes...

Or... you could rewrite the entire application in MS SQL 😉

Whichever way you decide to go, it sounds like it's going to be a lot of work.

So far we have "it's management's fault" and that's all? I agree that's probably more often the case than not but doesn't the person writing the code bear some responsibility...

One more, I stumbled across this today while looking for something else on TechNet. Remembered this thread and thought it was worth sharing:

http://gallery.technet.microsoft.com/scriptcenter/Storage-IO-Performance-d628bad9

Right, forgot about the part where you mentioned the site-to-site links are slow, high latency. How does executable know about a change? Does it assume the copy at your...

John Hanrahan (9/6/2012)

---

Steve,

I'm surprised no one mentioned algile development practices. It seems like agile is another word for minimal testing. That's fine when the consequences of your code...

I used to do this a long time ago. The way I accomplished it was to write a FoxPro program that chopped the file up into chunks based on...

The Stairways series is a great place to start. One thing I've always found makes learning easier is to pick something like a problem you want to solve or...

Funny timing. We've seen something similar recently but on a 2008 instance (not R2). I'll be interested to hear if anyone has anything on this.

Does...

I'd start by profiling that process or at the very least that sproc. Look at the execution plan and start optimizing there. What about it is costly? Could...

Where to begin? You're talking about performance tuning from every angle. Best suggestion would be to start with a specific problem or two and work those out. What are...

Glad you managed to work it all out.