Sound complicated? It's not, as Mary Ann Richardson shows us. SQL Server lets you use one command to quickly create a new table containing a subset of records from a larger table. For example ...

The view definition is stored by SQL Server so that it can be used as a virtual table ... stored query definition in the database with no data of its own until it is run, how can you create ...

A generic solution that's applied blindly can often just create new and more exciting ... return virtually the whole table -- SQL Server would be better off just to scan the whole table. But let's say ...