• Did you guys hear about this awesome new feature in SQL Server called indexed views? It is so awesome that you can create 999 indexes on a view and have faster running queries while at the same time never having to worry about things like disk space (which you would with a table).

    This is so freaking awesome!!!

    Wait, why are we suddenly out of disk space?

    </sarcasm>

    Trying to get developers to understand that an indexed view is not the silver bullet they seek and that better tsql has the same perf benefits (as some of these indexed views they are creating) without the disk cost. sheeeeeeeeeeeeeeeeeesh

    They just want to keep creating more and more indexed views. So much so they have already doubled the size of their 1TB+ database in the last month.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events