Comprehensive Database Performance Health Check and they asked me a question about logical read based on my previous video about SET STATISTICS IO.
SQL SERVER – Scan Count Zero for Statistics IO
A client saw scan count zero in SET STATISTICS IO output and asked what it means. Here is what 0, 1 and higher scan counts tell you.
SET STATISTICS TIME ON – SQL in Sixty Seconds 139
Do you know how long your query took to execution? Well, let us learn that today in SQL in Sixty Seconds. We will discuss SET STATISTICS TIME ON.
Find Outdated Statistics – SQL in Sixty Seconds #137
Is it possible that your statistics are many years old but still are valid? It is difficult to find Outdated Statistics is not as easy as it seems.
SQL SERVER – Find Oldest Updated Statistics – Outdated Statistics
The word which they had used was Outdated Statistics. Let us learn more about it in today’s blog post. Find Oldest Updated Statistics
SET STATISTICS IO ON – SQL in Sixty Seconds #128
I am working with clients on helping them tune their SQL Server Performance. Let us learn how we can use SET STATISTICS IO to check the query’s performance.
SQL SERVER – Not Auto-Updating Statistics with STATISTICS_NORECOMPUTE
After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today with STATISTICS_NORECOMPUTE.