NO STATS:() even with AutoCreate Statistics is ON

• JoseRocha

  Mr or Mrs. 500

  Points: 574

  More actions

  November 25, 2013 at 8:11 am

  #282842

  Hi guys,

  I did a profile in my SQL Server and got several events named "Missing Column Statistics". However the database which is informed in the TextData column has the option "Auto Create Statistics" turned on. Someone knows why SQL Server didn't created it ?

• AJ@SQL

  SSC Eights!

  Points: 811

  More actions

  November 27, 2013 at 3:58 am

  #1669395

  Please try to run the select statement on the table filtering on the column missing statistics and sql should automatically create statistics.