Congratulations again Paul. Extremely well deserved.

And...

Sorry to hear it. Take it easy and feel better.

Fixed it. Sorry about that.

David Benoit (4/1/2011)

---

Grant Fritchey (4/1/2011)

---

On a guess, the optimizer timed out trying to unpack the views and the "best" plan at the time of the timeout was missing the predicate...

On a guess, the optimizer timed out trying to unpack the views and the "best" plan at the time of the timeout was missing the predicate because the optimizer hadn't...

Absolutely. You should test each SP prior to putting it on your production system and that should take a week or two, just to be sure, but then, yes, you...

- Win. (4/1/2011)

---

Yes.

The step 3 and 4 has 19 storedprocedures, which pulls data from other source and which creates #temp tables and bulk inserts into my DB. Execution plan shows...

I guess it really depends on what the error is. XML is THE method of sending messages remotely. It's how BizTalk works. You can certainly use XML as a means...

In general, if you don't want to purchase a third party product, setting up server side traces and using the, free from Microsoft, RML Utilities.

But, if you want to spend...

I am frankly just a but nervous of certifications when I see them on a resume. Sorry, but there it is.

I wrote a few chapters in the book "Beginning SQL Server 2008 Administration." It covers a lot of the basics. I'd also strongly recommend getting Itzik Ben Gan's introduction to...

So you know the query that is causing the problem. What is that query doing? How is it hitting tempdb so hard? Can you get the actual execution plan and...

Paul Randal is recommending turning it on for all servers. That's good enough for me. I'd go for it.

If you have to pass large amounts of data between servers, either exporting to file or XML would be the way to go.

You'll only get disconnections if you have a timeout, either on the server or on the app, that is exceeded. Otherwise, the connection will way for the blocking process to...