One of the newest features in MySQL, and one of its most eagerly-anticipated ones, is subqueries. Subqueries have been on the MySQL wishlist for a while; they've finally made an appearance in MySQL 4.1, and, as someone who's been playing with them for a little while, I can tell you that they're pretty useful. Sadly, however, since the software is still under development, there isn't too much information available at the moment on their full capabilities in the MySQL context. More info

Ever wonder what is inside your SQL Server's data cache, and how it can affect your server's performance. Learn more here. More info

Learn how to identify and prioritize poorly performing queries. Part of the Performance Audit Series. More info

It's important to have a solid understanding of how a system works before you try to administer, code, or design it. More info

Learn 10 useful tips and tricks that help boost SQL Server application performance—and streamline development and deployment as well. More info

Use the SQL Server Report Designer's wizards for a streamlined solution to setting up, designing, polishing, and publishing reports. More info

While the "OR" clause is a very short clause, it can cause a lot of performance problems if you are not careful. More info

How to think of your data as a set of components, not a monolithic table. More info

Learn how to reindex your database's indexes with the least performance overhead, automatically! More info

Learn when to use graphical or command-line tools to manage SQL Server. More info