2016-09-20 (first published: 2016-08-17)
968 reads
2016-09-20 (first published: 2016-08-17)
968 reads
Sample script to read deadlock graph XML from default system health XEvent.
2016-09-16 (first published: 2014-10-16)
4,289 reads
Find minimum and maximum values for all date columns in a table or range of tables, using a mask.
2016-09-15 (first published: 2014-10-27)
2,491 reads
http://qa.sqlservercentral.com/scripts/split+string/117123/
The above script will split upto 256 char length only. This new version will split upto N length.
2016-09-14 (first published: 2014-10-30)
1,808 reads
This function is used to get the distance between 2 coordinates/latlong in the different formats
2016-09-13 (first published: 2014-10-31)
1,673 reads
This functions are used to convert integers/numbers into binary format and viceversa.
2016-09-09 (first published: 2014-11-18)
1,873 reads
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.
2016-09-08 (first published: 2014-11-19)
1,496 reads
2016-09-06 (first published: 2014-11-20)
1,811 reads
2016-09-05 (first published: 2015-05-20)
2,608 reads
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."
2016-09-02 (first published: 2014-12-12)
5,399 reads
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers