Category: Uncategorized

New blog location

Here is the new blog  – please update those readers. I’m getting settled into working for Microsoft again – it’s basically like drinking from


COUNT(1) vs. COUNT(star)

A follow-up from my previous post. Is COUNT(1) faster than COUNT(*)? No, COUNT(1) is mapped into COUNT(*) early in the QP.  From the logic of


Local-Global Aggregation

I don’t know about you, but groupby is one of my favorite operators.  There are a TON of interesting optimizations that a QP considers when


Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.