he SQL Server Database Engine processes queries on various data storage architectures such as local tables, partitioned tables, and tables distributed across multiple servers. The following sections cover how SQL Server processes queries and optimizes query reuse through execution plan caching.
2022-09-23
In this tip we look at how to save an execution plan for future review as well as using the full screen mode to see more of a query plan at one time.
2020-08-18
Starting to translate sp_BlitzCache into the cloud.
2018-07-27
4,046 reads
Brent demos a single query plan that asks for 2 identical indexes on the same table.
2017-12-26
3,142 reads
Rob Farley looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.
2016-07-20
3,121 reads
SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time. How can we benefit from this to find potential performance problems in execution plans?
2015-01-13
9,693 reads
2011-10-27
2,245 reads
2011-09-20
2,355 reads
2011-06-28
2,655 reads
Fabiano introduces another ShowPlan operator that is used to build a query plan, or perform an operation specified in the DML. Once again, Fabiano demonstrates why it is important to be aware of these operators when getting queries to perform well.
2010-11-03
2,705 reads
By Steve Jones
I was reminded this week that I needed to get registered for the Data...
By Steve Jones
Today’s coping tip is to choose to see your mistakes as steps to help...
By gbargsley
Good day reader. This post is coming to you from a busy week in...
We have change tracking enabled on one of our databases and I am looking...
I have two databases on the same server. I have a service account I...
Hi, I'm trying to run the below SQL code but I'm getting this error:...
Ask SSC