I am enthusiastic about presenting to the Hartford SQL Server User Group on December 4, 2017.
Of course, I am looking forward to talking to my friends Todd Chittenden and John Flannery. If you have not figured it out yet, I love to chat to local user groups about any SQL server topic that I am passionate about.
The meeting venue is at the following address. Due to the holidays, I will be presenting remotely to fit this talk into my busy schedule.
29 South Main Street,
Please Park in Town Center Garage
West Hartford, CT
Details about the presentation are below.
Effective use of temporary tables
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.