Wait a minute, CLUSTERED COLUMNSTORE indexes are not ordered?

Just to reiterate what's in the title of this post, what I mean is that the CLUSTERED COLUMNSTORE indexes are not ordered, while NONCLUSTERED COLUMNSTORE created indexes are on...

..And The New Adventure Has Begun

I am so happy to announce that I have joined the team at Fortified Data. I have just completed my first week (well, four days) and I feel like...

SQLSat Baton Rouge 2023!

Looking forward to #jambalaya at #SQLSatBR on July 29! Register today: sqlsatbr.comI hope to see as many people as possible that weekend, I'll be there at the Friday night...

A New Word: Ozurie

Ozurie – feeling torn between the life you want and the life you have. I think many people feel ozurie often. I certainly had a lot of this in...

Notes from SQLSaturday South Florida 2023

Quick notes on the event this year: Overall a good event and now I have a few months until SQLSaturday in Orlando in October.

Statistics and the Ascending Key Problem

I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly...

Volunteering at Work: Teaching Others

I give a few talks on career topics, and one of these is Branding Yourself for a Dream Job. In the talk, I sometimes tell a story in the...

db_ddladmin Jr.

A while back I talked about the fact that you can grant someone CREATE PROCEDURE and ALTER on a schema ... Continue reading

Tracking the Inaccurate Cardinality Estimates

Tracking the Inaccurate Cardinality Estimates

When it comes to query performance, lately the Cardinality Estimates seems to have been a hot topic with each new release  of SQL...

Microsoft Fabric Overview

First, thank you to Guy in a Cube for a great licensing/cost video. My company is exploring what data warehousing technology to use in Azure. I needed to learn...