Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Statistics Expand / Collapse
Author
Message
Posted Tuesday, November 27, 2012 11:25 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 8:13 AM
Points: 43, Visits: 272
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_KEY RANGE_ROWS EQ_ROWS DISTINCT_RANGE_ROWS
2012052802 0 1 0
2012053003 1 1 1
2012053102 0 1 0
2012060102 0 1 0
2012060402 0 1 0
2012060602 1 1 1

Thanks in advance

Post #1389516
Posted Wednesday, November 28, 2012 12:21 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
Duplicate post. Original thread can be found here:

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




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1389531
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse