4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

"Cursors are evil"

That’s frequent advice given on forums when asking about performance problems. Its correct advice, but how do you go about removing cursors and what do you replace them with? That’s the tricky part! By deconstructing a cursor based routine, Dave will demonstrate a number of TSQL techniques and how they can be applied to generate a new routine with significantly less overhead.
Presented by Dave Ballantyne at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    dave_ballantyne.jpg

    Dave is a freelance SQL Server database architect / designer / developer / consultant and lives near London, England.  He is a regular speaker at UK and European events and user groups and currently is supporting the London SQL community by organizing the "SQL Supper" user group.  He takes a keen interest in all things SQL and data related and is never happier than picking apart a poorly executing query.  He has also created an open sourced add-in for SQL Server data tools (SSDT) called "TSQL Smells".  This detects and reports on 'suspect'  code within a project and can be found at http://tsqlsmellsssdt.codeplex.com . Outside of work he is husband, father of 3 and exasperated archer.

    http://www.clearskysql.co.uk http://dataidol.com/davebally/feed/
  • Video
    The video is not available to view online.