Purging table script

Script to purge big tables in small batches of 500

dba_CopyLogins

A copy of the late Robert Davis' dba_copylogins stored procedure with a bug fix. The SP copies logins, roles, and permissions between servers.

Export diagrams

Export diagrams in current database to an import script.

Compare Table Contents Procedure

Compare the content of two tables for differences

T-SQL to compress (shorten) IPv6 address

Didn't find anything, so hope this will help someone with similar need.

Note I did a similar set-based version, and unless the input is more towards non-zeros in all eight 2-byte fields, the set-based performs not as well

GenerateFullSequenceRestoreScripts_Litespeed

Sp to Generate Restore sequence

FK_Add_Drop_Constraints_AllDBs

This scripts helps to generate ADD / DROP Constraints against single Database.

SQL Server Shortcut to take Table Backup

SQL Server Keyboard shortcut key to take table backup

Create Database Snapshot Dynamically

Dynamic SQL can be used to generate a database snapshot. Useful for a database with a number of files.

Replace-Function

Another way to do a "Multi"- replace