- Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005
- Statistics Used by the Query Optimizer in Microsoft SQL Server 2005
- SQL Server 2005 Failover Clustering White Paper
- Database Engine Tuning Advisor (DTA) in SQL Server 2005 (.doc)
- Microsoft SQL Server I/O Basics Chapter 2
- How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888
- SQL Writer in SQL Server 2005: A Guide for SQL Server Backup Application Vendors
- Improving Performance with SQL Server 2005 Indexed Views
- Scaling Out SQL Server with Data Dependent Routing
- Database Concurrency and Row Level Versioning in SQL Server 2005
- Database Mirroring Best Practices and Performance Considerations
- SQL Server 2005 Snapshot Isolation
- Forcing Query Plans
- Managing Metadata in SQL Server 2005
- Troubleshooting Performance Problems in SQL Server 2005
- White Paper: How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888 (.doc)
- White Paper: Working with tempdb in SQL Server 2005 (.doc)
- White Paper: Project REAL Monitoring and Instrumentation
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro