I wish I knew the problem but I've never seen that one.

Hopefully someone else will jump in and figure this one out with you.

Y

Would have been much better, 50% space saved in the DB, and then remove the signature and you're off to the races! :w00t:

GilaMonster (11/1/2010)

---

Bear in mind that you won't find...

GilaMonster (11/1/2010)

---

Optimisation level you should be able to pull out of the plan cache, though the xquery necessary won't be pretty. Probably best to dump the cache to a table,...

Yes I know this thread is 10 months old but I'm wondering if you guys have a way to trace this in prod?

I'm running a trace with xml plan but...

Rules or budget?

One way around this is to use a free tool or trial and PROVE increase productivity and code quality. Once that's done...

Chris Morris-439714 (11/1/2010)

---

Paul White NZ (11/1/2010)

---

Chris Morris-439714 (11/1/2010)

---

Nah mate my walking-on-water skills are still underwhelming - don't even drink the stuff, fish f...never mind. Spill the beans! I'll try to...

Oh and I forgot a big one... sorting is big on cpu as well. Reindexing is also a big one, must sort and then write to data and log...

No offense but my dev server is way more powerfull than that. (16 gb ram and 8 cpus).

2 gb of ram for dw is way too short. I applaud the...

The most obvious is aggregation work (and indirectly distinct).

So most reports you'll run will be cpu intensive.

However it depends on the query and system. You might have a cpu...

Sql promt of red-gate has this feature.

Why are you not allowed 3rd party developpment tools at work??

What's your setup??

ASP.net? subscription? data driven subscription?

Check out "Exists" in books online.

Well for 1, this is a 2005+ query and you posted in sql 2000 forum.

#2, you can find all you need to know in books online 2k5 about this.

The short...

That might be worth turning into an article at some point...

Use showplan xml. Somewhere near close to the top you'll find this node :

<QueryPlan CachedPlanSize="85" CompileTime="55" CompileCPU="31" CompileMemory="632">

This...