[quote="meristema, post:1, topic:4506"]
in SQL Server 2008 R2 Standard, can I enable Read Committed Snapshot and use it only for single table ?[/quote]
No, RCS ON is for the whole db.
That's actually not bad. You can use the ALTER DATABASE command noted above:
ALTER DATABASE <Database_Name> SET ALLOW_SNAPSHOT_ISOLATION ON
and then change the UPDATE statement to specify this command before it runs:
SET TRANSACTION ISOLATION LEVEL SNAPSHOT --active snapshot for this session
SET TRANSACTION ISOLATION LEVEL READ COMMITTED --return to not using snapshot
RC snapshot could me help but I don't want enable on all tables and transactions (for potential performance costs) but only for some table or some select transactions.
Excellent insight! Most people ignore -- or are ignorant of -- the overhead, which is indeed considerable. You're doing a great job of combining the best options to produce the best overall results.