T-SQL Awesomeness: 3 Ways to Write Cool SQL
Presenter: Audrey Hammonds
There’s nothing quite as satisfying as writing a cool bit of T-SQL. Luckily for us, there are some truly awesome ways to make your data do just what you need it to do, while improving performance and/or readability. Come learn three new-school ways to expand your T-SQL repertoire with:
• Recursive Common Table Expressions (CTE)
• EXCEPT and INTERSECT
• CROSS APPLY and OUTER APPLY
We will look at data models and scenarios you might encounter that lend themselves to these techniques, see old-school ways to solve T-SQL challenges, and then compare them to newer, leaner ways to get the same result set. Impress your friends and confound your frenemies with your mad T-SQL skills.
About the Speaker
Audrey Hammonds is a BI Consultant for Key2 Consulting in Atlanta, GA, and one half of the Datachix (www.datachix.com). She holds MCTS certifications in SQL Server 2008 Database Development and SQL Server 2008 Business Intelligence. Fourteen years ago, she volunteered for database training to escape the clutches of COBOL, and has never looked back. A firm believer in good fundamentals and solid design, she gets her kicks from making data do nifty things.