Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-02-01 : 05:35:01
|
| Hi when we execute a simple Qry like select * from empwhy do i see a lock placed which of type dblock.and it takes around 5 min to release it. can i reduce the time of release.======================================Ask to your self before u ask someone |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-01 : 08:51:11
|
| http://www.sql-server-performance.com/blocking.aspMadhivananFailing to plan is Planning to fail |
 |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-02-02 : 09:17:20
|
| Thanks Madhivanan but the link does not talk db locksto my knowledge i have all indexes and no locks specified when access the data dataset ======================================Ask to your self before u ask someone |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-02 : 09:32:17
|
| I think by default lock will be applied to the table if you use them in queries. you can apply NoLock hint.Select columns from yourtable(NoLock) where some_ConditionsMadhivananFailing to plan is Planning to fail |
|
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2006-02-02 : 10:29:49
|
| Nolock is equivalent to the isolation level READ UNCOMMITTED. I would carefully think about it if this is the right choice. --Frank KalisMicrosoft SQL Server MVPhttp://www.insidesql.deHeute schon gebloggt? http://www.insidesql.de/blogs |
|
|
|
|
|
|
DB Locks