Thanksgiving Bloopers

I'm slow to get this out, but I finally rendered the raw bloopers from November. Enjoy.

Part 1

Part 2

Part 3

The iPad, So Far

In the front yard, using the iPad & SQL Monitor
After a great deal of unseemly begging, I managed to acquire an...

Tis the Season

This month has been quite the month for change in my family.  The changes that we are experiencing did not end with the birth of our baby girl two...

Tis the Season

This month has been quite the month for change in my family.  The changes that we are experiencing did not...

Two Digit Year Cutoff

I couldn't sleep this morning and decided to wake up and catch up on my email when I noticed a video link...

Viewing RING_BUFFER_OOM Errors

Onion Ring Buffer?
A client asked a co-worker to take a look at a query for reviewing  RING_BUFFER_OOM messages in sys.dm_os_ring_buffers. ...

Busy Week

It’s going to be a busy week for me. At last count, I had over 40 comments for my T-SQL...

Can You Dig It? – Missing Indexes

She can dig it!
D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...

December PASSMN Meeting Today

Getting SQL Server for
Christmas! Happy holidays and seasons greetings! 
Don’t forget, PASSMN meeting is today.  As I’ve said before,...

Do IF statements cause recompiles?

I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...