Question : If I have frequent DML(insert,update,delete) operations on a table with huge data with clustered and non-clustered indexes. Will […]
Tag: index-maintenance
Online & Offline Index Rebuild
Question : I had this weird case today. Inside a database I had about 50 (1000+ pages, most of them […]
Index Maintenance on Indexed View using Ola Hallengren Script
Question : I’m using Ola Hallengren’s below script in my environment and it fails with the error: USE DBA EXECUTE […]
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 […]
Online index rebuild higher fragmentation on intermediate level
Question : I need to rebuild some big indexes and I’m doing some tests with the various options (sort_in_tempdb, maxdop, […]
How to find the specific file in a filegroup in which an object resides
Question : Today, I encountered below error on one my SQL Server which I manage. Could not allocate space for […]
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, […]
Alter Index within a Script
Question : I’ve been reading about SQL Server Index Fragmentation and how to rebuild/reorganize. I’m curious on how to write […]
Indexes getting highly fragmented during normal usage of system
Question : I am using MS SQL Server 2014 Standard Edition in my project and recently I have encountered an […]
Which dmv can help identify the cost of index maintenance for exisitng and missing indexes?
Question : I want to identity: Indexes that are costly to maintain. Missing indexes along with their maintenance cost. By […]