Using Sparse Columns and Sparse Column Sets

Using Sparse Columns with SELECT ... INTO

Dealing with negative session ids

Hello? Mr. DBA? Have you got a moment?
So there you are, enjoying one of the few quiet moments of your...

BIT Conversions

Contained Databases

What’s been happening in Wayne’s World

Late last year, my life got strange. Well, it’s always been strange, so let’s just say it became stranger than...

I’m speaking at the PASS Summit 2012

The PASS Summit 2012 schedule has been released, and I’m proud to announce that I’ve been selected to present a...

Interview questions

Lately, I’ve been asked by several folks about the interview questions that I use when I interview candidates for SQL...

ORM Tools

ORM tools. They’re great. They’re evil.
In the right hands, used the proper way, they can be a very powerful, very...

Comparing Table Variables with Temporary Tables

This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.