Next Meeting: Wed, Nov 19 2014
Bridging The Gap: Embracing Set-Based Thinking
Larry Toothman, Database Administrator UnityPoint Health
For many who come to T-SQL from other languages, dealing with result sets and thinking in set based solutions can be frustrating. Our minds are conditioned to think in processing rows of data, not entire sets. As a consequence many give up and misuse cursors or come up with other ways to create RBAR (Row By Agonizing Row) solutions. Some others try to deal with sets but get caught in the tangle of nested queries. In this session I will deal with Table Expressions with particular emphasis on CTEs or Common Table Expressions. Let me show you how using these simple tools can help simplify your code, bridging the gap between RBAR and set based solutions.
Larry has a BFA in Theatre and several MS certifications. He has been a Database Administrator for a non-profit health system in Cedar Rapids, IA since late 2007. With over 20 years of software and database development experience, he was drafted to be the DBA in 1999 for a dev company. Amazed by the wide variety of people in the SQL Server community as well as the support from the "SQL Family" Larry is always looking for opportunities to pay it forward, spread the word & mentoring.
5:30 PM - 5:45 PM -- General Announcements
5:45 PM - 6:30 PM -- Food & Networking
6:30 PM - 7:45 PM -- Main Presentation
7:45 PM - 8:00 PM -- Wrap-up
Event Time : Wed, Nov 19 2014 17:30 - 20:00 (GMT-06:00) Central Time (US & Canada)
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