index-maintenance Archives

Do frequent DML operations on a table with indexes and huge data affect SELECT query performance?

By adminPosted on August 14, 2023

Question : If I have frequent DML(insert,update,delete) operations on a table with huge data with clustered and non-clustered indexes. Will […]

By adminPosted on August 7, 2023

Question : I had this weird case today. Inside a database I had about 50 (1000+ pages, most of them […]

By adminPosted on July 21, 2023

Question : I’m using Ola Hallengren’s below script in my environment and it fails with the error: USE DBA EXECUTE […]

By adminPosted on July 11, 2023

Question : I have an Index which has page level locking disabled and now I have index fragmentation issues for […]

By adminPosted on June 27, 2023

Question : I need to rebuild some big indexes and I’m doing some tests with the various options (sort_in_tempdb, maxdop, […]

By adminPosted on June 13, 2023

Question : Today, I encountered below error on one my SQL Server which I manage. Could not allocate space for […]

By adminPosted on June 10, 2023

Question : SQL Server 2014, Std Ed I have read that percent_complete in dm_exec_requests does not work for CREATE INDEX, […]

By adminPosted on June 9, 2023

Question : I’ve been reading about SQL Server Index Fragmentation and how to rebuild/reorganize. I’m curious on how to write […]

By adminPosted on April 21, 2023

Question : I am using MS SQL Server 2014 Standard Edition in my project and recently I have encountered an […]

By adminPosted on February 26, 2023

Question : I want to identity: Indexes that are costly to maintain. Missing indexes along with their maintenance cost. By […]