.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

READ_COMMITTED_SNAPSHOT

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server
 

Hi all,

Sceanrio

User A inserts 1million rows into fact table
User B selects rows from fact table at the same time.

If i do the following

ALTER DATABASE MyDatabase
SET ALLOW_SNAPSHOT_ISOLATION ON
 
ALTER DATABASE MyDatabase
SET READ_COMMITTED_SNAPSHOT ON

 
what will this do?

I have read from the following link:http://msdn.microsoft.com/en-us/library/tcbchxcb%28VS.80%29.aspx

but dont understand this?

1. Will doing the above help me on my sceario?
2. Is it better then using SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

please help me?




View Complete Post


More Related Resource Links

READ_COMMITTED_SNAPSHOT vs Dirty Reads

  

Hi all,

I have a situation. When a user updates a fact table it locks the table and thus selects take a long time.

I am thinking of using either READ_COMMITTED_SNAPSHOT or Dirty Reads.

Can someone tell me why one would be better then the other and visa versa ie pros and cons of each?

thanks


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend