GilaMonster (1/3/2012)

---

Just to put things in perspective, the chapter that I'm referring you to is...

Stefan Krzywicki (1/3/2012)

---

Ninja's_RGR'us (1/3/2012)

---

MysteryJimbo (1/3/2012)

---

Ninja's_RGR'us (1/3/2012)

New year has nothing to do with his incompetence (ignorance) and his not following strict orders. That server is on total lock down and...

Yes, read the book!

She's not lazy, it's not something she can answer in 2 words.

MysteryJimbo (1/3/2012)

---

Ninja's_RGR'us (1/3/2012)

New year has nothing to do with his incompetence (ignorance) and his not following strict orders. That server is on total lock down and it requires 3...

Nothing pers Dev.

PS, it's 300-ish people down, not 3000.

Dev (1/3/2012)

---

Ninja's_RGR'us (1/3/2012)

---

Dev (1/3/2012)

---

Ninja's_RGR'us (1/3/2012)

---

...

Fire. Someone did an unauthorized mod on the prod server's vm (ERP 3000 employees on stand still). Now it won't...

Dev (1/3/2012)

---

Ninja's_RGR'us (1/3/2012)

---

Brandie Tarvin (1/3/2012)

---

So, skirting the edge of the "no tech speak in The Thread" rule...

How is your first week of 2012 shaping up work wise? Are...

Brandie Tarvin (1/3/2012)

---

So, skirting the edge of the "no tech speak in The Thread" rule...

How is your first week of 2012 shaping up work wise? Are you in firefighting mode...

If I had to guess (which is all I can do here), it probably means that your CRM opens a IE window inside the GUI.

I'd go in all the local...

@GL

Ninja's_RGR'us (12/30/2011)

---

GSquared (12/30/2011)

---

There's a lot of material out there about locking, and its history and relation to parallel processing of other sorts, but a common-sense article on it might be...

Actually can you post the actual execution plan?

Unless you have major blocking this is more a case of tuning the query than tuning hardware & server.

I'd check wait stats and use sp_whoIsActive (a lot more info than sp_whoX)

http://sqlblog.com/files/default.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx

george sibbald (12/31/2011)

---

you only need to run dbcc checkdb on a regular basis, as all the other check commands are a subset of this one command (checkalloc, checktable etc).

so this...

+1

Dev (12/31/2011)

---

ESAT ERKEC (12/31/2011)

---

We have a ERP system and that tables will not use 2012.

I can set this tables index fill factor 80 to 95 in...