SQLkiwi (7/26/2011)

---

I do want to respond to the comments about CXPACKET though. Very few people understand what CXPACKET truly means (and I do not number storage engine experts among...

Never tried this, no idea how to do it at the moment.

Stefan Krzywicki (7/26/2011)

---

Chad Crawford (7/26/2011)

---

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

---

Chad Crawford (7/26/2011)

---

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now,...

Roy Ernest (7/26/2011)

---

Now here is one of the reason why I raised the question of MAXDOP. I never did like the idea of giving MAXDOP 1 on the server level....

SQLkiwi (7/26/2011)

---

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

---

That bugs me that you don't see anything for the DegreeOfParallelism either. Looks like there's something I don't understand in there (either the caching or the XML...

Chad Crawford (7/26/2011)

---

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

---

Chad Crawford (7/26/2011)

---

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I...

Edit : Saw Paul's answer after I posted. I'd deffer to his experience rather than my very limited knowledge with this.

I'm sure you're on top of this but stale...

GilaMonster (7/26/2011)

---

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

---

Assuming the db is usable on sql 2000, wouldn't scripting the table and redeploying on 2k5 (or even 2000), possibly after changing the collation to something else "save...

Good or bad surprised? What and how did you trace the changes?

Roy Ernest (7/26/2011)

---

Your second query is still running. But your first query here is the output.

counterfinal cost

occurrence 3189815

AvgValue2.77

namecost threshold for parallelism

config_value5

run_value5

Days Server UPTIME & Last Stats Reset167.50

Stats WarningNULL

Cost Threshold WarningNULL

Restart...

Chad Crawford (7/26/2011)

---

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I stumbled across a really...

Yup, I "gut" my script inspiration after that thread. Very nice info.

I personally use this :

http://www.red-gate.com/products/sql-development/sql-prompt/sql-refactor

It's now only available with SQL prompt which is a very nice intellisence application for SSMS.

It can literally refactor 1000 lines of code in 1-2...

That works for me :

@query = 'SET NOCOUNT ON; SELECT * FROM [DB].dbo.RPT_Space_Warnings WHERE DateWarning = DATEADD(D...

I'm on sql 2K5 SP3 standard 32 bit

and I've seen similar issues. I don't remember if it was for the data or log file(s), but I've seen on several...