This is the UTC for Eastern time zone for North America based on current eastern time.
How to get table size in a database?
This query will return size of each table in a sql database. This is a great way to monitor growth of a database and decide […]
Database Mail Error Failed to initialize sqlcmd library with error number -2147467259
Failed to initialize sqlcmd library with error number -2147467259
How to rerun SQL query after delay?
This sample show how to run the same query with delay. It will keep running the same query with 10 second delay and keep re-executing […]
How to autorecover sql script in ssms?
Sometimes when SQL Server Management Studio crashes you end up losing your work. Many times it restarts on its own and loads the scripts that […]
Database Backup Percentage Complete Status
When performing backup with scripts its not easily possible to get the percentage complete of the running backup. This simple script will show status of […]
How to get list of new or modified database objects?
This simple query tells us if there were any database objects created within the last 24 hours. You can modify the DATEADD parameters to get […]