INETA Specials
   Search
 
Communities Minimize
          
INETA Charter Member
Meetings Minimize
      
Philly Code Camp 2009.2!
Mike Welsh Minimize
Mike Welsh Database 12:30 room 108

Cursors vs. Set Logic: Alternatives to Cursors

There are times when cursors are needed.  But this talk will try to guide development away from cursors.  It will give techniques to use instead of cursors and some functions new to SQL Server that lessen the need for cursors.  It will also go through the thought process of changing cursors into set-logic-based SQL code.
Mike Welsh is a SQL Server database administrator with over 10 years experience in a variety of database platforms including Oracle and Sybase.  He has performed a full range of SQL Server DBA duties using ERP, CRM, and PeopleSoft-based HR databases.  He has experience in the financial, distribution, manufacturing, retail, and defense industries.  He is skilled as an application and production DBA as well as a data modeler.  Mike resides in Wilmington, Delaware.