March 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
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

SQL SERVER – Columnstore Index and Fragementation

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

One of the questions I had received from a client was about how to find out fragmentation in columnstore index. Let us discuss it today. 

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
DBCC DBREINDEX

SQL SERVER – DBCC DBREINDEX and MAXDOP Not Possible

December 24, 2020
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Server DBCC

Yes, you read it right it is not possible to use DBCC DBREINDEX with MAXDOP hint as far as I know. If there is any method to use it.

Read More
Index Level

SQL SERVER – Fill Factor – Instance Level or Index Level

December 23, 2020
Pinal Dave
SQL Performance
Fill Factor, SQL Index

One of the conversations that keep on coming up at what level one should set the fill factor – Instance Level or Index Level.

Read More
delete statement

SQL SERVER – Delete Statement and Index Usage

September 17, 2020
Pinal Dave
SQL Performance
SQL Delete, SQL Index, SQL Scripts, SQL Server

The client wanted to know if the index help with the DELETE command as well. The answer is yes, Indexes do help with the DELETE statement.

Read More

Nonclustered Primary Key – SQL in Sixty Seconds #119

September 7, 2020
Pinal Dave
SQL Video
Primary Key, SQL Constraint and Keys, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server

I will describe in detail a bit later on during this blog post. Today we are going to learn that it is possible to have a nonclustered primary key. 

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

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

Go to mobile version