We have various MS SQL Tips / Code / How To's avilable. This is an index of the more useful mssql releated things on this blog.

Strange Issues

• Index performance - string is nvarchar not varchar when passed from c#
• Temp Table Constraint name is global

Stored Procedures

• KillConnectionsdb
• KillConnectionUser
• KillConnectionHost

Custom Types

• Unsigned int

Functions

• BINTToIP - Convert bigint to ip address
• DateTimeToUNIX
• IPToBINT - Convert ip address to bigint
• RandomString
• TRIM
• UNIXToDateTime

Functions (.NET CLR)

• Enabling .NET CLR
• Levenshtein
• MD5SUM
• RegEx
• SHASUM

Admin / Maintenance

• ShrinkLog

Tools

• Index Rebuilder

Misc

• Build a tally table