What would you do if you have to fetch out a large file form a slow server over http? Well, it is quite simple. Use CFHTTP and set a reasonable timeout value, 10 minutes in my case. Ran my .cfm file. CFHTTP did establish the connection. Download the file halfway and timeout without any regard to my 10 minute instructions. I’m not really sure the reason for this behavior. It might be the old server I’m talking to or it might be the Krampus. I got quite lot of work to finish today. (more..)

Select Top 1 * from MyTable is nothing new. I was extremely confident with my knowledge of TOP statements, I made the critical mistake of not preparing a set of tested TOP SQL statements for my last week MSSQL class. I can produce a TOP statement query on the fly and explain my students everything there to know about it, so I thought. After all it is just TOP. I stumped. I totally stumped front of “TOP With Ties”. (more..)