• Just on a side note, be careful with indexed views, particularly top 10 views and the like. On paper it doesn't look like they'll cost much overhead, they're only monitoring 10 rows. In reality, they're not. Almost every update/insert/delete on any connected table will cause this view to refresh.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA