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
- Subquery Needed?
- Using the sql script below in SQL Query Analyzer to determine the member’s primary care physician, the physician who provided the service and the medical group IPA of the primary care physician.Select t.MEMBER_NBR, pr.PROV_ID as SvcProviderID, pr.PROV_RELATION_PROV_ID as PCPProvID,pti.PROVIDER_TAX_ID -- Is this the tax id of the PCP?,case...
- Tags: lacwill@..., physician, pti.PROVIDER_TAX_ID, medical group, pr.PROV_RELATION_PROV_ID, provider_id
- Discussion threads 2007-08-03
- SQL Server 2000 Deadlock
- Our production DB is SQL Server 2005 and there is a replication process to SQL Server 2000 DB, which is the base for the analysis processes.Right after creating that replication all the problems have started.Few SP which we used to run are so slow (1.5 hrs) up to impossible to...
- Tags: Databases, zachi.fernaldes@..., replication, Microsoft SQL Server, Microsoft SQL Server 2000
- Discussion threads 2007-09-10
- How do I... Query foreign data using SQL Server's linked servers?
- Great option....but not for high traffic applicationsThere is no doubt that this is a great feature. But you should think of alternative options if the application has heavy traffic as the database hit using linked server is a pretty costly one. This is mainly because of retreiving data over the...
- Tags: Databases, sekhar@..., server, ODBC, Microsoft SQL Server
- Discussion threads 2007-07-10
- 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
- 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
- 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
- Return resources to the system to improve .NET performance
- The promise of .NET's garbagecollection feature meant no more worrying about object cleanup since .NET handles everything behind the scenesautomatically. But I continually face database connections gone bad as developers fail to clean up after themselves. I'llexplore this problem in more detail and suggest how you can avoid such issuesin...
- Tags: database, Microsoft .NET, performance, Tony Patton
- Technical articles 2006-08-15
- Return resources to the system to improve .NET performance
- A common problem in the .NET platform is the consumption of system and database resources when developers fail to clean up after themselves when working with a database. Tony Patton notes that you can avoid such problems by releasing objects back to the system. The promise of .NET's garbage...
- Tags: Microsoft .NET, Storage, Databases, Tony Patton, .NET, Application servers, Middleware, performance, database, Microsoft SQL Server Transact-SQL, server, .NET Newsletter, Method, Problem, Connection, Exception, Database Connection, ADO.NET Connection Class, Hardware, Enterprise Software, Software, Data Management, Software Development, Software/Web Development
- Technical articles 2006-08-15
- Increase SQL Server stored procedure performance with these tips
- Database developers often use stored procedures to increase performance. Here are three tips to help you get the most from your SQL Server stored procedures. We've even thrown in a bonus performance tip for counting records without accessing a table.Developers often take advantage of stored procedures to enhance the performance...
- Tags: Performance management, Databases, server, Kevin Brown, stored procedure, Use NOCOUNT, database, performance, Microsoft SQL Server
- Technical articles 2002-03-05
- Best practices to enhance your SQL Server applications
- Get the most out of your application development efforts by familiarizing yourself with SQL Server. Follow these guidelines to build better applications.If you are developing a database application with SQL Server, you must take time to learn how SQL Server works (especially SQL-DMO and DTS). There are a lot of...
- Tags: Databases, Enterprise software, Roy C. Hoobler, Microsoft SQL Server, Microsoft SQL Server Transact-SQL, server, database, best practice
- Technical articles 2002-12-10
- << Previous
- page 1 of 1
- Next >>
