November 15, 2009 at 1:03 pm
Hi,
a new DB (sql 2008) hase been created (changing the collation). all data have been "bcp in" from the previous BD (sql 2000)
Now, is it possible to RE-create rapidly all _WA_SYS... that have been losted ?
Thank you
Calico (MCP MSTS)
November 15, 2009 at 1:53 pm
If you leave auto create statistics on for the database these will be re-created over time. If you believe you require some of them urgently to maintain performance you could run create statistics.
If you find these are required to maintain performance you should investigate indexing some of the columns as SQL creates these statistics on columns where it believes an index would be useful based on the queries run against the table.
---------------------------------------------------------------------
November 15, 2009 at 2:49 pm
i'd agree with George on his advice. If you want to create similar values from your old server, run a sample workload from Profiler/Trace against the new server to get it to create statistics needed for queries like you will be running.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply