SQL Server® has been around for over 30 years, and I’ve been working with it for almost as long. I’ve seen a lot of changes over the years (and decades!) to this incredible product. In these posts, I’ll share with you how I look at some of the features or aspects of SQL Server, sometimes […]
Read More
When you run a SELECT query, MySQL “remembers” both the query and the results it returns. This is accomplished by storing the result set in a special cache (called the query cache) each time a SELECT query is executed. Then, the next time you ask the server for the same query, MySQL will retrieve the […]
Read More
Working with SQL Server is always a challenge. As developers try to troubleshoot SQL Server performance problems, the first step that take is to look at the queries. This is the most basic step and most important step for most developers. Developers love these challenges of optimization because they can get the maximum visible performance improvements in their […]
Read More
Learn from Oracle experts about the myths and realities of what causes poor Oracle database performance and tips for improving it.
Read More
Although there are some overhead costs and administrative requirements, using parallel operations in Oracle can improve the performance of many queries. Learn more.
Read More
If you are executing the same queries over and over, using the RESULT_CACHE hint in Oracle 11g can make subsequent queries run faster. Learn more.
Read More