Maine PASS

Welcome to the Maine PASS Chapter.

Please follow us on twitter to learn about upcoming events:  @MainePASS


Next Meeting




May User Group Meeting

  • In-Person @ 1 Tyler Drive Yarmouth, Maine, United States (map)
  • 18:00 - 20:00 Eastern Daylight Time
  • Language: English

RSVP and additional info:

Featured Presentation:

Effective use of Temporary Tables

John Miner, Sr Database Administrator / Developer Sensata Technologies Inc

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. Coverage: 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.

Supplementary Materials

The following event attachments are available to you:

Back to Top