Gail,

No offense, I appreciate that position. I was a consultant for 10 years (certainly not as a DBA), so I do see the value they represent. I believe...

I do appreciate everyone's comments, but, I'm not talking about a reporting server - at least not in the classical sense. For what it is worth, we do already...

John,

Thank you for the answer, however, I don't know if you understood my suggestion. I am only describing the production environment. I agree I would also have dev...

Well, I don't have a full solution, but, I have an acceptable work around. I batched up the updates for one key lookup and noticed that the batches got...

This is odd. I updated 100% of statistics on my table, and an update statement for 50,000 rows went very quickly, less then 1 second. Then I tried...

Regarding the Updating of Statistics... I have read up on it, and thing I have it under control. I'm currently updating with 1% of rows as a test. ...

Noel,

Thanks for the response. Pardon my ignorance (I'm not a trained DBA, but I'm acting as one currently) - any tricks to updating my statistics? Or is it...