November 28, 2013 in Meetings
When: Thursday, Dec 12th
Pizza at 5:30 PM
Meeting at 6:00 PM
Where: New Horizons
4775 American Way
Memphis, TN, 38118
Join us on Thursday, Dec 12th, as Kathi Kellenberger talks to us about we can improve our querying skills by using the T-SQL Window Functions.
As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.
Writing Better Queries with T-SQL Window Functions
SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.
This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You’ll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
Kathi Kellenberger is a senior consultant with Pragmatic Works. She has written more than 24 articles on SQL Server topics, is author of “Beginning T-SQL 2008,” and is co-author of “Professional SQL Server 2005 Integration Services,” “Beginning T-SQL 2012,” and “SQL Server MVP Deep Dives.” When Kathi isn’t working, she enjoys cycling, singing (she started #sqlkaraoke), and spending time with family and friends.
Number of View :702