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.

Understanding Graphical Execution Plans - Part 2: How to Create One

Learn how to create a SQL Server execution plan. This article explains the basics used in performance tuning, an important skill for DBA's and SQL developers alike.

Understanding Graphical Execution Plans - Part 1: Explaining the Plan

Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.

Execution Plan Cursors