SQL Index Archives - Page 2 of 44 - SQL Authority with Pinal Dave

SQL SERVER – Finding Queries Using Particular Index

July 15, 2021

One of the most popular questions I received during my Comprehensive Database Performance Health Check is Finding Queries Using Particular Index.

July 2, 2021

Well, the answer is pretty straight forward and that is what we are going to see in today’s video of One Scan for 3 Count Sum.

June 30, 2021

Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).

June 22, 2021

However, before you read today’s COUNT(*) and Index Frequently Asked Questions I suggest you watch the video COUNT(*) and Index.

June 21, 2021

Earlier I wrote two blog post on the topic of COUNT(*) and Index and today I have to build a video on that topic as many of you really wanted.

June 18, 2021

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

June 15, 2021

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