Compare Two Tables Using T-SQL or Command Line Utility (tablediff.exe)
There is out too many ways to compare two tables in SQL server but I prefer to do this task
Category: DBA SCRIPTS
Script to find Backup History- SQL Server
This Script gives the backup history of all databases with in a instance. Also gives you when is the database
Robocopy
Robocopy is used to move or Copy files or folders Also have multiple options Check out this link for more
Activity monitor, Script to find Head blocker- SQL Server 2005, 2008 and later
This is very handy useful script in production environment. Even the activity monitor does the same but when there is
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
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
Status of a Backup or Restore With Percent
Run the below script to find out the status of a backup or restore being made. SELECT r.session_id,r.command,CONVERT(NUMERIC(6,2),r.percent_complete) AS [Percent
