CODE TSQL – UDF function to convert strings to title case

CODE – TSQL Restore Database Backup

Get the Logical file name of the database from backup.

Use the values in the LogicalName Column.

CODE TSQL – Reindex database tables and update statistics

CODE TSQL – Cursor to kill all processes in database

CODE TSQL – Cursor to select tables with static prefix and date created.

CODE TSQL – Auto aenerate script to delete deprecated fields in current database

Requirements: field with a dep_ prefix.

CODE – TSQL Query to find ByteSize of all the tables in database

CODE – TSQL Query to display foreign key relationships and name of the constraint for each table in database