Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stats Updates Expand / Collapse
Author
Message
Posted Friday, May 2, 2008 6:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, September 12, 2009 9:12 PM
Points: 65, Visits: 224
Hi,

We need to create a maintenance paln to make sure that all tables/indexes/views are calculated with new statistics updates

Is there any other method to do the same



Regards,
Smm
Post #494159
Posted Friday, May 2, 2008 7:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 7:20 PM
Points: 2,897, Visits: 5,978
Just out of curiosity, do you have auto-stats turned on? Is it not doing a good enough job for you?

You can see the following from BOL to get more information on updating statistics.
http://msdn.microsoft.com/en-us/library/ms187348.aspx

You could use the example to update all the stats for a particular table and wrap that inside of the undocumented sp_MSforeachTable stored procedure to recompute stats for all of your tables...

-Luke.


To help us help you read this

For better help with performance problems please read this
Post #494209
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse