Subqueries, Real and Apparent
Oct 26,
2017
As a part of our continuing study of SQL Server query plans, we’re going to take a look at some subqueries. This is particularly important, since subqueries are the subject of some fair amount of folklore, and it is important to separate fact from myth. It’s not uncommon to hear someone say “Joins are better […]
Viewing the SQL Server Procedure Cache with DMVs
Sep 6,
2017
In the previous blog, we took a quick look at query plan caching using the classic but still serviceable syscacheobjects view. A serious journey of exploration into the SQL procedure cache must, however, begin with the dynamic management view sys.dm_exec_cached_plans. While this view does provide us with some interesting information in its own right, the […]
Exploring the SQL Server Query Optimizer
Aug 3,
2016
The SQL Server Query Optimizer is always of great interest to students taking Learning Tree’s Developing SQL Queries for SQL Server and Developing High-Performance SQL Server Databases courses. Today we’ll look beyond the operators in the query plan and focus our attention on some aspects of the optimization process itself. Optimization is always a balancing […]
SQL Server 2016: Query Store Configuration
Feb 17,
2016
Introduction Some of the new features of SQL Server 2016, most notably the Advanced Analytics and Polybase, are unprecedented in earlier versions. In contrast, the Query Store added to SQL Server 2016 doesn’t so much add new features as make the time-honored tasks of query execution monitoring faster, easier, and more convenient. Once turned on […]