Jan 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
index performance

SQL SERVER – Measure Index Performance

October 27, 2021
Pinal Dave
SQL Performance
Clustered Index, SQL Index, SQL Server, SQL Statistics

My client reached out to me asking if there is a way to measure the performance of the newly created index. How to measure index performance. 

Read More
index used

SQL SERVER – COUNT(*) and Index Used – Part 2

June 18, 2021
Pinal Dave
SQL Tips and Tricks
Clustered Index, Execution Plan, SQL Index, SQL Scripts, SQL Server

Yesterday I wrote a blog post on the topic SQL SERVER – COUNT(*) and Index Used, lots of people asked me to follow up question.

Read More
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
1 2 3 4 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version