On Thursday, Sept 1, 2011 at 7:15pm EST, I’ll be presenting via LiveMeeting to the Curacao SQL Server User Group. This will be my second time presenting to these great folks, and I’m really looking forward for this return visit.
The topic is Banish RBAR!, and the abstract for it is:
SQL Server is primarily designed for set-based operations, so code that performs Row-By-Agonizing-Row (RBAR) operations is going against the design, rather than working with it. Come to this code filled session, where we will examine several recent additions to SQL Server, and learn how the vast majority of RBAR code can be replaced with efficient, set-based code. Learn how the APPLY operator works; iterate through incoming data just once with the MERGE statement; “slice and dice” your data with the Windowing (ranking) functions; re-write your multi-statement table-valued functions to inline functions to help the optimizer and speed up your queries; learn how to create a grouped delimited list – without loops!
If you’d like to attend virtually, the LiveMeeting link is right here.
A big thanks to the Curacao SQL Server User Group for allowing this to be seen over the entire web!