Querying deadlock graph from SQL Extended Events

Sample script to read deadlock graph XML from default system health XEvent.

Checking All Date Columns in a Table(s)

Find minimum and maximum values for all date columns in a table or range of tables, using a mask.

Split string using multiple delimiters - version 2

http://www.sqlservercentral.com/scripts/split+string/117123/

The above script will split upto 256 char length only. This new version will split upto N length.

Calculate distance between 2 coordinates/latlong

This function is used to get the distance between 2 coordinates/latlong in the different formats

Convert integers/numbers into binary format - viceversa

This functions are used to convert integers/numbers into binary format and viceversa.

Date-based table purge

This procedure takes in charge the clean-up for a given table based on a date field
given as parameter and a retention expressed as a number of days.

Finding Data Islands

A script to find data islands within a sequence of numbers.

Magic 8 Ball

This script creates a stored procedure that mimics a Magic 8 Ball

Stupid Coding Tricks: The T-SQL Mandelbrot

The bar for entry into CodeSOD is pretty straight forward: professionally-developed code that elicits that certain What The— reaction. Though there have been a few exceptions over the years, generally speaking, student code, hobbyist code, and amateur code need not apply. That said, I'd like to try something a little different today. Today's example is not technically professionally-developed, it's a Stupid Coding Trick.

"So I was bored at work one day," Graeme Job explains, "and wondered, what's the most useless thing I could do with my time without actually doing anything. Then it hit me. I could use T-SQL to generate... Mandelbrot."

Graeme continued, "Following is a single T-SQL SELECT statement that generates a text-representation of a Mandelbrot Set. The results are best viewed in text-mode."

Unused Procedure lists - Easiest way

This function is used to get the unused stored procedure list for which doesn't used for given noofdays.