-
Wayne Sheffield
4.64
Description:
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!
Comments on this Talk
I am not well versed in some of the code concepts that were used as the basis of many of the examples, which made following the core concepts difficult at times. Some of Wayne's manipulation of the code text appeared awkward. Nevertheless, the content was excellent, and in the end I am chomping at the bit to put his concepts into practice at my job.
Patricia Bryant,
09 Sep 05:32 PM
I loved the presentation, it took the base concepts to the next level. You can tell that Wayne says on the cutting edge of the new concepts and that's not easy to find in todays companies. I must have joted down the URL incorrectly so I can't locate the presentation which I would love. I do wish that the user group would post these on their site "URL" so it was easy to access.
This is the second presentation that Wayne has delivered and I have learned a small mountain. He really knows the topics he delivers and is always well prepared to deliver samples in a seamless manner. He is never surprised by questions. I can't wait until his next presentation.