Not just polish – How good code also runs faster by Daniel Hutmacher

I want to show you how just a little neater and tighter code can also run a lot faster. These are some of the instant performance improvements that won't change a lot of code, won't generate weeks of testing and validation for your colleagues and can be relatively quick to implement. But most of all, they'll make the code prettier and easier to understand for the next person. We'll look at common ways that null values, implicit datatype conversions and foreign key constraints can radically affect the performance of your queries. Inspired by an actual client case, where I tuned a 20-hour query down to a few minutes, with only a minor code change. This presentation is all-code, some execution plans, and no-powerpoint.

You can listen to Not just polish – How good code also runs faster by Daniel Hutmacher online on Radio and Podcast. Open the player on this page to stream the available audio.

Not just polish – How good code also runs faster by Daniel Hutmacher is an episode from GroupBy – Free SQL Server Training by Brent Ozar.

This episode is 47:54 long.

This episode was published on Sep 18, 2018.

Yes. Use the heart button on the episode page to add it to your favorite episodes list.

Yes. This page shows related episodes from GroupBy – Free SQL Server Training when more episodes are available from the podcast feed.