Problem Statement:Get the VLF count of all the dbs in a SQL server Instance. Solution: –variables to hold each ‘iteration’ DECLARE @query VARCHAR(100) DECLARE @dbname SYSNAME DECLARE @vlfs INT –table variable used to ‘loop’ over databases […]
Read more