Feb 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
logical read

SQL SERVER – What is Logical Read?

November 12, 2020
Pinal Dave
SQL Performance
Logical Read, SQL Server, SQL Server Management Studio, SQL Statistics, SSMS

Comprehensive Database Performance Health Check and they asked me a question about logical read based on my previous video about SET STATISTICS IO.

Read More
zero

SQL SERVER – Scan Count Zero for Statistics IO

October 28, 2020
Pinal Dave
SQL Performance
Execution Plan, Primary Key, SQL Scripts, SQL Server, SQL Statistics

On the production server and they noticed scan count as Zero on the result. They reached out to me asking what actually it means.

Read More
statistics time

SET STATISTICS TIME ON – SQL in Sixty Seconds 139

October 27, 2020
Pinal Dave
SQL Video
SQL DateTime, SQL in Sixty Seconds, SQL Statistics

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.

Read More
Outdated Statistics

Find Outdated Statistics – SQL in Sixty Seconds #137

October 22, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Performance, SQL Server, SQL Statistics

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.

Read More
Outdated Statistics

SQL SERVER – Find Oldest Updated Statistics – Outdated Statistics

October 21, 2020
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL 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

Read More
statistics IO

SET STATISTICS IO ON – SQL in Sixty Seconds #128

October 5, 2020
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Statistics, SSMS

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.

Read More
auto-updating statistics

SQL SERVER – Not Auto-Updating Statistics with STATISTICS_NORECOMPUTE

August 4, 2020
Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Scripts, SQL Server, SQL Statistics

After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today with STATISTICS_NORECOMPUTE.  

Read More
Previous 1 2 3 4 5 … 10 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version