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.

Related posts:

  1. SQL Shack round up – August 15th, 2014 – Review SQL Server failed logins, Performance dashboard reports in SQL Server 2014, SQL Server Management Studio performance reports, and SQL Server commands – Dynamic SQL
  2. SQL Shack round-up – October 17th, 2014 – Performance reporting and auditing in SQL Server, Cryptographic features, Continuous integration with SSDT and TFS, and Index strategies
  3. SQL Shack round-up – May 1st, 2014 – SQL Server disaster recovery, Policy Based Management, SQL Server statistics, SQL Server Business Intelligence, and the SQL Server sequence object feature
  4. SQL Shack round-up – June 15th, 2014 – SQL Server Business Intelligence, SQL Server cursors, and SQL Server Management Studio configuration
  5. SQL Shack round – up – November 19th, 2014 – Loading data from SharePoint, Slipstreaming SQL Server, and Reporting Services
July 3, 2014