Join operators, part 1 - terminology

Pass Through

Operator Description

Constant Scan Operator

What is the "same query"?

Why Developers Need to Understand Execution Plans

If you can examine and understand execution plans, you can achieve better understanding of the database system and you will write better database code. Grant Fritchey shows you how.

Parallel Plans

A Spectacular Case of 100% CPU Caused by Online Reindexing

An investigation of a serious performance issue during online re-indexing on a production server leads us to

interesting discoveries and solutions.

Differences In Native Compiled Procedures Execution Plans

All the wonderful functionality that in-memory tables and natively compiled procedures provide in SQL Server 2014 is pretty cool. But, changes to core of the engine results in changes in things that we may have developed a level of comfort with. Grant Fritchey explains.

Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

Learn how to examine and read a SQL Server execution plan in this article. This is the third part of a short series from Darren White that examines execution plans and imparts the basics on an important skill for DBA's and SQL developers alike.