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

VMworld 2020 SQL Server session preview

By

Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...

A new malware attack on SQL Server

By

Tencent Security has released a report (written in Chinese) describing a new malware attack by...

Azure Synapse Analytics overlooked features

By

There are some options in Azure Synapse Analytics that are not obvious that I...

Read the latest Blogs

Forums

Size of table

By caz100

Hi This probably a silly question but..... If I query the size of a...

Cross Apply, sub query or something else.... I\'m stuck

By Geoff A

need help on a query please. given the following table; CREATE TABLE #T (CATEGORY...

Validate field in STaging before loading

By Bruin

I have a STaging table where I have defined all fields as Varchar(255), now...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers