Category: SQL Server Maintenance Solution

Remove High Virtual Log File (VLF) (@OptimizeLogFiles) This generates TSQL code for removing huge virtual log files (VLFs) from SQL Server database log files. By default, @vlfCountThreshold is

Like any other DBA, I fell into the trap of using straight maintenance solution using Reorganize operation for Indexes with avg fragmentation with 30% or less with Index