Groups > comp.databases.ms-sqlserver > #1479

Re: Some questions about relational indexes and statistics in SS2005

Newsgroups	comp.databases.ms-sqlserver
Date	2013-05-12 10:01 -0700
References	<34bd78e8-b0d3-447c-a5de-88d35d6b6383@googlegroups.com> <XnsA1B9DA262C7A3Yazorman@127.0.0.1> <78faabb3-916b-472e-98f2-095fa7f6dd9e@googlegroups.com> <XnsA1BC70DF44DF4Yazorman@127.0.0.1>
Message-ID	<87b07147-9222-4b42-a1af-c62765129e57@googlegroups.com> (permalink)
Subject	Re: Some questions about relational indexes and statistics in SS2005
From	rja.carnegie@gmail.com

Show all headers | View raw

On Friday, 10 May 2013 10:05:44 UTC+1, Erland Sommarskog  wrote:
> Not sure where you are heading here. Even if you add 
> statistics manually, SQL Server will still maintain them, 
> just like it maintains autostats.  Or do you plan to turn
> off automatic updates of statistics for the database?

I could do that for each statistic - but this is data
that is loaded once (once a night) into a database for 
enterprise reporting.  If it isn't updated after 
that, then the statistics don't need to be refreshed
again, and won't be - right?

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Some questions about relational indexes and statistics in SS2005 rja.carnegie@gmail.com - 2013-05-07 04:39 -0700
  Re: Some questions about relational indexes and statistics in SS2005 Erland Sommarskog <esquel@sommarskog.se> - 2013-05-07 21:26 +0200
    Re: Some questions about relational indexes and statistics in SS2005 rja.carnegie@gmail.com - 2013-05-09 14:45 -0700
      Re: Some questions about relational indexes and statistics in SS2005 Erland Sommarskog <esquel@sommarskog.se> - 2013-05-10 11:05 +0200
        Re: Some questions about relational indexes and statistics in SS2005 rja.carnegie@gmail.com - 2013-05-12 10:01 -0700
          Re: Some questions about relational indexes and statistics in SS2005 Erland Sommarskog <esquel@sommarskog.se> - 2013-05-12 19:22 +0200

csiph-web