1
vote
2answers
679 views

Transaction log full issue with SQL Server 2008 R2

I am running into 'transaction log full' issue with SQL Server 2008 R2. My database includes 80,000 tables which contains up to 5 columns of BIGINT and there is an index for each columns. The ...
2
votes
1answer
153 views

Snapshot transaction Isolation levels: it really works as advertised?

Have you any problems using it on high concurrency environment? It's really works as advertised by MS? I'm using SQL Server 2005 and would like to hear the experiences of those who are/was using it on ...