• Koen Verbeeck (3/20/2012)


    According to CREATE VIEW (Transact-SQL):

    When a view is created, information about the view is stored in the following catalog views: sys.views, sys.columns, and sys.sql_expression_dependencies.

    Information that is stored in system tables also consumes space...

    Yah... I worried when I selected the "correct" answer that this would be used against me.

    I was glad that it wasn't but I suspected somebody would say something about it.

    some days when I answer these I'm convinced that no matter which answer I pick it will be wrong because it could be argued either way.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]