auto creation of statistics

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » auto creation of statistics

auto creation of statistics

Rate Topic

Display Mode

Topic Options

Author

Message

VM-723206

Posted Wednesday, September 16, 2009 11:42 PM

SSChasing Mays

Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649, Visits: 263

Comments posted to this topic are about the item auto creation of statistics

Post #789402

Stewart "Arturius" Campbell

Posted Wednesday, September 16, 2009 11:48 PM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 3,129, Visits: 4,312

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

Hugo Kornelis

Posted Thursday, September 17, 2009 2:54 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:22 AM
Points: 5,244, Visits: 7,059

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

NinjaX

Posted Thursday, September 17, 2009 7:40 AM

Valued Member

Group: General Forum Members
Last Login: Monday, November 23, 2009 5:44 AM
Points: 73, Visits: 51

Very bad choice of words there. True or false can't be good answer to an is it possible question.

Post #789640

Steve Jones - SSC Editor

Posted Thursday, September 17, 2009 8:31 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 9:24 AM
Points: 31,433, Visits: 13,748

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 »

Permissions