First introduced in SQL Server 2012, columnstore indexes can give you major ... them in an effort to get the database engine to generate an optimal query plan. ... to the scan operation, which ...

Put the query in a new query window in SQL Server Management Studio. Looking at the AdventureWords2012 database (available for download from CodePlex), review the uspGetEmployeeManagers stored ...

SQL Server has an optimizer that usually does a great job of optimizing code for the most effective execution. A query execution plan is the breakdown of how the optimizer will run (or ran) a query.