2013-04-25
1,828 reads
Triggers
2013-04-23
1,807 reads
2013-04-19
1,766 reads
2013-04-09
1,945 reads
2011-11-02
2,273 reads
Avoid External Dependencies in SQL Server Triggers
I sometimes want to perform auditing or other actions in a trigger based on some criteria. More specifically, there are a few cases that may warrant an e-mail; for example, if a web sale takes place that requires custom or overnight shipping and handling. It is tempting to just add code to the trigger that sends an e-mail when these criteria are met. But this can be problematic for two reasons: (1) your users are waiting for that processing to occur, and (2) if you can't send the e-mail, how do you decide whether or not to roll back the transaction, and how do you bring the problem to the attention of the administrator?
2011-02-14
2,819 reads
2010-06-09
8,428 reads
2010-05-27
3,106 reads
2010-05-19
3,099 reads
2010-02-24
3,545 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
FARE Lab's Leading FSSAI Third Party Auditing Services
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
FARE Labs is The Leading FSSAI Third Party Auditing Services of India.
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers