SQL Server Articles

SQL Server Articles

ADO/OLEDB Information

Q297266 FIX: SQLOLEDB: Incorrect Transaction Enlistment Causes Hang
Q174518 INFO: Errors Raised by Remote Data Service
Q188858 PRB: "Command Time Out" Property Does Not Work
Q190991 HOWTO: Trap for ADO Connection Errors Using WithEvents
Q191572 INFO: Connection Pool Management by ADO Objects Called From ASP
Q195489 PRB: CommandTimeout Does Not Inherit From Connection Timeout
Q237844 HOWTO: Enable ODBC Connection Pooling in VB ADO Application
Q175264 FIX: CommandTimout Property Problem with Connection Object
Q274423 FIX: ADO Suppresses Errors Fetching into Nonvariant Datatypes
Q195236 HOWTO: Get ADO Default Connection Information

Error Handling

SQL Server 2000 Books Online Topics

"Handling Errors and Messages in ADO"
"Using @@Error"
"Error Handling"
"Handling Deadlocks"
"ADO Connection and Error Handling"

Q44519 INFO: Error Handling in Transact-SQL
Q142926 PRB: Handling Errors Caused by the MSRDC Update Method
Q187942 PRB: Catastrophic Error Occurs Referencing ADO Recordset
Q172403 How to Use ADO with Visual Basic
Q168336 HOWTO: Open ADO Connection and Recordset Objects

Performance

SQL Server 2000 Operations Guide
SQL Server Performance and Scalability References
Inside SQL Server 7.0/2000 by Kalen Delaney
The Guru's Guide to Transact-SQL
Q224587 INF: Troubleshooting Application Performance with SQL Server
SQL Server Query Performance Troubleshooter
Understanding Performance Testing
Q224587 INF: Troubleshooting Application Performance with SQL Server
Q243586 INF: Troubleshooting Stored Procedure Recompilation
Q197297 Comparison of Join Techniques
Q195565 How SQL Server 7.0 Autostats Work
Q180775 INF: Client Effects on SQL Server Throughput
Q175658 How to gather Information for effective troubleshooting of Performance
Q230785 - SQL Server 7.0 Logging and Data Storage Algorithms Extend Data Reliability
SQL Server 7.0 Performance Tuning Guide
SQL Server 7.0 Query Processor

Transaction Units

Q198024 INFO: Understanding ADO Transactions with MS SQL Server
Q295108 INF: Incomplete Transaction May Hold Large Number of Locks
Q295027 INF: Limited Support for Savepoint in Distributed Transactions
Q281633 FIX: SQLOLEDB Provider Incorrectly Leaves Transaction Open

SQL Server Directory

How to Troubleshoot a Performance Problem
Troubleshooting Blocking
How to Move a Database
Get the Latest Service Pack
Misc. Tips and Tools
SQL Server Knowledge Base Articles
Common SQL Server Answers
SQL Server and Related Links