November 20, 2006 02:20 PM
Triggers and the Version Store
Keep an eye on tempdb's size when you use triggers with snapshot isolation
Rating:

(0)
SQL Server Magazine
InstantDoc ID #93826
Triggers are a long-standing feature of SQL Server, but in SQL Server 2005
Microsoft has redesigned triggers so that their internal details are much different
than before. As you learned last month in "The Hidden Costs of Row-Level Versioning,"
InstantDoc ID 93465, in SQL Server 2005 triggers use a new technology called
row-level versioning (RLV). Inside the trigger code, you can still access two
pseudo-tables, called inserted and deleted. In SQL Server 2005, the old and
new ve...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: