After triggers, fires after the triggering action. The INSERT, Update and Delete statements, causes an after triggers to fire after the respective statemnts complete execution. INsted of triggers, ...
Thinking of batching DL operations in SQL Server? This simple tip will will explain on how to perform a DML operation in Batches in SQL Server.
- Very good DB and SQL skills specifically DML with ability to extract data from multiple tables and migrate them to the new DB structure. - DB performance tuning.