Next Meeting: Wed, Aug 27 2014
Election Night & Every Byte Counts: Why Your Datatype Choices Matter
Andy Yun, Senior MS SQL Server Database Developer The SAVO Group
Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these Datatype Choices can be a real performance killer? Attend this session, learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! When you leave, you should be able to explain why datatype choices matter to your colleagues, assess your own systems, and implement some best practices to mitigate these performance killers.
Once a DBA, Andy is a Database Developer and self-proclaimed T-SQL performance junkie. Over the past decade, he has worked with SQL Server in highly transactional environments, in the trading and credit card industries. Leveraging knowledge of SQL Server Internals, Andy strives to make T-SQL leaner and meaner. He is very passionate about the SQL Server community, loves making new connections, and is excited to keep presenting. Andy is a co-leader of the recently restarted Chicago Suburban SQL Server User Group PASS Chapter.
5:30 PM - 5:45 PM: General Announcements
5:45 PM - 6:00 PM: Election Candidate Mini-Speeches
6:00 PM - 6:15 PM: Election
6:15 PM - 6:45 PM: Dinner & networking
6:45 PM - 8:00 PM: Main Presentation
8:00 PM: Closing comments & wrap-up
You can vote in the election in person at this meeting. If you are unable to attend the meeting, you can vote by mail. Download this ballot and mail it in with the instructions on the ballot.
Event Time : Wed, Aug 27 2014 17:30 - 20:00 Central Daylight Time
Add the meeting to your calendar: iCal
2310 Crossroads Dr Madison, Wisconsin
It's the building with the Cisco sign facing the interstate near East Towne Mall. Park behind the building and walk in main entrance. Our room will be straight ahead on the first floor. Get a Bing map to the meeting location.
If you are having trouble joining the meeting, try adding ?sl=1 to the URL to use the Lync web client.
Need Lync? (64-bit) (32-bit)Other Downloads