Celebrating Life: The Princess Pumpkin Puss, A Pain In My Neck, Randy Pausch, & Lt. Col. Frank Slade Teach Us About Living Life

This is nominally a personal productivity as well as a SQL Server performance blog, but I seldom indulge that facet—too busy being productive, don’t you know? Ward Pond‘s annual amalgam (May Glad Tidings be Upon You) inspired me to do something similar.  My plans changed Sunday & instead I am writing to celebrate life. Princess…

8

SQL Server Schema Best Practices from the SQL Server Customer Advisory Team (SQL CAT)

An authoritative reference on schema usage in SQL Server 2005 is now available. Along with my buddy Joe Sack, it’s been my privilege in the last few months to serve as Technical Reviewer on white papers for the SQL Server Customer Advisory Team (SQL CAT). The latest-&-greatest has been released: SQL Server Best Practices –…

1

Disk Partition Alignment (Sector Alignment) for SQL Server: Part 4: Essentials (Cheat Sheet)

The purpose of this post is to document Disk Partition Alignment Essentials. It is intended for engineers who are already familiar with disk partition alignment yet want a “cheat sheet”.   As most of you know, partition alignment is an essential best practice. We are seeing I/O enhancements in the lab & at important real-life…

12

Case Study: Part 2: CXPACKET Wait Stats & ‘max degree of parallelism’ Option: Suppressing Query Parallelism Eliminated CXPACKET Waits & Liberated 30% of CPU

Introduction This is the second of a four-part series: Introduction to Query Parallelism Parallelism Suppression: Analysis, Remediation, & Results (this post) Parallel Query Identification & Remediation Summary Executive Summary In my first post in this series, I documented introductory information related to query parallelism in SQL Server. Be clear!  This series is not an indictment…

7