SQL Trace lets you trace code directly from a query window, without running the Profiler. In addition, you can now invoke the Index Tuning Wizard directly from the QA. (The QA in SQL Server 7.0 ...

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 ...

Query Window Menus. The SQL Query Window has File, Tools, View, and Profile pull-down menus (PMENUs). If your monitor supports the use of a mouse, you can also display the most frequently used Tools ...

With Windows Server 2008 R2 and SQL Server 2008 R2, this is simply a matter of entering the following commands while in PowerShell: Add-PSSnapin SqlServerProviderSnapin and Add-PSSnapin ...

SQL Server 2016 offers a new tool for performance tuning called Query Store. This holds metrics that let you quickly see when an execution plan change has negatively impacted the database.

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 ...