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
–DB Blog
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