Dynamically create drop user statistics scripts

• oradbguru

  Hall of Fame

  Points: 3126

  More actions

  December 26, 2013 at 8:47 pm

  #280834

  Comments posted to this topic are about the item Dynamically create drop user statistics scripts

• SoHelpMeCodd

  SSCertifiable

  Points: 5871

  More actions

  May 13, 2014 at 7:25 pm

  #1713292

  Running this script can generate Missing Column Statistics events. If those events are associated with statements that subsequently run longer, SQL Server is expressing a need for a user to create statistics (i.e. exactly the opposite of what this script is attempting to do).

  For more information about the event, see http://social.msdn.microsoft.com/Search/en-US/sqlserver?query=missing%20column%20statistics&refinement=49&beta=0&ac=5 and http://www.sqlservercentral.com/search/?q=missing+column+statistics

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  April 27, 2016 at 1:40 pm

  #1875054

  SoHelpMeCodd (5/13/2014)

  ---

  Running this script can generate Missing Column Statistics events. If those events are associated with statements that subsequently run longer, SQL Server is expressing a need for a user to create statistics (i.e. exactly the opposite of what this script is attempting to do).

  For more information about the event, see http://social.msdn.microsoft.com/Search/en-US/sqlserver?query=missing%20column%20statistics&refinement=49&beta=0&ac=5 and http://www.sqlservercentral.com/search/?q=missing+column+statistics%5B/quote%5DThanks for the extra insight.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  April 27, 2016 at 1:41 pm

  #1875055

  Thanks for the script.