Use Triggers Or Not In SQL Server?steemCreated with Sketch.

in #data4 years ago

Check out the discussion in the video TSQL: What Are the Disadvantages of Using Triggers. One of the troubles with triggers involves troubleshooting - pay attention to the point made in the video. In addition, keep in mind that we may accidentally create an OLPT environment with transactions (think of a compounding effect with transactions).

Automating ETL
Check out the highest-rated Automating ETL course on Udemy, if you're interested in data.

In the past, I've seen an issue that arose because of what I mention in the video. As a note, the architecture behidn it was appropriate (as is often the case). However, because of the inherent reactive design (mentioned in the video), this was overlooked. There are better alternatives, especially when we consider what architects tend to use triggers to solve for in SQL Server.

YouTube | Automating ETL | T-SQL In 2 Hours | Consumer Guide To Digital Security

Coin Marketplace

STEEM 0.36
TRX 0.12
JST 0.040
BTC 70744.80
ETH 3561.94
USDT 1.00
SBD 4.80