My vote is that the optimizer is estimating a small number of rows and using index seek/bookmark lookup plan and/or nested loop join.

Jeff, haven't you learned by now that some questions just shouldn't be asked?? :w00t: 😀

Robert Frasca (12/21/2009)

---

Yes, I'm planning on attending the data camp and I hope to see you there.

I am familiar with the issue that Gail raises about "cursors in disguise". ...

In cases where you can get widely disparate numbers of rows back, which leads to ugly index seek/nested loop plans on kajillions of rows, I have found that the best...

sp_update_job, although I have no idea about this 'job caching' business.

By far the best advice I can give you is to get a good consultant on board to mentor you while the two of you work to figure out a)...

+1 for TextPad. I have been using it for at least 10 years. Awesome product.

Brandie Tarvin (12/17/2009)

---

The "single drive" is actually a SAN. It's either Raid 5 or Raid 1 + 0, but I'm betting on Raid 5.

The plan is to keep everything...

Trust? I don't trust any business entity - even my clients! As House said, "I don't ask WHY patients lie - I just assume they do". :hehe:

As...

tscott (12/15/2009)

---

I suspect it is the hard drive; therefore, I've run some IO tests just on the drive itself and the write times on the disc are incredibly slow. ...

LOTs of possibilities here (as usual). what type of mirroring? network speed/latency? have you done fileIO and waitstats analysis (on BOTH primary and secondary) to determine what...

Good stuff there Paul (as usual).

I would add that the OP can easily limit how hard this (and other parallelized queries) hit the box by setting MAXDOP, either for the...

1) the easy thing to answer is why reads are faster in production: more RAM, thus the table is being read out of memory - way faster than having...

Some of us on the SQL Server Microsoft MVP forum have been pushing hard for full and complete implementation of all possible actions, optimizer effectiveness, etc, etc with respect to...

1) since you mention this is for a TEST environment, I recommend you get Allan Hirt's book on SQL Server High Availability.

2) If you DO decide to proceed to doing...