Topics

▼
Wednesday, August 26, 2026

You Have a Columnstore Index. But Is Your Data Actually in Columnstore?

›
MSSQLTips ran a good piece this month on when a columnstore index does not make sense -- the case where your queries pull back too m...
Wednesday, August 19, 2026

CU8 Is Here. Your Monitoring Query Is the New Casualty.

›
Cumulative Update 8 for SQL Server 2025 landed on August 13th, build 17.0.4075.5. Eleven fixes. Three known issues. One of those know...
Wednesday, August 12, 2026

Brent and I Wrote About Temp Tables Yesterday. We Found Different Things.

›
Brent Ozar and I both published temp table posts yesterday for T-SQL Tuesday #201 . We both built a lab. We both argued from logical ...
Tuesday, August 11, 2026

Temp Tables: Foe When It's a Reflex, Friend When It's a Decision

›
This month Jeff Taylor is hosting T-SQL Tuesday #201 , and he came out swinging. His position, in his words: "reaching for a...
4 comments:
Monday, August 3, 2026

DOP Feedback, Part 2 — Even Microsoft’s Demo Didn't Get Me There

›
In my DOP Feedback post last month , I shared something very frustrating. I had all the documented prerequisites for DOP Feedback in ...
2 comments:
Wednesday, July 22, 2026

SSRS Is Dead. Here's The Move to PBIRS.

›
A few months back I wrote SSIS Is Not Dead. Yet. , opening with the line 'SSRS is gone'. Today it's time to give SSRS the...
Tuesday, July 21, 2026

How Hard Is It to Trigger SQL Server 2025's DOP Feedback?

›
When Microsoft introduced Degree of Parallelism (DOP) Feedback for SQL Server , I immediately wanted to see it in action. The idea i...
1 comment: