Are the stats up to date and the indexes defragged (or rebuilt)?

... and 1 more point.

All those spools are generating 59 GB of data... 172 times the total size of the DB.

A couple more points to ponder on :

StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut"

That means that the server has given up on finding a "decent" plan to execute that query. So breaking...

I would actually start with this.

It will most likely give you the best bang for your time invested :

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

shifty1981 (1/7/2011)

---

Ninja's_RGR'us (1/7/2011)

---

shifty1981 (1/7/2011)

---

Ninja's_RGR'us (1/7/2011)

---

Well the GB left is the GB left. As you know, sql will grab all it can.

So if you have plenty of ram left after...

shifty1981 (1/7/2011)

---

Ninja's_RGR'us (1/7/2011)

---

Well the GB left is the GB left. As you know, sql will grab all it can.

So if you have plenty of ram left after the server's...

3% is treshold, assuming this is an heavy log table, then it could have swapped.

The other option is an implicit cast that forces a scan. I'd need to see...

A seek is a costly operation. Even 3% of the table is enough to justify a scan (can be even much less than that).

It's on the left of the box when you type your post (see attachement).

Here's the big picture of how I go about this.

1 - What's the total processing time?

2 - What's the query processing time?

From there you know where it hurts (SSAS, or...

Without more details, I can only tell you to do less work on the SSRS.

How long does it take to run the MDX?

Well the GB left is the GB left. As you know, sql will grab all it can.

So if you have plenty of ram left after the server's been up...

The declare needs to be inside the dyn sql.

Since that won't work, you'd need a temp table.

But then again you don't need a loop to do that. A simple...

Is it for an admin task of production code?

AVB (1/7/2011)

---

Ninja's_RGR'us (1/7/2011)

---

UDPATE T SET Weight1 = '0' from dbo.tTable1 WHERE Weight1 = ''

Also it might be worth it to convert that column to an integer or decimal. Then...