Nonclustered Index

Disk and Performance Impact of Online Index Rebuild Operation

Here, we are going to talk about disk and performance Impact of online Index rebuild operation. As we know index…

SQL Server Interview Questions & Answers on Indexes

This article is part of SQL Server interview questions & answers series. Today, i am covering SQL Server Interview Questions &…

Difference between Index Rebuild and Reorganize

Fragmentation exists when indexes have pages in which the logical ordering, based on the key value, does not match the…

What should be the Best Value for Fill Factor in SQL Server

Lot of SQL Server resources ask what is the best value for fill factor in SQL Server and should we…

Understanding SQL Server Indexes

SQL Server Indexes are similar to book indexes that we use to search any content in that book. They are…