• As great as "missing indexes" is, it is good to be aware of some pitfalls of the feature:

    http://msdn.microsoft.com/en-us/library/ms345485.aspx

    __________________________________________________________________________________
    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]