Database

SELECT 1

If you have worked with an RDBMS for some time, you will likely have come across the statement SELECT 1. However, rarely is it correctly explained to engineers what the origin of SELECT 1 is, and why it’s useless and wasteful?

Read more

Why is my database slow?

Not part of my Don’t Assume series, but when a client states “Why is my database slow””, you need to determine if indeed the database is slow. Some simple tools come to the rescue here, one is Firebug .

Read more