Question : This is kind of a followup to the existing question on this site “Why index REBUILD does not […]
Tag: fragmentation
What is the impact of temporarily setting ALLOW_PAGE_LOCKS ON
Question : The MSDN ALTER INDEX page says “An index cannot be reorganized when ALLOW_PAGE_LOCKS is set to OFF.” I’m […]
PostgreSQL Initial Database Size
Question : There are 2 parts to my question. Is there a way of specifying the initial size of a […]
avg_page_space_used_in_percent and fill factor
Question : sys.dm_db_index_physical_stats contains column avg_page_space_used_in_percent. How does this fit in with the fill factor of an index? For example: […]
Online & Offline Index Rebuild
Question : I had this weird case today. Inside a database I had about 50 (1000+ pages, most of them […]
Clustered composite key high fragmentation and fill factor
Question : I’ve recently made a table to hold the language preferences of my users as follow: CREATE TABLE [dbo].[systemUserLangPreference]( […]
What is fragmenting my index on a table with stable traffic?
Question : I am using Ola Hallengren’s solution for optimizing indexes. I run it on Sunday every week. The index […]
Index Fragmentation – log issues
Question : I have a few questions that I want to understand in order to take informed decision. I am […]
Index fragmentation problem after disabling page-level locking for an Index
Question : I have an Index which has page level locking disabled and now I have index fragmentation issues for […]
Index Maintenance – Reorganize After BIG SQL Server Shrink
Question : I’m planning to execute the below index maintenance created by Ola Hallengren in a 1TB Database. EXECUTE [dbo].[IndexOptimize] […]