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.

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

Database schema wise size detail

Database schema wise size detail

Table Space Used in DB

A quick script that provides the sizes of the tables in your database, including schema and choice of sort method