Execution Plans

Execution Plans and Data Protection

  • Article

One of the most important tools for query tuning is ability to view execution plans. They are even portable; you can send an execution plan to get advice from someone who doesn't have access to the underlying data. Have you even considered that sensitive information might travel along with the plans? Hugo Kornelis explains how execution plans affect data protection.

2018-04-30

3,411 reads

Retrieving SQL Server Query Execution Plans

  • Article

Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them in SSMS, but what if you need to drill into to the important details? What about using DMVs, Extended Events or SET statements to get at the execution plans? To get the best use of execution plans you need to be able to get right information from the right plan at the right time. Robert Sheldon explains how.

2016-12-14

3,977 reads

Blogs

2020 Advent of Code–Day 1

By

This series looks at the Advent of Code challenges. I started the Advent of...

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)

By

Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...

One Chart at A Time Video Series

By

Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...

Read the latest Blogs

Forums

SUM multiple tables GROUP BY column

By milo1981

I have the following SQL Server 2005 tables: create table Cars ( CarID int,...

SUM multiple tables GROUP BY column

By milo1981

I have the following SQL Server 2005 tables: create table Cars ( CarID int,...

Interesting bug in SQL 2016 CHOOSE

By ScottPletcher

While trying, in SQL 2016 (13.0.5850.14), to see if CHOOSE allowed an inline query...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers