Well you say the query takes almost 3 minutes to run in QA and that the page fails around the same time.

Permission issue should be found long before that (assuming...

How long does it take to run the query from query analyser?

Sounds more like the problem is the query rather than the connection itself.

I was under the impression that you...

Wrong, it's not the amount of logins but the # of peoples.

You need 10 cals. I'd also confirm what is the tipping point between CAL and processor and verify...

Thanks for the help GSquared... it's on standard.

I'll give MS a ring when I have a chance.

Looks like my avatar fits me best as the youngest here at 29 :hehe:.

So looks like I should have started working with SQL SERVER at the ripe age of 13...

Craig Farrell (11/29/2010)

---

Ninja's_RGR'us (11/29/2010)

---

1 bazillion years of experience is going to cost you, period. We just happen to love sharing with people which makes useven stronger DBAs,...

GilaMonster (11/29/2010)

---

Well that would rule me out (were it even possible for...

Craig Farrell (11/29/2010)

---

Ninja's_RGR'us (11/29/2010)

---

Ya but they're basically asking to hire a Joe Celko or Paul Randal and the likes. No way in hell they'll get a quy like that...

GilaMonster (11/29/2010)

---

I bill $100/hour,...

Bug in post.

GilaMonster (11/29/2010)

---

I've seen corrupt stats on SQL 2000, but that's because on SQL 2000 the stats were stored in an image column in sysindexes. Never seen on 2005+. I'd start...

Craig Farrell (11/29/2010)

---

CirquedeSQLeil (11/29/2010)

---

Ninja's_RGR'us (11/29/2010)

---

Think 180K is a high price? Most consultants I know with anything close to that experience charge 250$+ / hour... so that's almost 60% discount...

CirquedeSQLeil (11/29/2010)

---

Ninja's_RGR'us (11/29/2010)

---

CirquedeSQLeil (11/29/2010)

---

Ninja's_RGR'us (11/29/2010)

---

Think 180K is a high price? Most consultants I know with anything close to that experience charge 250$+ / hour... so that's almost 60% discount...

My best guess at the moment is checkdb finding an error in a stat. ...

CirquedeSQLeil (11/29/2010)

---

Ninja's_RGR'us (11/29/2010)

---

Think 180K is a high price? Most consultants I know with anything close to that experience charge 250$+ / hour... so that's almost 60% discount on that...