Assume that a user U1 is running a transaction on a table T1.
While the transaction is in process another user U2 tries to read from same table e.g T1.
Now what happens here sql server lock the table T1 for other users except than U1 for any kind of query execution.
Is it possible to allow user U2 to execute statement like SELECT * FROM T1 while transaction for user U1 is in process.
Please explain with examples.