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
Category: ARTICLES
Script to find Unused Indexes- SQL Server
Run the below script on a database where you want to find the missing indexes. DECLARE @sql varchar(2000) ,@DatabaseName varchar(20)
Default Trace – SQL Server 2005,2008,R2
There is a times for DBA to find out the user activity since last one hour or more and you
Log Space Alert- You decide when you want get a Alert
LOG FILE GROWTH – FREE SPACE ALERT BY Pavan Srirangam, 2011/02/02 This post is especially for all DBAs and that
