Entries Tagged as "SQL"
Recover from a OMG-WTF SQL Statement!
Posted by [Justice] in SQL on August 20, 2008
So you did it. You ran an UPDATE or DELETE SQL statement without a WHERE clause. Don't panic (well, panic, but don't despair). You can fix it with a few steps I will outline here, provided you are doing a few 'best practice' SQL maintenance items.
SQL Fun - Let the DB do the work
Posted by [Justice] in Coldfusion , SQL on August 5, 2008
I'm a firm believer that you should always let your database server return data as pure and ready for display as possible. While coldfusion *can* take your entire dataset and break it into pages, and Query of Queries has some decent functionality to mix things up, I find it is orders of magnitude faster to leave that work to your database server. With the following snippets your mileage may vary, as these are primarily done in MS SQL of some variety, but at least this may show you some tricks you didn't know!
Recent Comments