john.arnott (5/22/2009)

---

As any afficianado of baseball knows, even if a player or manager curses up a storm in arguing a call with an umpire, he'll be tolerated so long as...

Christopher Stobbs (5/22/2009)

---

OK time for some sleep, I've lost my marbles... Sorry Carl, I'll try have another look at this next week if you still need.

(Bookmark lookups don't happen with...

Dave (5/21/2009)

---

Many belated thanks for the applause.

And did I mention that we have 45 episodes of Stargate: SG-1 queued up on...

Not having to work with SQL Server 2000, I'm not sure the best way to have the OP here to pull the execution plan for review.

Could someone provide some additional...

I suggest comparing the two actual execution plans. You may also want to post the plans here, but I'm not sure how to have you do that with SQL...

GilaMonster (5/22/2009)

---

Lynn Pettis (5/21/2009)

---

Paul White (5/21/2009)

---

Would be fascinating to know who 'flamed' Gail. Personally I would love to take a look at the discussion that prompted it and take...

Alex Prusakov (5/20/2009)

---

Is AWE enabled? With 32-bit OS you need to enable usage of memory over 2Gb. Usually, if server has 8Gb doesn’t mean SQL Server is using it.

Also, check...

Paul White (5/21/2009)

---

Would be fascinating to know who 'flamed' Gail. Personally I would love to take a look at the discussion that prompted it and take the opportunity to...

Sorry guys, but I mellowed my post. I checked his profile and he has only been a member of this site for about 6 months. He may actually...

I realize that you have only been a member of SSC for about six months, but in this time I would have hoped you would have learned something about SQL...

Alvin Ramard (5/21/2009)

---

Lynn, is there...

Are we talking about our...

Would anyone mind if I asked him how he got this job if he can't even figure out how to read error messages and complete simple tasks?

john.arnott (5/21/2009)

---

I don't have the old QM anymore, but in my SQL2005 SSMS connected to a SQL2000 engine gives the same behavior, including the interpretation of "E"xponent notation. Interesting...

RBarryYoung (5/20/2009)

---

Lynn Pettis (5/20/2009)

---

As long as you remember this...