
set transaction isolation level snapshot
begin tran
select * from authors
update authors set au_fname = 'sam'
 where au_lname = 'white'
commit

select count(*) from bigtable

insert bigtable values('lll')