WHITEPAPER – Online Indexing Operations in SQL Server 2005

I wanted to post a quick blog about a new whitepaper from Microsoft. Introduced in Microsoft SQL Server 2005 Enterprise Edition, the online index feature provides a powerful way to perform maintenance operations such as rebuilding or creating indexes in a production system without sacrificing DML concurrency. Users are not blocked from querying and updating the…


WHITEPAPER – SQL Server 2005 Upgrade Technical Reference Guide

If you haven’t read this whitepaper, read it now.   This is a comprehensive upgrade guide that details all aspects of planning for and implementing an upgrade from your SQL 7.0/2000 to SQL 2005.   In this 360 page whitepaper, you will learn about:   Supported upgrade paths Planning your upgrade to SQL 2005, both…


WHITEPAPER – Working with Tempdb in SQL 2005

Tempdb has undergone a number of changes in SQL Server 2005.   Planning for tempdb deployment, configuring it for best throughput and continuously monitoring usage are critical for ensuring higher performance for your server.   In this whitepaper, you will learn about:   Enhancements in tempdb in SQL 2005 Identifying space requirements for your tempdb…


WHITEPAPER – Physical Database Storage Design

This whitepaper helps database architects and administrators configure Microsoft SQL Server 2005 systems for optimal I/O performance and space utilization.   In this whitepaper, you will learn about:   Internals of SQL Server physical design storage Reliability and performance requirements for the database system. Deciding upon the hardware to suit the above requirements Best practice…


WHITEPAPER – SQL Server I/O Basics

Ever wondered how SQL Server manages I/O to your disk system? Seen errors like 823, 824 and wondered what they mean and how to resolve them?   Bob Dorr, SQL Server Senior Escalation Engineer has published two great whitepapers describing the internals of SQL Server I/O.   SQL Server 2000 I/O Basics SQL Server I/O…


WHITEPAPER – Statistics Used by the Query Optimizer in Microsoft SQL Server 2005

SQL Server collects and maintains statistical information about indexes and column data stored in the database.   SQL Server query optimizer relies on these statistics to choose the most efficient plan for retrieving or updating data. If these statistics are not up-to-date, performance of your queries could be adversely affected.   This whitepaper provides great insights into…


WHITEPAPER – Diagnose and Correct Errors 17883, 17884, 17887, and 17888

Bob Dorr, Microsoft SQL Server Senior Escalation Engineer, is one of the most respected engineers in our team.   He recently worked on publishing a great whitepaper which describes the common causes and troubleshooting techniques for 17883, 17884, 17887 and 17888 errors.   In this whitepaper, you will learn about:   ·         Internals of SQL…


WHITEPAPER – Failover Clustering for Microsoft SQL Server 2005 and Analysis Services

  One of our colleagues, Dave Whitney, recently worked at publishing a whitepaper which covers the nuances of setting up a failover cluster of SQL 2005 and Analysis Service 2005.   We highly recommend that you download it to learn about the best practices of installing and administering your SQL Server 2005 failover cluster.   This…