And the size of the databases in production keep growing so you have to have 5-10 times as much space in dev since you have multiple copies of everything. Then...

Ah, I didn't see the bit about the rowmodctr. And I forgot all about it. However, since it only takes a single modification to make a statistic available for update......

Hmmm... It's my understanding that sp_updatestats does nothing more than cursor through all the tables in the system running UPDATE STATISTICS against them. I just rechecked that in the Books...

I've been losing this fight for years. Just recently we had the financial people get involved. When they found out that the developers couldn't guarantee consistent tests since the production...

If you're running it in conjunction, run it before and then run the new script.

No, running updatestats updates any and all statistics on the target you select. So if you need updated non-index statistics, great, but you're still going to get a sampled update...

Off the top of my head, I'm not sure. I don't think they would be affected negatively by running after the index rebuild.

If you do a full index rebuild, it has sampled all the data, just like an update statistics with a full scan. If you then run the sampled statistics update,...

That's a must for YouTube.

This is considered a late hit & piling on, but...

Go to 2008. That's what we're in the process of doing now. Skipping right over 2005. Based on product life cycles,...

GilaMonster (5/12/2009)

---

Grant Fritchey (5/12/2009)

---

Paul White (5/12/2009)

---

Vinoo (5/12/2009)

---

Please understand that this forum has people who are extreme experts on SQL Server who are champions in their field. It pays to be...

Alvin Ramard (5/12/2009)

---

Jack Corbett (5/12/2009)

---

Thanks, now I am...

OK. I get it. You can't open Books Online or do a search there. And you can't possibly connect to Google and do a search there. But you're perfectly capable...

This is a little old[/url], but it ought to help.

Paul White (5/12/2009)

---

Vinoo (5/12/2009)

---

Please understand that this forum has people who are extreme experts on SQL Server who are champions in their field. It pays to be polite and clear...