Sept 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
StarIndex

COUNT(*) and Index – SQL in Sixty Seconds #175

June 21, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server

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.

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
good or bad

Index Scans – Good or Bad? – SQL in Sixty Seconds #174

June 14, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server

Index Scans – Good or Bad? Lots of people ask about this question and I have built a blog post on the topic – SQL SERVER – Index Scans are Not Always Bad.

Read More
index scan

SQL SERVER – Index Scans are Not Always Bad

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

Are Index Scans Bad? The answer No. Index Scans are Not Always Bad. This was in-depth discussed with my client during the Health Check.

Read More
Index Scan

SQL SERVER – Top 1 and Index Scan

April 1, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Operator, SQL Scripts, SQL Server, SQL Top, SSMS

Scans are not always bad they are there because they are needed. Let us see a very simple demonstration about Top 1 and Index Scan.

Read More
maximum column

SQL SERVER – Maximum Column Per Index – 32

March 22, 2021
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Index, SQL Scripts, SQL Server, SQL Statistics

Well, the answer is you can have 32 Maximum Column Per Index but that does not mean you should have 32 indexes. Let us learn today.

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

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

Go to mobile version