Probe Residual on Hash Match

I have to say, I only recently noticed this on a tool tip:

and this in the property sheet:

The bad news...

SELECT COUNT(*) vs COUNT(1) vs COUNT(ColumnName)

What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a...

ColoradoSQL in September

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...

How pure is your data?

It was a normal Monday. I was going over some HA designs and planning the joys of setting up log...

I Don’t Know

I wanted to write this because lately I say “I don’t know” a couple times a day to my client/boss....

Normalize your Linked Server Names

This is a technique I’m sure many people are already using in their environments.  Instead of using the actual name...

Speaking at SQL Saturday 89

With a late cancellation with one of our speakers a hole was opened on our speaker lineup.  I reached out...

SQL Saturday #92 Lunch: Bend Area Gathering

There's nothing more I love than free food and SQL Server, no joke.  I take my free food and SQL...

SQL Server “Denali”: Installing on a Virtual Machine

With CTP3 for SQL Server Denali available, a lot of us want to play with all the new cool features, as well as...

SQL Server 2011 “Denali”: Four new useful DMV

SQL Server 2011 “Denali” CTP3 introduced couple of new Dynamic Management Views (DMV). However, documentation says that some of them...