Home Forums SQL Server 2008 T-SQL (SS2K8) how can esure data hold or persist in a database view till i havent refresh view RE: how can esure data hold or persist in a database view till i havent refresh view

  • You could look at materialized or indexed views. These are actually a separate data store that you have to update to see data changes. But, they don't work well with data that changes a lot. You can read about them here.

    Other than that, the previous post is correct, a view is nothing but a query. It doesn't store data for you.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning