header
HomeAboutJobsMembershipArchives

 
NEXT MEETING:
Thursday, May 28th 6:30 PM

 
LOCATION:
QuickStart
1500 NW Bethany Blvd
Suite 285
Beaverton, Oregon OR 97007
 
Directions to QuickStart:
Head West on Highway 26(Sunset Highway)
Exit at Cornell Road
Turn left at stoplight and cross over highway
Turn right onto Bethany Blvd at second stoplight.
The building is the first on your right.
Park in any open space
Click here for a map.
  PRESENTATION:

Ouch! Our Data Type Choices Did THAT?

It's an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. My goal in this presentation is to show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them. In addition I will cover several data type related functions, and point out caveats in their usage. I expect even advanced T-SQL developers and DBAs to walk away with a useful nugget or two.

BIO: Vern Rabe is an independent SQL Server consultant and contract trainer in Portland, OR. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been working with databases for 23 years, and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server skills gained from the mixture of academic and practical experiences acquired from his classroom instructing and consulting contracts.

LinkedIn : http://www.linkedin.com/pub/vern-rabe/a/ba3/980

Twitter : @VernRabe
 

 


CORPORATE SPONSORS

QuickStart PASS Chapter Logo Prent Ozar Pluralsight - Harcore Developer Training
TEK Systems


copyright ©2015, Portland SQL Server User Group and pdxssug.com all rights reserved.
Redistribution of any portion of this site is forbidden without prior written permission.