Main Content

Table Variables and Temporary Tables - What you NEED to know! (Hampton Roads SQL Server and Sharepoint Users Group)

A talk by Wayne Sheffield

About the Talk

January 19, 2011 1:30 PM

Infotec - 100 Constitution Dr, Virginia Beach, VA 23462-6799

Infotec - 100 Constitution Dr, Virginia Beach, VA 23462-6799

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?"

Ratings and Recommendations

Avg. Rating

Average based
on 1 rating

comments powered by Disqus