sp_updatestats or update with fullscan IIRC they don't do the same thing?

Grant Fritchey (8/25/2011)

---

CXPACKET waits are usually an indication of...

No offense, but the info you posted is useless to troubleshoot any further.

What do these 2 queries return? And DON'T do anything untill we say it's ok (easy to...

How did yo come up with that 10K suggestion?

not without seeing your current error message.

Then just make your group. Show group footer and make it as high as you need it and that should look like what you need.

Does it have to be a matrix? You an do that with a tablix. Not sure about matrix tho.

My best run was 90% + improvement on cpu, reads and duration across a normal day of prod.

The articles Gail wrote are clearly the way to go (which I used...

If it's THAT urgent, then I recommend hiring someone. Those articles are amazing but it takes time to assimilate them.

Jeff Moden (8/19/2011)

---

forsqlserver (8/18/2011)

---

Thanks Rozema and chris: My requirement is:

I have two databases one is of HRMS application and another for forefront application.Now some table data comes from HRMS database...

Why did you post this in corruption forum?

In that context it just doesn't make sens to switch to simple.

Whenever your start a trace with profiler, it will filter itself out from the trace. That's what you are seeing here.

If I had to guess, that mods you are doing completely change the execution plans. More importantely the estimates.

I can't say for sure without seeing the actual execution...

Got a reply today that the connect team was able to reproduce on the latest R2 and denali releases and that this bug will definitely get...

Steve Jones - SSC Editor (8/24/2011)

---

I believe that tablediff will do this. It's a free tool from MS, but it goes table by table. You could script the calls to...