Fewer Cursors Since SQL Server 2012 Came Along
Play Fewer Cursors Since SQL Server 2012 Came Along
It's one thing to say that cursors are bad and should be avoided. It's another to know how to leverage T-SQL features to achieve the same kind of functionality. SQL Server 2012 introduced new ways of solving many problems that used to force people into the world of checking the fetch_status come to this demo-heavy session to see how you can use this functionality to improve performance by orders of magnitude.