select with nolock - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

select with nolock

Author

Topic

khatchik
Starting Member

9 Posts

Posted - 2001-01-31 : 20:13:04

Does SQL server use any resource when using nolock optimizer in a select query? For example, if I want a dirty select from a small table versus a big table, what is recommended?

Please assist.

Thanks, chris

chris isayan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources