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 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
Index Compression

SQL SERVER – Data and Index Compression – Real-World Conversation

March 12, 2021
Pinal Dave
SQL Performance
Compression, SQL Index, SQL Scripts, SQL Server

Today we are going to see a real-world conversation about Data and Index Compression in SQL Server. I recently discussed this with my client.

Read More
SORT-IN-TEMPDB

SQL SERVER – Speed Up Index Rebuild with SORT IN TEMPDB

March 1, 2021
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL TempDB

In today’s blog posts that I have written about SORT IN TEMPDB which can be started on this topic. My client asked me how to speed up index rebuilding.

Read More
sort in tempdb

SQL SERVER – Two Advantages of Sort in TempDB Options

January 19, 2021
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL TempDB

A client of Comprehensive Database Performance Health Check asked me the advantages of enabling Sort in TempDB Options. Let us learn.

Read More
compressed delay

SQL SERVER – Compression Delay for Columnstore Index

January 11, 2021
Pinal Dave
SQL Performance
ColumnStore Index, SQL Index, SQL Scripts, SQL Server

Today we will talk about the Compression Delay for Columnstore Index which I got the first-hand experience with my client of Performance Health Check.

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

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

Go to mobile version