Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David Bird SQL Overview VI - Monitoring Process Locks RE: SQL Overview VI - Monitoring Process Locks
jswong05
Hall of Fame
Points: 3553
More actions
July 23, 2011 at 8:35 am
#1357426
You should always have a cluster index on a table when you can. You should always use row-versioning based isolation level - in SQL Server snapshot isolation. In Oracle, it is done at "Read Committed" isolation.
Jasonhttp://dbace.us😛