Abstract:
This presentation covers a number of different SQL Server T-SQL coding best practices. There will be a discussion around each best practice so attendees will better understand the rationale behind each. Some of the best practices will have a demo to showing how different coding styles arrive at the same answer while using different amounts of SQL Server resources (CPU, and I/O). These demos will help attendees better understand how poor coding practices produce sub-optimal execution plans.
Bio:
Greg Larsen has been working with SQL Server since 1999. He current is working for the Department of Enterprise Services on a Data Warehousing project, and does part time consulting with DesignMind. Greg holds a Microsoft DBA and Developer certification in SQL Server 2005, and has been a Microsoft SQL Server MVP since 2009. Runs both the Olympia and Tacoma SQL Server Users group and is a PASS Regional mentor. Greg has also authored over 200 technical articles related to SQL Server technology.