Data Collections restart and clear cache files

Script to stop the default Data Collection sets, clear the cache files and then restart collection sets.

Conditionally Order By Different Column

Order records based on a different column depending on which absolute value is greater.

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