• Lowell (7/5/2013)


    you missed Sean's snippet where you have to use a DAC(Dedicated Admin Connection) in order to see the statsblob; if you do that, the dmv sys.sysobvalues would be accessible.

    Ah yes, my bad; I'll try that.

    Incidentally I did a little test updating the stats of a 1-GB table before and after deleting duplicate stats.

    I found a 20% reduction in execution time of the UPDATE-STATS command after dropping the duplicate stats.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]