Hi Brent, What is your take on Hugo Kornelis’s explanation of execution plan naming. As her his explanation, estimated exec plan is simply an execution plan whereas actual execution plan = execution plan+run-time stats. Do you agree that the naming is flawed and confusing? – Yourbiggestfan
2022-08-31
2022-03-09
476 reads
Discover how to estimate the cost of a query. Read on to see an example of how to extract the Estimated Cost for execution plans stored in the procedure cache.
2020-06-23
2020-02-11
832 reads
2020-02-04
898 reads
2018-12-03
927 reads
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
By looking at a query execution plan, you can determine which steps are used to resolve the query. But what if you just want to find out what the query plans are for only the queries that are currently running?
2018-04-20
4,126 reads
Erik Darling shows how execution plan estimates suffer.
2018-04-18
3,318 reads
2016-12-14
1,157 reads
By Steve Jones
Apologies for the late invitation. A minor snafu has me hosting again. This is...
By Steve Jones
Today’s coping tip is to remind yourself that you are enough just as you...
What you have access to is not just what you have direct permissions to....
In lengthy discussions and in developing trial and error scenarios I sometimes find it...
I am wondering whether or not there is a way to get Windows SQL...
Comments posted to this topic are about the item What's the CEIP?
Ask SSC