• You can also query the sys.stats DMV to findout information about what statistics exist on particular tables. You can join it to the sys.stats_columns DMV to get column info.

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]