So SQL Cursors definitely suck. Got a one time data migration script that needs to migrate 3 million rows of data (which I misread as 300k)

Using cursors it would take 15 hours to complete. Ive just had to make the most disgusting script using recursion and a whole lot of CTE's but it now takes about 15 mins to do the same faff

I feel dirty just reading the script, but atleast it'll be dead and buried once it's been ran

TLDR Cursors bad, m'kay

The urge to get a tea, followed by the urge to release the bladder, followed by another tea...

Being a dev is a vicious cycle

Created a batch script to write some filenames to a text file using a loop.

Missed out the echo command, the script tries to open 100+ zip files on a production/potato server (I feel like prodtato should be a word).

Server cries and crashes
Dev cries and crashes