rafa.aborges (4/5/2010)
is there any extra cost? Something that I should be aware of?
* Increases resource usage when modifying data since row versions are maintained in tempDB.
* Update and Delete transaction will use more resource since it has to create a snapshot
in the tempDB. This could cause higher IO, CPU and Memory usage.
* TempDB must have enough space to handle all the additional requirements.
* If there are long version chains then Data Read performance will be affected.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)