Question : I don’t see why an index rebuild would require a Sch-M lock on the given index. Answer : […]
Tag: index-maintenance
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 […]
Can Fill Factor be changed on specific tables without index rebuild?
Question : I’ve been digging around without any luck. SQL Server 2008: Is it possible to adjust the fill factor […]
Does SSD drive make indexes rebuild and update stats useless with SQL Server?
Question : Now that SSD is a standard de-facto. Can the maintenance job of rebuilding indexes and updating statistics, using […]
SQL Server: How to track progress of CREATE INDEX command?
Question : SQL Server 2014, Std Ed I have read that percent_complete in dm_exec_requests does not work for CREATE INDEX, […]
What other than `delete and re-creation of the index` happens when an index is rebuilt which does not happen in the reorganize command?
Question : When an index reorganize command is fired, then it will not drop and re-create the index. However just […]
Index Fragmentation Monitoring: Can I make this query faster?
Question : I have a query that is run against each database on two of my servers using a PowerShell […]