Post
Ask Question
Basil Howitson

Basil Howitson

  • 1.5k
  • 126
  • 676

SQL Server Trigger options

Jul 1 2016 1:49 AM

I am in the process of giving one of the company's web apps a revamp. I will use ASP.Net MVC for the user interface and MS SQL Server for the back-end.

I busy with the optimization of a database, which includes its stored procedures and triggers.
  • What is the best practice with reference to the use of triggers and stored procedures?
  • Should most or all of the T-SQL be in stored procedures and the execution of the stored procedure triggered by the triggers; or should the T-SQL be in the triggers?
  • How is the speed of T-SQL affected through the use of stored procedures in triggers?

I appreciate any advice I can get.
 


Answers (2)