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

Login to Subscribe

Welcome to the Performance Virtual Group

Next Meeting

Everything you want to know about Stored Procedures and Performance

Thu, Jun 29 2017 18:00 UTC

Everything you want to know about Stored Procedures and Performance

This session will cover topics regarding stored procedures in SQL Server, and utilizing best practices for superior performance. At the end of this session, attendees will have a great understanding for how to get the most out of their SP code. Topics include: - Stored procedure coding recommendations - Error handling, return status, parameter techniques - Stored procedures vs. inline SQL - Temp tables in stored procedures - Compilation issues - Performance issues


Jeff Garbus

Jeff Garbus has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. 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. He 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 has scaled many multi-terabyte databases in SQL server. Jeff ‘s background includes work experience from PC's to Mainframes and back again, in all aspects of IT, from developer, to DBA Manager, to IT Executive. His specialty is performance and tuning with a special emphasis on large-scale projects with very large databases. He is very well known in the industry, having spoken at user conferences and user groups for many years, written articles and columns for many magazines nationally and internationally, as well as having written over a dozen books. He was first certified to teach MS SQL Server in 1989, and is currently an MCT. He can be easily found at www.soaringeagle.biz. Check out his blog, http://mssqlperformance.blogspot.com/

Contact the Performance Virtual Group

Are you interested in being a Presenter, getting involved with the Group or simply provide us with some feedback? Please fill in the form below

Your Contact Information

Your Feedback

Thank you for contacting us, we will get back to you as soon as possible!
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids