Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • 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
Rows Read

SQL SERVER – Number of Rows Read – Execution Plan

December 25, 2020
Pinal Dave
SQL Performance
Clustered Index, Execution Plan, SQL Index, SSMS

Recently one of the clients sent me images from the execution plan and his question was about the Number of Rows Read in the SQL Server Execution plan.

Read More
Index Level

SQL SERVER – Fill Factor – Instance Level or Index Level

December 23, 2020
Pinal Dave
SQL Performance
Fill Factor, SQL Index

One of the conversations that keep on coming up at what level one should set the fill factor – Instance Level or Index Level.

Read More
long running queries

SQL SERVER – Long Running Queries with Execution Plan

December 7, 2020
Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server

I have a simple script that will list all the long running queries in the database with the execution plan. Well, the answer is yes.

Read More
Disabled Nonclustered

SQL SERVER – sp_updatestats Performance and Disabled Nonclustered Indexes

December 4, 2020
Pinal Dave
SQL Performance
Clustered Index, SQL Scripts, SQL Server, SQL Statistics

Today I am going to share our very interesting conversation about sp_updatestats and Disabled Nonclustered Indexes. Let us discuss.

Read More
JOIN Elimination

SQL SERVER – JOIN Elimination for Not Selected Column

November 25, 2020
Pinal Dave
SQL Performance
Execution Plan, SQL Joins, SQL Operator, SQL Scripts, SQL Server, SQL Statistics, SSMS

The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.

Read More
disable statistics

SQL SERVER – Disable Statistics Update for a Single Table

November 17, 2020
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server Configuration, SQL Statistics

Recently I had encountered an interesting issue with one table where we had to disable statistics update for a single table. How we can do that?

Read More
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
Previous 1 … 12 13 14 15 16 17 18 … 100 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version