SQL Server Misc

SQL Server Views Tips (All)

Hints with Indexed Views SQL Server 2000/2005 Indexed View Performance Tuning and Optimization TipsPerformance 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 ServerASP.NET and SQL Server Performance TipsPerformance Tuning ASP Pages Using SQL ServerADO.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 PerformanceTips 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 ODBCPerformance Tuning SQL Server OLE DB SQL Server XML Performance TipsData Type Performance Tuning Tips for Microsoft SQL ServerPerformance Tuning Tips for Using Microsoft Access and SQL Server TogetherPerformance Tuning Tips for Using Microsoft Visual FoxPro and SQL Server TogetherTips on Optimizing SQL Server Database DesignSQL Server Application Design Performance Tuning […]

SQL Server Configuration Tips

How to Performance Tune the Microsoft SQL Server tempdb DatabaseSQL Server Service PackSQL Server Federated Database Performance Tuning TipsDatabase SettingsHow to Performance Tune Microsoft SQL Server During Setup Link ServersPerformance Tuning SQL Server’s Configuration SettingsSQL Server FilegroupsAWE MemoryVLDB Performance Tuning and OptimizationTips for Using SQL Server 2000 64-BitPerformance Tuning SQL Server CE

SQL Server Components Tips (All)

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