• Jeffrey Williams (8/10/2008)


    Well, according to BOL - no, you don't have to update usage.

    Hmm, yeah I see where it says that Jeff. I may be wrong here, when I wrote my view (about 2-3 years ago) I was still working on both 2000 & 2005 most days and I remember having accuracy problems that ultimately caused my to add DBCC UpdateUsage periodically. But it may have been only happening on SQL 2000.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]