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... 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... 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... 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?... 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... 28 April 2011 19 min read
