Using sys.dm_exec_requests to estimate completion time for a process

The following script is used to check on the progress of a database restore, backup and other processes currently executing on SQL Server.

Generating number sequences with Common Table Expressions

The script shows one of ways generating number sequence - this one uses CTE.

URLEncode

Here is a short UDF to URL encode a string. Requires a numbers table.

Copy Multiple objects from One Schema to Another Schema

Copy Multiple objects from One Schema to Another Schema

Function to Expand Tab Characters

A function to replace tab characters with the correct number of spaces to align the text as originally intended.

Verify Last successful CHECKDB on all databases

Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance.

Does not work on SQL 2000.

Find all objects in Server Owned by a Login

Find every object in every database owned by a particular Login.

Schema comparison

Compares table layouts between a source and target database.

Generate Create All Secondary Indexes For Entire Database

Generate Script to create all secondary indexes for a database. I have included the ability to generate online indexes if possible and the ability to move to another file group.

Check Full Recovery DBs Have Tran Log Backups

A quick procedure to check which full recovery databases have not had a tran log backup in the given period (default is 7 days). This could mean that the recovery mode might need changing or the transaction log backup jobs need investigating.