Blogs on SQLServerGeeks

Following are links to my blog post on Hope you find them useful Does Parallel Plan for rebuild index impact the fragmentation of index? Parikshit Savjani Premier Field Engineer

Fragmentation should not be the only factor which decides the Rebuild Index

Until now I was under the impression that fragmentation in the Index is the only factor which decides whether we should rebuild the index. As a rule of thumb we always recommend that when the avg_fragmentation_in_percent in the view¬† sys.dm_db_index_physical_stats¬† … Continue reading