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 get timezone information?
Using UTC time and using offset values can be one of the best ways to make sure you capture the correct local time based on […]
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 […]
How to setup Database Log Shipping?
The goal of this setup is the following. We have data being collected with many users hitting the database during production hours and we want […]
How to get total row count of all database tables?
This script will create a temp table and store the name of the database table and total row counts for each table in the database. […]