Today, we are going to see one more trick from the book – Remove Key Lookup and improve the performance of queries.
SQL SERVER – Is Query from Cache? Execution Plan Property
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?
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.
SQL Server – Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1)
Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).