I have a question that is outside the scope of this tutorial. When I perform a rebuild of the indexes on the database, its size increases, which is really surprising because I was expecting the database size to decrease. On the other hand, the unallocated space decreased. Any explanation, sir? I have been searching for the right answer, but none has given me a reasonable explanation.
What a trick on that column store helper! 😮
Quite a helpful helper!
4:28 It's funny, I had exactly the same idea. I was wondering how Erik was planning to spend 16 minutes to say "just use batch mode".
I probably should have spoken in batch mode.
is columnstore_helper table used in the last query is materialized view or a columnstore index?
It's an empty table with a clustered column store index on it.
I have a question that is outside the scope of this tutorial. When I perform a rebuild of the indexes on the database, its size increases, which is really surprising because I was expecting the database size to decrease. On the other hand, the unallocated space decreased. Any explanation, sir? I have been searching for the right answer, but none has given me a reasonable explanation.
Stop rebuilding indexes. It's a waste of time, unless you're on old spinning disk storage.
@@ErikDarlingData I got you , but you didn't anser my main question it really crucial , could you give me any clue on what's going on ?
@@zahreddinesoualem3213 Because you’ve gotten answers: dba.stackexchange.com/q/344883/32281
@@ErikDarlingData mm so that's is it, thank you so much.