13 December 2007 10:35
tonyrogerson
Session idea for SQLBits 2008 - what do you think?
Back to more advanced basics if that is not too much a contradiction in terms.
I'm thinking around a session that will cover some really cool but not very well understand features within SQL Server, first taking the time to explain at the basic level what they are and how they work and then steadily building into uses and advanced techniques, that is:
Derived Tables: what are they, how can they be used, comparison to CTE and temporary tables, logic bombs, nesting.
Case: when and how to use, how it's structured, streamlining aggregations using CASE.
Is there anything I'm missing that would complement these features?
Tony.
Filed under: SQL Server