I am really honored to have the opportunity to present at SQL Saturday #262 in Boston.
It will be a good time to meet old friends and make new ones. Since, the schedule has not officially been posted, I can not name the headliners that I looking forward to hear presentations from. I will update the post later with this information.
I hope you have time to attend this awesome free event on March 29th, 2014! It only costs $10 if you want a lunch.
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.
Here is a previous slide deck. I will update later for this event.