SQL SERVER – Significance of Various Kinds of Triggers- Quiz – Puzzle – 2 of 31

Click here to get free chapters (PDF) in the mailbox

Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. Here is an article which discusses the Author’s Perspective. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level.

Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.

SQL Quiz

Every time a developer attempts to update TableA, the table is not actually updated. Instead, TableB is the one which is updated. After a while, the confused developer would figure out the reason for this condition; there was a trigger created on the table. What are the different types of triggers inside SQL Server 2008 R2 edition?

Link to participate in SQL Quiz

Notes of Vinod Kumar

The behaviors and options of using a Database backup are indeed critical. An effective DBA can harness the best results in the shortest time. Hint: It is like a great bookmark to understand the options available when looking for restore strategies with SQL Server. Also read the topics around ONLINE restores.

Notes of Pinal Dave

Frequently, I have seen developers using triggers as a shortcut for update and insert. When there are pressing situations and near deadlines, developers often depend on trigger to update/modify tables. Triggers are great objects to debug the application or unknown modification to table. However, triggers have performance overhead and are very difficult to identify from a procedural code. If possible, the logic of the trigger should be incorporated in the procedural T-SQL code. (Note: this note is written keeping DML triggers in mind).

Additional Notes

SQL Server Interview Questions and Answers ISBN: 1466405643 Page#24-25
Disadvantages (Problems) of Triggers
Server and Database Level DDL Triggers Examples and Explanation
Disable All Triggers on a Database – Disable All Triggers on All Servers
Interesting Observation of Logon Trigger On All Servers
Disable Triggers – Drop Triggers

Prize

There are exciting prizes awaiting the winners. Click here for Prizes and Frequently Asked Questions.

Link to participate in SQL Quiz

Note: The SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.

Reference: Pinal Dave (https://blog.sqlauthority.com)