Following are links to my blog post on SQLServerGeeks.com. Hope you find them useful Does Parallel Plan for rebuild index impact the fragmentation of index? http://sqlservergeeks.com/blogs/Parikshit/personal/427/does-parallel-plan-for-rebuild-index-impact-the-fragmentation-of-index Understanding SQL Server Page Allocation using new sys.dm_db_database_page_allocations introduced in SQL 2012 http://sqlservergeeks.com/blogs/Parikshit/personal/433/understanding-sql-server-page-allocation-using-new-sys-dm_db_database_page_allocations-introduced-in-sql-2012 Parikshit … Continue reading →