Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 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
Additional Resources
- Pessimistic locking solves ADO.NET concurrency problems
- One way to work around optimistic concurrency issues in ADO is to lock the records your DataSet retrieves as soon as the edit operation begins. This strategy is known as pessimistic locking. Long-duration locks generally lead to poor database performance and contention problems, but in situations where an application cannot...
- Tags: .NET, Databases, Craig Utley, Microsoft ADO.NET, Set DataAdapter, cmdFill, event handler
- Technical articles 2003-02-24
- 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
- Implementing SQL Server transactions with ADO.NET
- ADO.NET provides everything you need to workwith back-end data, which can be as simple as reading a set of datafrom one table to performing a transaction. A transaction allowsyou to group database operations to ensure that all the operationsare performed because, if one operation fails, the wholetransaction fails. Let's take...
- Tags: banking, Microsoft ADO.NET, server, SQL, Tony Patton
- Technical articles 2005-06-30
- Implementing SQL Server transactions with ADO.NET
- A transaction is a group of operations combined into a logical unit of work. Learn how to use transactions within the .NET Framework. ADO.NET provides everything you need to work with back-end data, which can be as simple as reading a set of...
- Tags: Microsoft ADO.NET, Databases, Tony Patton, .NET, System.Data.SqlClient namespace, banking, IsolationLevel property, SQL, server, .NET Newsletter, TechRepublic Inc., Transaction, Microsoft SQL Server, IsolationLevel, Storage, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2005-06-30
- << Previous
- page 1 of 1
- Next >>
