Well, of course, there is an easy way to know this and that is Execution plan property. Is there any way to know if the executed query is from cache or not?
TOP N Sort: Why a Small TOP Still Reads the Whole Table
Explain TOP N Sort, compare an indexed ordered access path, and align filter and sort keys before adding indexes for frequent requests.
Aggregate Pushdown: Letting the Columnstore Scan Do the Summing
Verify aggregate pushdown in columnstore scans, inspect locally aggregated rows, and compare numeric aggregates with expressions.
SQL SERVER – Execution Time of Stored Procedures
How to measure the execution time of the stored procedure when it contains lots of statement inside of it. Let us learn today about Stored Procedures
Tuning Query Cost 100% – SQL in Sixty Seconds #181
After the blog posts, lots of people asked me to build a video so here is the video discussing the topic of Tuning Query Cost 100%.
SQL SERVER – Query Cost 100%
How to tune a T-SQL with Query Cost 100%?
This is indeed an interesting question and I have received during Comprehensive Database Performance Health Check.
One Scan for 3 Count Sum – SQL in Sixty Seconds #178
Well, the answer is pretty straight forward and that is what we are going to see in today’s video of One Scan for 3 Count Sum.