June 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
COUNT

SQL SERVER – COUNT(*) and Index Used

June 15, 2021
Pinal Dave
SQL Performance
Clustered Index, Execution Plan, SQL Index, SQL Scripts, SQL Server

DBA suspects those operations are using lots of clustered index scans. Let us discuss today COUNT(*) and Index Used. Let’s learn.

Read More
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
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
Index is Disabled

What Happens If the Clustered Index is Disabled? – Interview Question of the Week #291

August 30, 2020
Pinal Dave
SQL Interview Questions and Answers
Clustered Index, SQL Error Messages, SQL Index, SQL Scripts, SQL Server

Question: What Happens If the Clustered Index is Disabled?

Answer: If you disable the clustered index, you can’t retrieve data from the table.

Read More
force index

How to Force Index on a SQL Server Query? – Interview Question of the Week #281

June 14, 2020
Pinal Dave
SQL Interview Questions and Answers
Clustered Index, Query Hint, SQL Index, SQL Scripts, SQL Server

Question: How to Force Index on a SQL Server Query?
Answer: I personally do not like to force an index on any query. Let us learn together.

Read More
Poor Indexing Strategies

SQL SERVER – Poor Indexing Strategies – 10 Don’ts for Indexes

February 13, 2020
Pinal Dave
SQL Performance
Clustered Index, SQL Index, SQL Scripts, SQL Server

The most questions were around section Poor Indexing Strategies and that lead me to write about 10 Don’ts for Indexes. Let us talk about it today.

Read More
slow performance

SQL SERVER – Top Reasons for Slow Performance

February 10, 2020
Pinal Dave
SQL Performance
Ad Hoc Query, Clustered Index, Disk, File Growth, Query Hint, SQL CPU, SQL DMV, SQL Function, SQL Index, SQL Memory, SQL Server, SQL Server Configuration, SQL Stored Procedure, SQL TempDB, SQL Utility

Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.

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

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

Go to mobile version