Share via


Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity

News you can use on implementation of the elusive sqlservr.exe /faster switch & personal effectiveness

Capping off a fantastic third week of presentations (see #SQLSatSLC & #SQLSatOregon), I’m...

Date: 11/06/2014

This Halloween weekend I continue my efforts to make the world of SQL DWs a better place—one table...

Date: 10/31/2014

Where in the World is AdventureWorks? Recently, SQL Community feedback from twitter prompted me to...

Date: 08/20/2014

Preamble This is the second in a series of posts documenting big wins encountered using columnstore...

Date: 05/26/2014

Preamble This is the first in a series of posts documenting big wins encountered using columnstore...

Date: 05/19/2014

Hot off the presses is this new MSDN white paper: Optimizing Your Query Plans with the SQL Server...

Date: 04/17/2014

In the latest-&-greatest effort in my mission to deliver my Columnstore presentation to every...

Date: 04/08/2014

The History Though Columnstore indexes were introduced in SQL Server 2012; they're still largely...

Date: 03/24/2014

Introduction I continue to receive dozens of inquiries each year about this issue. The...

Date: 03/14/2014

In my first post on Xperf, I described the simple 4.4MB download necessary to install the Windows...

Date: 11/24/2009

Say It Ain’t So! In my first post on Xperf, I described the simple 4.4MB download necessary to...

Date: 11/22/2009

New! Improved! v.3.3.0 Now Available on CodePlex! Preamble SQLIOSim Parser shreds the results of...

Date: 09/27/2009

Greetings, my current colleague & former MVP Lara Rubbelke (blog | twitter) was gracious enough...

Date: 09/14/2009

I’ve been aware of the buzz around xPerf for quite some time.  I flagged emails from Microsoft...

Date: 09/08/2009

Data Compression: Strategy, Capacity Planning and Best Practices Hot off the presses, the SQL CAT...

Date: 05/29/2009

SQL IT Operations Excellence IP Architect, colleague, & friend Ward Pond tagged me in a meme...

Date: 05/18/2009

If you’re reading this, you survived last week’s Google glitch. Learn more here about the events of...

Date: 05/16/2009

Preamble I had the opportunity to perform a tech review of a very cool article by Benjamin...

Date: 05/15/2009

I recently collaborated with Microsoft PFE Daniel Janik to create a template to make the case for...

Date: 05/08/2009

J.D. Meier is a Principal Program Manager for Microsoft’s Patterns & Practices team.  He’s...

Date: 04/28/2009

Wait stats rock. As I shared recently with friends, when it comes to SQL Server performance, wait...

Date: 04/27/2009

Preamble For those of you who are already facile with SQL Server wait stats, there’s nothing new...

Date: 04/26/2009

A few weeks ago Cindy Gross brought this tweet to my attention from SQL Server MVP Jason Massie:...

Date: 04/16/2009

The long-awaited SQL Server 2008 SP1 was just released, available at an Internet near you right NOW:...

Date: 04/09/2009

In my role with MS IT's Assessment, Consulting, & Engineering (A.C.E.) team, I work with some of...

Date: 03/19/2009

This is a follow-up to last week's post in which I shared the fantastic perf enhancements in the...

Date: 03/16/2009

SAN Over-SubscriptionThere are a variety of challenges related to I/O performance. One common...

Date: 03/15/2009

It's a beautiful day. For years now the been hurry-up-&-wait icon has plagued our productivity;...

Date: 03/12/2009

My multi-talented, java-enabled yet Windows-empowered friend Alik Levin of www.practicethis.com...

Date: 03/11/2009

While at the PASS Community Summit in November 2008, I had the pleasure of attending a handful of...

Date: 03/01/2009

My decision to focus on the SQL Server vertical has paid off for me—metaphorically & literally....

Date: 02/23/2009

In my work with external customers, I collaborate with some excellent DBAs & Architects. But...

Date: 02/22/2009

I've long been an advocate of the best practice of explicitly setting the transaction isolation...

Date: 02/02/2009

An authoritative reference on schema usage in SQL Server 2005 is now available. Along with my buddy...

Date: 12/10/2008

The purpose of this post is to document Disk Partition Alignment Essentials. It is intended for...

Date: 12/04/2008

Introduction This is the second of a four-part series: Introduction to Query Parallelism Parallelism...

Date: 12/02/2008

Next>