The MySQL EXPLAIN statement provides insight into MySQL's query execution plans. This video demonstrates how you can use this powerful feature to boost your MySQL database performance.
Database Section Index
SQL JOINs can help you retrieve interrelated data stored in multiple tables from your MySQL (or really any relational) database.
Use these powerful tools to increase your MySQL development productivity.
Find out what makes Mnesia, the Erlang-based database management system, perfect for distribution across a network of computers.
Need your server and your site up and running quick? Let Greg Larsen show you what you need to know to get SQL Server running and configured.
Learn how leverage location based data using Microsoft SQL Server 2008 from C# applications and combine them with interactive maps.
The results you get out of any performance prediction exercise are bound to be wrong. The goal is to make them as least wrong as possible. Rob Bogue will help you understand how to avoid getting them too wrong.
In many business applications, it is crucial to know how data has changed over time. For developers, this is not a new problem; many different solutions have been created to log changes. But creating a log is time-consuming. Read on to learn how SQL Server 2008 can help you save time and work more effectively.