SQL Shack round-up – July 3rd, 2014 – SQL Server cursor performance problems and exception handling in SQL Server 2012

In the last two weeks, SQL Shack articles focused on some performance issues and exceptions managing in SQL Server.

In SQL Server cursor performance problems, we explained common performance issues with SQL Server cursors, described the issues with appropriate examples, and analyzed their impact on the SQL Server performance. Additionally, we described why cursors are commonly used and what their nature is.

There are a number of methods in SQL Server that provides exception handling. In the Background to exception handling in SQL Server 2012 article we have briefly described the exception handling history in SQL Server and detailed usage of available exception handlers in SQL Server 2012. We also provided the comparison between the RAISERROR and newly introduced THROW statements.

July 3, 2014