Reason for Early Termination of Statement

Wouldn’t you like to know why the optimizer stopped tuning the execution plan you’re looking at? It’s actually possible and...

Recompiles

I’ve looked at cache hit and miss events and at the cache insert and remove events. The only cache-monitoring event...

Scheduled Out

I’m all scheduled out for the next week with newsletters and content ready to go through Nov 29. I’m not...

SQLSaturday#59 Special Interview with Melissa Demcsak, aka SQLDiva

 SQLSaturday#59 Special Interview with Melissa Demcsak, aka SQLDiva
Only two days left until our super SQLSaturday#59 event.  Hope all is well...

What’s New in SQL Server “Denali” CTP1

Denali. No, not that one...

How many of you have heard that the Community Technology Preview (CTP1) for the next version...

XQuery for the Non-Expert – Terminology

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
It’s time...

A Plug for SQLSaturday #45 in Louisville

My friend Mala is heading up the 2nd annual SQLSaturday in Louisville, KY, being held next year on January 22,...

Announcing the SQLDoctor

Today I’m very proud to announce a FREE SQL Server consulting service from me called
the “SQLDoctor”.

The concept of the SQLDoctor...

Cleaner Code Demos – Speaker Hints

Recently I had the privilege of watching Paul Randal and Kimberly Tripp present (separately) at SQL Server Connections. If you...

Handling Type II Dimension with the MERGE Statement

Microsoft attempted to make our lives easier with the Slowly Changing Dimension task in SSIS.  However, as we all know...