Question : I have maintenance job on SQL Server 2012 Enterprise Edition that runs daily to check index fragmentation and […]
Tag: index-maintenance
Index rebuild/reorganize fragmentation percentage mean the internal (inside the page) or external (amongst pages)fragmentation?
Question : Fragmentation of 5% – reorganize Fragmentation of 30% – rebuild Index rebuild/reorganize fragmentation percentage mean the internal (inside […]
Rebuild Index Task options [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Order of execution in Ola Index maintenance and Stats collection
Question : I was thinking of performing The index maintenance and stats collection jobs in the below order for all […]
How to control blocking sessions while an index maintenance job runs?
Question : I would like to know, is there any possibility to control the locks while Ola’s index optimize job […]
Why does an index rebuild requires a Sch-M lock?
Question : I don’t see why an index rebuild would require a Sch-M lock on the given index. Answer : […]
Do frequent DML operations on a table with indexes and huge data affect SELECT query performance?
Question : If I have frequent DML(insert,update,delete) operations on a table with huge data with clustered and non-clustered indexes. Will […]
Problem reading data from secondary when reorganizing clustered index
Question : We have an AOAG in SQL Server 2014 SP2 CU5 (3 nodes). There is a database with Read […]
Error when using WITH (DROP_EXISTING = ON)
Question : Okay so I’ve been condensing files off of some tiny files and moving them onto an FG that […]
SQL Server Index Maintenance-Conditional Rebuilds
Question : I have a question about index maintenance. I have a weekly process that does all of my database […]