15 years of experience with Identity columns

An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...

A Sherlockian Question Of the Day & Why I’m Writing Questions

If you haven’t noticed by now I’ve been writing quite a few questions of the day for SQLServerCentral. It started,...

How Does Disabling an Index Affect the Index Usage DMV Counters

A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the...

Miscellaneous Notes on the PASS NomCom and General Election

Interesting day yesterday. A spirited discussion on Twitter, a challenging post from candidate Mark Broadbent, and a couple good threads...

Upcoming SQL Saturdays & Precons

This coming weekend is the SQL Saturday #307 in Iowa City, Iowa. I am really looking forward to attending this event...

Using PIVOT function without a CTE

There are some cases when you need to use a PIVOT function in SQL but you cannot use a CTE....

Access Granted or Not? Question of the Day

Access Granted or Not? is my latest Question Of The Day and I think it represents a pretty good troubleshooting...

Attaching All Databases with PowerShell–Attaching Missing Databases

I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...

Busy Busy Weeks, Finally Some Good News! SQL 2008 / 2008 R2 Will Get Their Final Service Pack!

We will actually be getting our final Service Pack! 

The information can be found here. You may still want extended support...

Columnstore Memory Grant Issue

In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive...