Edward Haynes presents the theory behind Query Shaping at a Science in the Pub event
Channel: Dark Matter Zine
Date: 2019-10-31

SQL Server developer and performance optimisation specialist Edward Haynes is known for his creative problem-solving to speed up database queries. Here he presents a science-in-the-pub introduction to the theory behind his work called Query Shaping. This short presentation does not include code: he's writing an article and a lecture to present to universities and professional forums that includes code. This is a basic explanation of the theory that drives his work.

Edward is the guy who has repeatedly and significantly improved database query performance by applying Query Shaping methodology. The improvements in query performance has, at times, been so significant it has surprised his peers.

Edward has also written a performance diagnostic tool that helps identify query bottlenecks. This tool will be utilised to help demonstrate query optimisation using Query Shaping methodology when the lecture is fully developed.