SQL Server - Views

Views - are SQL statements stored in the database. They get compiled, and are supposedly faster than running the SQL statement directly. Especially if you are pulling data from many columned tables (or Many Rowed tables) and only return a few columns, or a few rows.

Read More