Entries Tagged as 'SQL'

Recover from a OMG-WTF SQL Statement!

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.

Read more...

Posted by [Justice] on August 20, 2008 11:40 AM 2 comments

SQL Fun - Let the DB do the work

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!

Read more...

Posted by [Justice] on August 05, 2008 8:12 AM 2 comments