The Rhode Island SQL Server Users Group (RISSUG) formerly (Southern New England SQL Server Users Group) is an official chapter of the Professional Association for SQL Server (PASS), an independent, not-for-profit association committed to providing SQL Server professionals around the world with the resources and knowledge necessary to achieve unparalleled business results. The purpose of the RISSUG is to provide an independent local forum for database administrators, developers and general users of Microsoft SQL Server as well as users and vendors of products and services related to Microsoft SQL Server to exchange knowledge and build professional relationships.
Window functions are the best thing added to T-SQL in decades. They perform great -- until they don't! Attend this session to learn how to get the best performance from window functions including the latest updates with SQL Server 2019.
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server since 1998 and has authored, co-authored, or tech edited over twenty technical books. Kathi is the co-leader of the Data Platform Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings.