I have read about locking mechanism in sql server 2005. I do understand it, but not able to figure out in real time applications where do we need to use it. For eg : shared, update Lock, Row Lock etc.
SQL Server automatically implements all that. I heard some companies implement transaction locking at granular level, but am really not able to understand on what real time scenarios, we would want to Override the default SQL Server isolation levels. Can clear examples be given when to use them, in what type of scenarios we need to implement or change the default locking techniques.