Columnstore would work by tokenizing and limiting the repetition of values. A simple example is gender. Say we have 3 values (M, F, Other). If we had these stored as...

Can you please put it in your own words - how do you see it?

Frederico, can you please describe the mechanism a columnstore index uses to compress the data?

I would still consider them good for history/audit tables as these aren't queried often - saving on space is what would really be important here, not speed of processing...

Columnstore index is a workaround for denormalised data storage.

follow basic data normalisation rules and there won’t be any place for columnstore indexes in your database.

not to mention - you’re gonna...

Brrr...

Can't believe I see this kind of coding in the present time.

SELECT
T0.CardCode as CardCode,
T0.CardName as CardName,
ISNULL(T1.Balance,0) as Balance 
FROM Ocrd T0
LEFT JOIN (
SELECT T10.ShortName, 
Sum(CASE WHEN T11.TransId...

I can respect somebody being stubborn, probably because I'm a bit stubborn myself.

🙂

But having columns like that is a very bad idea, in general, and this particular case is not...

I figured it was something besides compatibility level, but I just could not see it.

Lynn's solution is able to meet my needs with pulling the view out of the...

It's not about DB compatibility level.

Run the UPDATE repeatedly - 10, 20 times on the same level.

You'll get any number of rows updated - between zero and 5 (the biggest...

OMG.

i finally went to the bottom of this page and clicked “take a peek into our servers”.

and what do I see?

One of the “top” queries:

SELECT DISTINCT wp_posts.* , wp_postmeta.meta_value FROM...

Ok, I’m officially envious.

how well thongs must be organised at your place, if this kind of events come as a surprise for you?

i can hardly remember when things went as...

I guess my wife would say I need to do...

There is an old term "above the fold" - what you can see at the first page of a newspaper without unfolding it.

The topics, photos, headlines placed above the fold...

It's better  it to update such "key" values as user name in this example.

old use name must stay in the database, in case some historical records have to be audited.

external...

Is it what you're looking for?

https://simonmcauliffe.com/technology/tde/