ALZDBA (9/14/2010)

---

GilaMonster (9/14/2010)

---

And you're obviously one of...

And...

We're waiting.

Rebuilding the indexes should have also rebuilt the statistics, so I wouldn't necessarily assume that's where the problem lies. Without seeing the queries & execution plans it's hard to know...

coolwebs (9/13/2010)

---

A possible useful query to further investigate the query plan use counts, if this is suspect.

SELECT usecounts,

cacheobjtype,

...

I agree with the ANSI settings. That can result in different execution plans for the same procedure. But, you might also be seeing parameter sniffing. Are all the apps running...

Blanket statements are usually worthless, so with that in mind...

I'd suggest, at a minimum, making the PK's clustered instead of non-clustered. Probably they're the best access path to the data...

I think in this case it would be "with friends like these, who needs anchors." Works at about the same I imagine.

GilaMonster (9/12/2010)

---

Anyone want to take this one up? http://www.sqlservercentral.com/Forums/Topic984249-9-1.aspx I've so far been shouted at and told how I should be helping, and I'm about out of patience and running...

Can't get to Facebook from work and my phone won't let me watch Flash (damn Verizon...

Stefan Krzywicki (9/10/2010)

---

Grant Fritchey (9/10/2010)

---

Jack Corbett (9/10/2010)

---

Steve Jones - Editor (9/10/2010)

---

Never read about Collosus. I'm assuming this is the Xmen guy?

I always find time to read. Keeps me sane with...

Here you go. First in a trilogy. Ancient stuff.

Jack Corbett (9/10/2010)

---

Steve Jones - Editor (9/10/2010)

---

Never read about Collosus. I'm assuming this is the Xmen guy?

I always find time to read. Keeps me sane with a break from this...

Yeah, I like using trace events to see what's being run against the database and then determine where to spend my time tuning.

In addition to Gail's advice, try some of the classic deadlock resolutions. Check the code to ensure that everything is accessing the tables involved in the same order, stuff like...

I'd suggest reading through this article[/url] from Jeff Moden. He really lays down some great methods for going through comma seperated fields like that.