End to End Server Disk Space reporting within SQL Server

This procedure using OLE object calls to obtain server disk space values and writes them to a table. It then creates an HTML report based on the contents of the table and then , via a SQL Agent job, sends out colour coded emails relating to how much drive space is left... this is very handy!!!!

Part 2 -- Restore a database to another instance...

This script should be created in the source instance of the database to be backed up and then restored in conjunction with that on the destination in Step 1.

Part 1 -- Restore a database to another instance...

A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.

Missing indexes in current requests

Script to get any current requests with missing indexes

Get file sizes of database files and free space on disk

Reports on the data and log file sizes and space used within files for each database on a servers. It also includes the free space on the drive where the file is located.

Last Accessed Datetime for table - Easiest way

This function is used to get the complete table lists are particular table and its last access datetime.

CASE IN ORDER BY

sorting data based on a particular value.

Recreate a temporary table from TempDB

This Script can be used to pick out a temporary table from tempDB

you might want to Check and drop the table before you create it just in case , but I Haven't included it here

Find Currently Running Query – T-SQL

Following script retrieves the queries currently executing on the server.

Validating null values in a column without using ISNULL or NVL.

We can check for null values using count.