Learn the ways in which you can get the best performance from your database and data access applications.

Optimizing Performance in SQL Server Solutions

Learn the ways in which you can get the best performance from your database and data access applications.

Improving SQL Server Performance
Get tips on optimizing your SQL Server performance and scalability in this chapter of the patterns & practices Improving .NET Application Performance and Scalability guide.
Optimizing Database Performance
Learn about the components of a SQL Server solution that may affect performance, as well as the tools and guidelines that can be used for component optimization.
Performance Comparison: Transaction Control
Discover the aspects of transaction control that affect performance, scalability, and maintainability by comparing transactions models of several transaction types.
Query Recompilation in SQL Server 2000
Take advantage of query recompilation to optimize your Transact-SQL performance.
SQL Server 2000 Incremental Bulk Load Case Study
Get recommendations on bulk load best practices for several indexed table scenarios based on these case study results.
Notification Services Capacity Planning and Performance Tuning
Discover Notification Services, common performance bottlenecks, and ways that you can design and test your own systems and applications for optimal performance.

Performance of BI Systems Built with Microsoft SQL Server Accelerator for Business Intelligence
Study the performance experiments conducted on a business intelligence (BI) system built with SQL Server Accelerator for Business Intelligence, and get recommendations for the operation of similar systems.
Microsoft SQL Server 2000 Analysis Services Performance Guide
Find techniques you can use to optimize query responsiveness and processing performance in SQL Server 2000 Analysis Services.
Optimizing Analysis Service Performance
Get information on the tools available for analyzing and optimizing Analysis Services applications.

Performance Comparison: Data Access Techniques
See the performance of various data access techniques in common application scenarios.
Connection Pooling for the .NET Framework Data Provider for SQL Server
Get an overview on using connection pooling with the Data Provider for SQL Server to enhance application performance.
Techniques in Filling ADO.NET DataTables: Performing Your Own Analysis
Find out which technique is best for retrieving data and populating a DataSet in ADO.NET in John Papa's guided tour of the different options.
Middle Tier Application Data Caching with SQL Server 2000
Get an overview of data caching, and then learn how to use SQL Server 2000 replication to create an effective caching solution.
Five Ways to Rev up Your SQL Performance
Get several tips to use for speeding up data access using Transact-SQL.
ADO Performance Best Practices
Follow along with Bill Vaughn as he shows you how to get the best performance from your ADO code when accessing SQL Server data.

Transactional Replication Performance Tuning and Optimization
Examine performance in transactional replication, and see the ways in which you can improve the performance of your applications.
Merge Replication Performance Tuning and Optimization
Get optimization suggestions for merge replication, including applying the initial snapshot, optimizing replication settings, and configuring replication for scalability, based on tests conducted using a variety of hardware configurations and replication environments.