The statistics are fine. Look at the equivalent rows and the average range rows. Any value that uses the histogram is going to come back as one row. It has...

You have 1.4 million rows of distinct data and the statistics histogram shows a single row?

Actually, believe it or not, that may be right. If, the average range...

A combination of source control (flavor of the month is Git and GitHub) and the Snippets in SQL Prompt. Source control ensures I have backups in a central location as...

The principal reason to use Extended Events isn't performance (although, filtering). There are two primary reasons. One, absolutely no new functionality has been added to Trace since 2008. Nothing. Anything...

Flat out, if you're not parameterizing the queries in some method, through stored procedures, through the code, or through parameters defined in sp_executesql, you are almost...

Just plucking out the relative bits:

'Cannot create a file when that file already exists.'...

Here's a set of methods on how you can deal with versioned data. Instead of a GROUP BY, I'd suggest using a TOP 1 with an ORDER BY....

A yahoo email address, so I suspect spam too.

However, in the interest of being nice, Christmas time & all...

We try to help out here as much...