columnstore Archives | Erik Darling Data

Columnstore Loading on Eight Socket Servers

Posted on August 31, 2020 by Joe Obbish

I had a brief opportunity to do SQL Server workload testing on an eight socket server. It didn’t go well.

Sockets

I’ll give an extremely brief introduction to NUMA and sockets because I have a bit more free time these …

The Trillion Row Operator

Posted on August 12, 2020August 12, 2020 by Joe Obbish

SQL Server friend and excellent webmaster Mr. Erik C. Darling showed me a query plan gone wrong:

48 billion rows for a single operator is certainly a large number for most workloads. I ended up completely missing the point and …

SQL Server 2019 Disappointment: sp_estimate_data_compression_savings

Posted on May 7, 2020April 20, 2020 by Erik Darling

Missed It The First Time

This is documented, but I know a lot of people are allergic to documentation, whether it’s writing or reading.

In SQL Server 2019:

Exciting stuff: In memory tempdb!
Exciting stuff: sp_estimate_data_compression_savings can evaluate columnstore

…

Paging Dr Column Store

Posted on January 6, 2020July 7, 2020 by Erik Darling

And Cough

…

TABLOCK Isn’t Always Better

Posted on November 20, 2019July 7, 2020 by Erik Darling

Utility

There are a lot of good reasons to use tablock on your inserts, as long as you can handle the reduced concurrency of a table level lock.

You may get minimal logging here, here. And you may …

No Column Store Indexes With In-Memory Tempdb? No Problem!

Posted on November 19, 2019November 6, 2019 by Erik Darling

Old Habits

Let’s say you’re on SQL Server 2019. No, seriously. It’s been out for a couple weeks now.

You could be.

I say that you could be because you’re the kind of brave person who tries new things and …

Stack Overflow Demo Database Column Store Edition: Helpful Links

Posted on November 15, 2019November 6, 2019 by Erik Darling

Sniff

If you’re starting from scratch with column store, here are some links that’ll help you get a better understanding of how they work, and what they’re good for, start here.

For some background information on column store indexes, see …

Stack Overflow Demo Database Column Store Edition: Exploring Relationships

Posted on November 14, 2019November 6, 2019 by Erik Darling

Special Relativity

To get you started exploring the Stack Overflow column store database, here are some queries that show how tables are related.

The two main relationships are User Id, and Post Id.

User Id

/*User Id*/
SELECT COUNT_BIG(*) AS

…

Stuff I Learned In Joe Obbish’s Precon On Column Store

Posted on October 23, 2019July 7, 2020 by Erik Darling

Joy Of Joys

Speaking daily with Joe is one of the best choices I’ve ever made. Not only do I regularly learn things about SQL Server that I would probably not run into, but he’s quite a character. That’s why …

A Bug With OBJECTPROPERTYEX And Column Store Indexes

Posted on September 16, 2019September 5, 2019 by Erik Darling

No, Not That Bug

There’s a known bug with partitioned tables, but this is different. This one is with rows in the delta store.

Here’s a quick repro:

USE tempdb;

DROP TABLE IF EXISTS dbo.busted;

CREATE TABLE dbo.busted (

…