SQL Snippet – Get the number of tables in a database
The below SQL snippet will return a count of the number of tables in a database. Make sure to...
Read More
Category: SQL
SQL Script – Report a databases table sizes in megabytes
The below SQL script will return a list of tables in a database along with the table sizes in MB....
Read MoreDisabling and Enabling All SQL Server Agent Jobs
Disabling and Enabling All SQL Server Agent Jobs As part of a recent Microsoft SQL Server migration project I had a need to disabled and enable all of the Agent Jobs as various points, the below scripts did the job. This scripts...
Read More
Getting a list of databases on a MS SQL Server
Getting a list of databases on a MS SQL Server The below query will return a list of none system...
Read More
Recent Comments