ARTICLES – Page 3 – SQL-BOX.COM

Script to backup all databases in an instance – SQL Server

I have this script for a while and used it as many times in my daily routine. The below script

Run the below script on a database where you want to find the missing indexes. DECLARE @sql varchar(2000) ,@DatabaseName varchar(20)

There is a times for DBA to find out the user activity since last one hour or more and you

LOG FILE GROWTH – FREE SPACE ALERT BY Pavan Srirangam, 2011/02/02 This post is especially for all DBAs and that