But, if a view is just a stored query definition in the database with no data of its own until it is run, how can you create an index TechRepublic’s SQL Server newsletter, delivered each Tuesday ...

In an ASP.NET MVC application, for example, my code that retrieves the data to build the DTO ... It makes sense, therefore, to create views in SQL Server that correspond to the DTOs I will return from ...