InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 21:37:01 GMT20http://www.sqlservercentral.com/Forums/Topic789402-1495-1.aspxQuestion reworded to better match the T/F answerThu, 17 Sep 2009 08:31:23 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic789402-1495-1.aspxVery bad choice of words there. [i]True or false[/i] can't be good answer to an [i]is it possible[/i] question.Thu, 17 Sep 2009 07:40:37 GMTNinjaXhttp://www.sqlservercentral.com/Forums/Topic789402-1495-1.aspxBummer, 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...)Thu, 17 Sep 2009 02:54:19 GMTHugo Kornelishttp://www.sqlservercentral.com/Forums/Topic789402-1495-1.aspxIn 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)Wed, 16 Sep 2009 23:48:10 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic789402-1495-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/statistics/66969/">auto creation of statistics</A>[/B]Wed, 16 Sep 2009 23:42:49 GMTVM-723206