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

auto creation of statistics Expand / Collapse
Author
Message
Posted Wednesday, September 16, 2009 11:42 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 6:34 AM
Points: 654, Visits: 265
Comments posted to this topic are about the item auto creation of statistics
Post #789402
Posted Wednesday, September 16, 2009 11:48 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:49 PM
Points: 3,964, Visits: 5,205
In all the years of using MSSQL (since 7), I have never encountered a situation where auto-creation of statistics has had to be disabled.
I have. however, encountered several situations where auto-update has failed due to the relevant table sizes, where we have scheduled a job to manually update stats on a regular basis (usually every 3 days)


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #789404
Posted Thursday, September 17, 2009 2:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:36 PM
Points: 6,002, Visits: 8,267
Bummer, missed a point because I overthought the question, figuring something so simple had to be a trick question.

I know of the AUTO_CREATE_STATISTICS settings. But this setting only affects creation of statistics for columns used in a predicate. When creating indexes, statistics will always be made, regardless of this setting. I though that this was the trick the author had in mind when asking the question.

(note to self: Remember, sometimes a question that seems simple, IS in fact simple...)



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #789461
Posted Thursday, September 17, 2009 7:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, April 4, 2014 5:49 AM
Points: 73, Visits: 55
Very bad choice of words there. True or false can't be good answer to an is it possible question.
Post #789640
Posted Thursday, September 17, 2009 8:31 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,018, Visits: 15,456
Question reworded to better match the T/F answer






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #789680
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse