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

Find the memory consumetion by each database

find the Memory used by each database

STRING and FIND SQL Functions

SQL Functions that simplify search and operations over strings on SQL Server (starting with 2012)