Monthly Meeting - February 2013
UTC : Thu, Feb 28 2013 19:00 - 20:00
Local Time: Thu, Feb 28 2013 19:00 - 20:00
Really bad, bad, not so bad… Case studies in rewriting poorly performing t-sql code.
After 20 years of performance-specific work, you’d think that people would stop coming up with bad ways to write code. Well, we keep seeing new ones. We present here some really bad things we’ve seen (from a performance standpoint), as well as the corrections.
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2, and Sybase ASE since release 4.0.1. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. Jeff has been working on large-scale systems for most of that time, having tuned a 100-gig/week throughput application on MS SQL Server 6, and created one of the first ASE data warehouses. Jeff’s specialty is performance and tuning with a special emphasis on large-scale projects with very large databases. He has written articles and columns for many magazines nationally and internationally, as well as having written over a dozen books.