Blogs Dennes Torres in Blogs SQL Server: Optimize for Ad Hoc Workloads – use or not use I used to believe this option was something almost absolute: it should be enabled as best practice. I was in some way happy when all... 06 December 2023 5 min read
Lukas Vileikis Optimizing MySQL: The Basics of Query Optimization In this blog, we will walk you through the basics of query optimization in MySQL. Have a read!… 10 November 2022 4 min read
Oracle Jonathan Lewis in Oracle Oracle optimizer Or Expansion Transformations The previous installment of this series examined aggregate subquery removal and subquery coalescing, describing the latter as similar in some ways to an inverse for... 26 October 2022 15 min read
Jonathan Lewis Hacking Indexes Indexes are expensive to maintain so we want to get the greatest benefit we can from them and make sure that Oracle uses them whenever... 03 October 2016 14 min read
Brad McGehee How to Document and Configure SQL Server Instance Settings Occasionally, when you install identical databases on two different SQL Server instances, they will behave in surprisingly different ways. Why? Most likely, it is down... 30 January 2012 74 min read
David Berry Performance Implications of Parameterized Queries Why don't we emphasize the huge advantages of parameterized queries over ad-hoc queries in SQL Server? There is a severe impact on resources and performance... 28 April 2011 19 min read
