The Performance Virtual Chapter's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Welcome to the Performance Virtual Chapter

The Performance Virtual Chapter events are held on the 4th Thursday of each month at 2PM ET.  Every month there is a drawing for a $100 Amazon gift card sponsored by Confio.  To be eligible, you just need to attend our monthly webcast.  A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address. 



You can follow us on Twitter @SQLPASS_PVC

Join our Google Group Distribution List for the latest updates and meeting announcements.

Congratulations to the October Gift Card Winner...Brian Sload!

 

GoToWebinar requires registration through the RSVP link below.
Next Meeting

Thu, Feb 28 2013 14:00 (GMT-05:00) Eastern Time (US & Canada)


Monthly Meeting - February 2013

RSVP: None

Recording: https://www305.livemeeting.com/cc/usergroups/view?id=BP9R6D

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.