Chapter 16. Considerations When Using Stored Procedures and Triggers

IN THIS CHAPTER

When developing applications that use stored procedures and triggers, you need to be aware of a number of issues. These issues usually revolve around performance issues that can arise with poorly designed stored procedures and triggers. In this chapter, I will cover some of the performance issues that you can run into when using stored procedures and triggers, as well as some concurrency issues.

In this chapter, I will cover the following:

  • Problems with stored procedures

  • Problems with triggers

  • General performance issues

Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial