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

Read all trace file data and print the action performed

If you want to read trace file records from default trace location and want to print to see what are all the activities happened on SQL Server, the query will be helpful for you.

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."