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
–DB Blog
There is out too many ways to compare two tables in SQL server but I prefer to do this task
This Script gives the backup history of all databases with in a instance. Also gives you when is the database
Robocopy is used to move or Copy files or folders Also have multiple options Check out this link for more
This is very handy useful script in production environment. Even the activity monitor does the same but when there is
I have this script for a while and used it as many times in my daily routine. The below script
There is a times for DBA to find out the user activity since last one hour or more and you
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