Other Dennes Torres in Other 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 Or-Expansion Transformation: How the Optimizer Rewrites OR Predicates into UNION ALL for Index Access Oracle's Or-Expansion transformation - how the cost-based optimiser rewrites queries containing OR predicates into UNION ALL branches that can each... 26 October 2022 16 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
SQL Server Brad McGehee in SQL Server How to Document and Configure SQL Server Instance Settings Learn how to document and configure all ~70 SQL Server instance-level settings using T-SQL and PowerShell, with best-practice guidance for... 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
