sys.dm_db_stats_properties WHERE modification_counter < 0

• gary1

  SSC-Insane

  Points: 21152

  More actions

  September 11, 2013 at 10:43 am

  #279602

  Hi,

  In SQL Server 2008 R2 with SP2, we can get statistics that are NOT modified using the query SELECT * FROM sys.dm_db_stats_properties WHERE modification_counter < 0

  But I want find the same information in SQL server 2008 R2 SP1. Please advise what query I can use?

  Thanks,

  Gary

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 12, 2013 at 7:04 am

  #1649694

  This blog post[/url] might help and I think is how most people looked at stats.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question