Order by

We use time-stamps as prefixes in the name of SQL scipt files to keep them in order. So, we can execute them in the same order every time. Before 'Go-Live' we provided an install packed and some instructions, e.g: execute them in order. After a few scripts error messages started to raise. It took almost an hour to notice that Windows Explorer uses different algorithm then Total Commander to order by name. Windows Explorer handles prefixes like numbers, Total Commander handles them as dates.

So ...what does it mean? 201206201710_Script1.sql and 20120705_Script2.sql are in different order in the two file managers. Since 201206201710 as a number is much bigger then 20120705, however the second one is bigger as date.

Hello World!

Alright, I decided to share some of my experiences with you, so I've started this blog. I hope you're gonna like it :)