Please follow us on twitter to learn about upcoming events: @MainePASS
RSVP and additional info: mainepassmay.eventbrite.com
Abstract: Every developer eventually comes against business logic that can’t be handled with a single simple or complex query. TSQL provides the developer with several constructs that can store temporary result sets that are passed to the next query in the script. I will be covering these various TSQL techniques with examples using the [AdventureWorks] database as well as a toy database called AUTOS. The pros and cons of each construct will be examined. Advanced options like enabling trace flag 1118 will be explored.
1 – Derived tables.
2 – Local temporary tables.
3 – Global temporary tables.
4 – Table variables.
5 – Common Table Expressions (CTE).
6 – User databases in [tempdb].
7 – Trace Flag 1118.
Session Level: Intermediate
About John:John has over twenty years of IT experience including a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He also has Microsoft Certificates for Database Administration (MCDBA) and System Admistration (MCSA). John is currently a Senior SQL Server Developer / Administrator in charge of best practices by the IT team at Sensata Technologies.
The following event attachments are available to you: