CACTUSS North

CACTUSS

Capital Area Central Texas User of SQL Server

PASS affiliated user group for Austin, TX

Contact us: Email: CACTUSS.SQL (at) (gmail) (dot) (com)
Twitter: @CACTUSS_SQL
LinkedIn: https://www.linkedin.com/groups/149440
Meetup: https://www.meetup.com/Austin-SQL-Server-User-Group/

Upcoming Meeting Dates

  North
Nov 2019 Tue 11/19/2019
Speaker: Kevin Boles
Topic: Common TSQL Mistakes
Speaker: Shawn Weisfeld
Topic: Quick Introduction to GitHub
Dec 2019 Tue 12/17/2019
Speaker: Jay Falck
Topic: Setting up a test lab with Hyper-V

Meeting Location

CACTUSS North

  • Meeting dates: 3rd Tuesday of the month
  • Meeting starts: 5:30 pm with food and a QA session
  • Presentation: 6:00 pm and goes to 7:15 pm
  • Address
    • Quarry Oaks II
    • Microsoft Office
    • Suite 225
    • 10900 Stonelake Blvd.
    • Austin, TX 78759
      • * Free parking
      • * Coming from Braker, go right/straight at the traffic circle and it's the building on the left.
      • * The building is also across from the outdoor basketball court
      • * Not the building attached to the parking garage
      • * Inside the Microsoft office, go right, past the reception desk, to the far back and left
      • * If there is interest, there is sometimes an after-gathering at a local place to talk casually
    • Map: http://binged.it/1HOSMWm

Next Meeting

Tuesday,

August

16

NORTH <br /> Table Vars & Temp Tables <br /> by Wayne Sheffield

10900 Stonelake Blvd. Suite 225 - Microsoft Office
Austin, Texas 78759
Time: 18:00 - 19:30

Title: Table Vars & Temp Tables – What you NEED to Know!
by: Wayne Sheffield

Summary: 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?”

Speaker: Wayne Sheffield, Principal Consultant Database Masters:
Bio: Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, 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 events worldwide and blogging at http://blog.waynesheffield.com/wayne

Special Notes:
Zip file of PowerPoint and SQL scripts, hosted at Wayne's blog: http://bit.ly/TableVars

Not going to PASS Member Summit this year? Make sure you catch this session by Wayne Sheffield which will be given at PASS Member Summit this year.

Available Attachments:

Our monthly meetings are made possible by the generosity of these sponsors:

This month's sponsor:

(Feature coming soon)

Ongoing sponsors:

Microsoft

SQL Watchmen  

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids