Contact Richmond SQL Server Users Group for event and ticket information.

Looks like this event has already ended.

Check out upcoming events by this organizer, or organize your very own event.

View upcoming events Create an event

Wayne Sheffield - Avoid the RBAR!

Thursday, September 8, 2011 from 6:00 PM to 8:00 PM (ET)

Glen Allen, United States

Ticket Information

Type End     Quantity
RSSUG September Meeting Ended Free  
SHARE THIS EVENT

Event Details

When: Thursday, September 8th, 2011, 6:30 PM - 8:00 PM 
Social Time starts at 6:00 PM! 

Who: 
Wayne Sheffield

Wayne Sheffield is a Sr. SQL Server DBA, currently working with General Electric Healthcare in Richmond, Va. With twenty years in the IT industry, he has spent the last 12 working with SQL Server database systems (starting from version 6.5). He is the author of several articles at www.sqlservercentral.com, where he also is active on the forums assisting the community.

Abstract

SQL Server is primarily designed for set-based operations, so writing code that performs Row-By-Agonizing-Row (RBAR) operations is going against the design, rather than working with it. In this code filled “Developer–to–Developer” session, 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 with table-valued functions; iterate through incoming data just once with the MERGE statement instead of once per DML operation; see how the Windowing (ranking) functions allow you to “slice and dice” your data, and then perform operations on those groupings; discover how re-writing your multi-statement table-valued functions to be inline functions can help the optimizer and speed up your queries; and learn how to create a grouped delimited list – without loops! Come to this demo-packed session and learn how the vast majority of loop-based operations can be replaced with very efficient set-based operations!

Where:  Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 23060 [
map]

Register: Click here to register!

This Months Sponsor: