It really depends on the system. We have a few tables on a couple of databases where, due to some issues, we're running update stats a couple of times a...

I'm not aware of that one. Most of the showplan events are under the Performance section. Make sure you have "Show all Events" selected.

The way to do something like that would be with at least two tables. The first table would hold the information about the person. The second table would hold relationships...

I've seen a few posts like this where the odd query or three gets messed up by the upgrade, but I've never seen any large number of procedures get messed...

Bruce W Cassidy (4/15/2009)

---

[font="Verdana"]Warning! Mini rant!

I'm reading an article (it's work related, okay?) and I run across this paragraph:

"The first and most obvious reason is that the DW appliance...

GilaMonster (4/15/2009)

---

One question that pops to mind. Did ANSI create...

If I'm reading the data correctly, the estimated rows on the 2000 query is 13 right through, but the estimated values in 2005 are all over the place, from 1...

I am confused as to why the performance is so different between the two, but the fact that performance is sub-optimal is because of the functions on the columns in...

You can use SET SHOWPLAN_ALL or SHOWPLAN_TEXT.

ALL provides more information but it's more difficult to read. Let's go with ALL despite the difficult, but you can post both.

Two things.

First, and most important, the costs displayed in execution plans are estimates. They are not accurate measures of anything. While you may or may not see a cost go...

Can you post the actual execution plan instead of the estimated one? I'd really like to see, as much as possible, what's happening.

This is a weird one. Also, can you...

Story of my life.

Here's a video on exactly how to capture the execution plans & post them to SSC.

If I were doing that particular insert, I'd use the OUTPUT clause as part of a single transaction. That will allow you to insert into the BusinessEntity table and any...

Do you see an error? Is the process waiting for a long time? Disconnected?

A little more information would sure be helpful.