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

Join me at SQLBits 2020

By

The SQLBits conference is taking place in London again this year, between March 31st...

DBA, a job, a vital job

By

DBA, a job, a vital job. T-SQL a language that is fun. Select, a...

SOS_SCHEDULER_YIELD – What is it really telling us?

By

I decided to write this off the back of a conversation I was having...

Read the latest Blogs

Forums

SMO Certificate Export - FailedOperationException

By BPRocket

Greetings, Given this Powershell SMO method call... $_cert.Export("$CertificateLocation\$_cert_name.cer", ` "$PrivateKeyLocation\$_cert_name.pvk", ` $_secret) where $_cert...

Resultset in a format

By VSSGeorge

I have the following tables: create table #EmployeeSystemsMaster(EmployeeSystemID int, EmployeeSystemName nvarchar(150)) insert into #EmployeeSystemsMaster...

SQL Server data masking

By Admingod

Can you able to mask data in sql server 2012? If yes, would it...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers