December 2008 - Posts

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. Read More...
Posted 30 December 08 01:29 by Jimmy May | 8 Comments   
Filed under , , ,
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 Read More...
Posted 10 December 08 12:12 by Jimmy May | 1 Comments   
Filed under , , ,
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. Read More...
Posted 04 December 08 10:40 by Jimmy May | 11 Comments   
Filed under , , , , , ,
Attachment(s): Disk Partition Alignment (Sector Alignment) for SQL Server - Part 4 - Essentials (Cheat Sheet) -- Jimmy May.zip
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 Read More...
Posted 02 December 08 11:49 by Jimmy May | 3 Comments   
Filed under , , , , ,

Search

This Blog

Syndication

Page view tracker