Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Using NOLOCK and READPAST table hints in SQL Server
- Is NOLOCK really required for SQL2005?I am in a large shop and the omittion of nolock is a firing offence, well, with SQL2000. I am hearing, 'NOT SO' with SQL2005. Can a DBA type substantiate this fact?wow, thats extremeThat seems a bit like an extreme, especially since it...
- Tags: Databases, Microsoft SQL Server, server, mgoff2@..., READPAST, NOLOCK, SQL
- Discussion threads 2007-05-22
- Using NOLOCK and READPAST table hints in SQL Server
- Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server. When data in a database is read or modified, the database engine uses special types of controls, called locks, to...
- Tags: Microsoft SQL Server, NOLOCK, SalesHistory, Databases, Storage, Tim Chapman, server, lock, database, SQL Server Newsletter, Transaction, Data, Statement, Record, Downside, Table, READPAST, UPDATE Statement, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2007-05-21
Additional Resources
- Sql-Sever 2000 DBA Help
- Their is a specific problem in my ms-sqlsever 2000database as i am having 3 Big tables A,B,C and each table contains around 1 million record and all 3 tables contains clustered index which is always incremented and apart of that their are unclustered index also on each tables. My system...
- Tags: database, hardware, insert, singh_surjit@...
- Q&A 2005-03-02
- Control SQL Server locking with hints
- Over the past few years, SQL Server has blossomed from a small office data store to an enterprise-level database server. The number of users concurrently accessing a database also increased with this upgrade. SQL Server 2000's standard approach to locking resources often seems inefficient, but thankfully it provides features to...
- Tags: lock, Microsoft SQL Server, database, Baseline Inc., server
- Technical articles 2004-04-12
- Using advanced table hints in SQL Server
- Tim Chapman explores the benefits and side effects of using three types of table hints when running queries in SQL Server: READCOMMITTED, REPEATABLEREAD, and SERIALIZABLE. My previous SQL Server column covered two types of table hints: NOLOCK and READPAST. This article explores the advantages and drawbacks...
- Tags: Microsoft SQL Server, Tim Chapman, Session2, SaleID, Databases, server, ReadCommitted, SalePrice, RepeatableRead, lock, SQL Server Newsletter, Database, Transaction, Data, Record, Table, Session1, SalesHistory, TRANSACTION, Enterprise Software, Storage, Software, Data Management, Hardware
- Technical articles 2007-05-25
- << Previous
- page 1 of 1
- Next >>
