Next Meeting: Tue, Sep 29 2015
Wayne Sheffield Presents Table Vars & Temp Tables – What you NEED to Know!
Event Type: In-Person
Online Meeting URL: None
Bi-Monthly User Group Meeting
UTC : Tue, Sep 29 2015 22:00 - 00:00
Event Time : Tue, Sep 29 2015 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Tue, Sep 29 2015 22:00 - 00:00
4821 Koger Blvd
Greensboro, North Carolina
Table Vars & Temp Tables – What you NEED to Know!
Wayne Sheffield, Principal Consultant SQL Solutions Group
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, “When do I use one or the other and what are the various impacts of doing so?”
Wayne Sheffield, a Microsoft Certified Master in SQL Server, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of SQL Server T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and blogging at http://blog.waynesheffield.com/wayne.