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

18/09/2018

I want to show you how just a little neater and tighter code can also run a lot faster. These are...

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.

The Perfect Index by Arthur Daniels +1 año 01:04:22 Be My Azure DBA (DSA) by Paul Andrew +1 año 01:10:26 T-SQL Tools: Simplicity for Synchronizing Changes by Martin Perez +1 año 01:04:51 Make Your Own SQL Server Queries Go Faster by John Sterrett +1 año 01:03:27 An Introduction to Partitioning by DBAfromthecold +1 año 57:44 Ver más en APP Comentarios del episodio 6wg4d