SQL Server Misc

SQL Server Views Tips (All)

Hints with Indexed Views SQL Server 2000/2005 Indexed View Performance Tuning and Optimization Tips Performance Tuning for Views


Allocation Page: A SQL Server page used to hold metadata about other SQL Server pages. Some examples of allocation pages are the Page Free Space page, the Global Allocation Map page, and the Secondary Global Allocation Map page. Bottleneck: Something that prevents SQL Server or a SQL Server application from running optimally. Often, this is […]

SQL Server-Related Web Sites

SQL Server Performance-Related Links 6 Ways to Boost ADO Application Performance (Microsoft) Compaq White Paper on SQL Server 6.5 Performance Tuning Microsoft White Paper on SQL Server 7 Performance Transactional Replication Performance Tuning and Optimization   General SQL Server Web Sites ASP.Net Enterprise Manager — Open source SQL Server and MSDE Web Interface Compaq — […]

SQL Server Resource Kit Utilities

The Microsoft SQL Server 2000 Resource Kit includes a variety of utilities that you may find useful. Some of the key ones include: ·         Administrative Stored Procedures: This is a series of stored procedures you can run to help identify non-standard SQL Server settings. For example: o    To check server configuration settings for potential improvements […]


Performance Tuning Tips for Creating Visual Basic Applications Using SQL Server ASP.NET and SQL Server Performance Tips Performance Tuning ASP Pages Using SQL Server ADO.NET and SQL Server Performance Tips

SQL Server Administration Tips (All)

Useful SQL Server DBCC Commands

SQL Server OLAP Analysis Tips (All)

Tips for Optimizing SQL Server OLAP/Analysis Services Hardware Performance Tips for Optimizing SQL Server OLAP/Analysis Services — Cube Performance Tips for Optimizing SQL Server OLAP/Analysis Services: Data Warehouse & Datamart Performance

SQL Server Application Development Tips (All)

Performance Tuning SQL Server ODBC Performance Tuning SQL Server OLE DB SQL Server XML Performance Tips Data Type Performance Tuning Tips for Microsoft SQL Server Performance Tuning Tips for Using Microsoft Access and SQL Server Together Performance Tuning Tips for Using Microsoft Visual FoxPro and SQL Server Together Tips on Optimizing SQL Server Database Design […]

SQL Server Configuration Tips

How to Performance Tune the Microsoft SQL Server tempdb Database SQL Server Service Pack SQL Server Federated Database Performance Tuning Tips Database Settings How to Performance Tune Microsoft SQL Server During Setup Link Servers Performance Tuning SQL Server’s Configuration Settings SQL Server Filegroups AWE Memory VLDB Performance Tuning and Optimization Tips for Using SQL Server […]

SQL Server Components Tips (All)

SQL Server Notification Services Performance Tuning SQL Server Full-Text Search Performance Tuning and Optimization

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |