Rebind and Rewind in Execution Plans

Ever looked at an execution plan? If you answered no, you can’t possibly have ever tried to tune a query,...

Speaking at the 2011 PASS Summit

I submitted three sessions to the 2011 Summit for consideration and I heard today that two of them were accepted,...

Speaking at the 2011 PASS Summit

The emails came in today and 2 out of 4 of my sessions were selected. Both are the ones I...

SQL Books Arrived Today

A small post regarding a couple SQL books I bought from Amazon.
A couple new books arrived in the mail from...

SQL Saturday #89 Atlanta GA

The official launch of SQL Saturday #89 was June 8th.  Within the first week of the launch we have registered...

SSRS Error: Cannot read the next data row for dataset Dataset1

This error , Cannot read the next data row for dataset Dataset1, is thrown for many reasons, at least I have seen...

The 2012 Rally

In case you hadn’t heard, the 2012 SQL Rally will be in Dallas. Andy Warren talks about the process for...

Things That Should Be In TSQL

Relation Types

create type type_T(i int primary key clustered, j int check (j > 0)) -- relation type. Includes constraints!
create table T(type_T)

Relvar Assignment

This...

Three New TPC-E Submissions

I just noticed three very recent new TPC-E Benchmark Submissions that I thought were quite interesting. As I have written...

vCentre Useful Queries: Part II

After posting on twitter last week that I needed something to write a blog post about my good friend Christian...