SQL Server Statistics

• scziege

  SSC Veteran

  Points: 247

  More actions

  November 27, 2012 at 11:25 pm

  #267497

  Hi to all,

  is it possible to force SQL Server 2008 not to use Range_ROWS in its statistic ?

  I have the follwing statitic and want avoid the Range_ROWS, all should be zero:

  RANGE_HI_KEYRANGE_ROWSEQ_ROWSDISTINCT_RANGE_ROWS

  2012052802010

  2012053003111

  2012053102010

  2012060102010

  2012060402010

  2012060602111

  Thanks in advance

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  November 28, 2012 at 12:21 am

  #1562938

  Duplicate post. Original thread can be found here:

  http://www.sqlservercentral.com/Forums/Topic1389518-391-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP