Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Advanced SQL Server Triggers: Optimizing and Troubleshooting

The use of triggers is a fundamental concept in SQL Server as they provide a powerful way to automatically run complex business logic. This course will teach you to use nested triggers and to improve the performance of your SQL Server code.

Lucian Lazar - Pluralsight course - Advanced SQL Server Triggers: Optimizing and Troubleshooting
by Lucian Lazar

What you'll learn

Triggers in SQL Server provide powerful and flexible ways to automatically perform a wide range of actions in response to various events within the database system. Understanding when and how to use triggers effectively is crucial for database design and management.

In this course, Advanced SQL Server Triggers: Optimizing and Troubleshooting, you’ll learn to implement nested triggers in SQL Server.

First, you’ll explore the concepts of nested triggers and trigger recursion and how to configure them.

Next, you’ll discover how to optimize performance by writing efficient nested triggers.

Finally, you'll see a real-world example of how nested triggers improve the flow and the performance of data processing.

When you’re finished with this course, you’ll have the skills and knowledge needed to create and use nested triggers to improve the performance of your SQL Server code.

Table of contents

About the author

Lucian Lazar - Pluralsight course - Advanced SQL Server Triggers: Optimizing and Troubleshooting
Lucian Lazar

Lucian is a software developer and teaching assistant passionate about mentoring others in Oracle databases, PL/SQL programming and performance tuning.

More Courses by Lucian