2025-05-14
574 reads
2025-05-14
574 reads
Welcome to part twenty of the plansplaining series. It has been a long time since I last wrote a plansplaining post, partly because of my health, but also for a large part because I was out of ideas. But recently I decided to dig a bit deeper into a feature that was released in SQL Server 2017 and that I had so far not played with: SQL Graph.
2023-12-06
In this article, we look at execution plans and performance of a natively compiled stored procedure versus a traditional stored procedure.
2023-10-16
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
514 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
851 reads
2020-02-04
915 reads
2018-12-03
944 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 Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
By Steve Jones
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...
By Rohit Garg
Is Air Travel Safe? Yes, air travel remains statistically the safest mode of transportation. In...
Embarking on a 200 hours YTT in Rishikesh is a transformative journey that goes...
Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...
Comments posted to this topic are about the item Can You Ask for a...
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers