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,490 reads
This function is used to get the unused stored procedure list for which doesn't used for given noofdays.
2016-09-01 (first published: 2014-12-03)
3,354 reads
Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.
2016-08-31 (first published: 2014-12-10)
4,044 reads
Short little script to get the columns in a table in order into a CSV format.
Can be useful for select or insert statements.
2016-08-30 (first published: 2015-03-23)
4,636 reads
If you want to generate temporary passwords, can use my script.
2016-08-29 (first published: 2015-03-29)
1,793 reads
This In-line Table Valued Function returns a table with individual records parsed from a string.
2016-08-26 (first published: 2015-04-01)
5,233 reads
A brief introduction to the sparse option and script to help decide when to use it
2016-08-25 (first published: 2015-04-10)
1,760 reads
Query to find the Job Output file location at each job step.
This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.
2016-08-24 (first published: 2015-04-24)
3,349 reads
Script lists all the clr objects in the database.
2016-08-23 (first published: 2015-05-01)
1,512 reads
I comment CATCH section for removing dependence to log procedures.
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpTableUnload.sql
2016-08-22 (first published: 2015-05-07)
2,236 reads
