Indexes

How to Use Resumable Online Index Rebuild Operation in SQL Server?

Resumable Online Index Rebuild is a new feature introduced in SQL Server 2017. Index Rebuild operation is very expensive task…

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 &…

How to Avoid Page Split in SQL Server?

This is very interesting topic. How to Avoid Page Split in SQL Server? Let's start with basics. Page split is…

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…

How to Move Table to Another Filegroup?

Suppose we had a database that has grown very large in size and located on the D drive that had…