Beware the Hidden Side Effects of SQL Server Triggers
Автор: Pluralsight
Загружено: 2012-12-20
Просмотров: 1903
Watch the full HD course: http://pluralsight.com/training/cours...
While triggers can be a useful tool in your SQL Server arsenal, they do come with some side effects. In this video excerpt from Joe Sack's new course SQL Server: Common Performance Issue Patterns you'll see how a trigger doubles IO time for inserts and how a quick change to the table can accomplish the same functionality without the need for a trigger. In the full course Joe covers topics such as inadequate I/O paths, lock escalation, and execution memory issues.
~-~~-~~~-~~-~
Push your limits. Expand your potential. Smarter than yesterday-
• Help your team become smarter than yesterd...
~-~~-~~~-~~-~
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
