Columnstore changes

Question

Columnstore changes

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
October 6, 2014 at 8:39 pm

#73577

Comments posted to this topic are about the item Columnstore changes
October 7, 2014 at 2:17 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Great question, I didn't know about this feature.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

marsigme SSCrazy Points: 2859 More actions · Answer 2

Got tripped up with this note in the Data Compression article <http://msdn.microsoft.com/en-us/library/cc280449.aspx>.

To add archival compression, use ALTER TABLE (Transact-SQL) or ALTER INDEX (Transact-SQL) with the REBUILD option and DATA COMPRESSION = COLUMNSTORE.

I should have read the examples just below that statement which use the columnstore_archive option.

Michael_Garrison Hall of Fame Points: 3110 More actions · Answer 3

Don't know how I got this right, but definately need to know more about this topic, thanks.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

I love it when I learn new things from the question. Not that I'll get to play with 2014 any time soon, but I still like learning about it. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

TomThomson SSC Guru Points: 104773 More actions · Answer 5

marsigme (10/7/2014)
Got tripped up with this note in the Data Compression article <http://msdn.microsoft.com/en-us/library/cc280449.aspx>.
To add archival compression, use ALTER TABLE (Transact-SQL) or ALTER INDEX (Transact-SQL) with the REBUILD option and DATA COMPRESSION = COLUMNSTORE.
I should have read the examples just below that statement which use the columnstore_archive option.

Or perhaps even read the two bullet points immediately above that statement?

Tom

Kick6Tiger SSCrazy Points: 2380 More actions · Answer 6

Awesome, I learned something new today. Time to call it quits. 😀

Aigle de Guerre!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Ed Wagner (10/7/2014)
I love it when I learn new things from the question.

+1

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Mighty SSCrazy Eights Points: 9063 More actions · Answer 8

TomThomson (10/7/2014)
marsigme (10/7/2014)
Got tripped up with this note in the Data Compression article <http://msdn.microsoft.com/en-us/library/cc280449.aspx>.
To add archival compression, use ALTER TABLE (Transact-SQL) or ALTER INDEX (Transact-SQL) with the REBUILD option and DATA COMPRESSION = COLUMNSTORE.
I should have read the examples just below that statement which use the columnstore_archive option.
Or perhaps even read the two bullet points immediately above that statement?

As said, the bullit points and example are clear. But I guess that marsigme was right in being confused about that bit of text. Seems to be incorrect, or am I missing something?

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 9

akljfhnlaflkj

SSC Guru

Points: 76202

October 8, 2014 at 6:29 am

#1750920

Thanks for the question.

TomThomson SSC Guru Points: 104773 More actions · Answer 10

Mighty (10/7/2014)
TomThomson (10/7/2014)
marsigme (10/7/2014)
Got tripped up with this note in the Data Compression article <http://msdn.microsoft.com/en-us/library/cc280449.aspx>.
To add archival compression, use ALTER TABLE (Transact-SQL) or ALTER INDEX (Transact-SQL) with the REBUILD option and DATA COMPRESSION = COLUMNSTORE.
I should have read the examples just below that statement which use the columnstore_archive option.
Or perhaps even read the two bullet points immediately above that statement?
As said, the bullit points and example are clear. But I guess that marsigme was right in being confused about that bit of text. Seems to be incorrect, or am I missing something?

Yes, it's incorrect - but that's quite common in MS documentation, so watching for self-contradiction instead of relying on one stement and not looking at the rest of teh page when reading BOL is always a good idea. I found out the hard way reading MS doc many years ago, but still regard MS doc as mostly far better than almost any provided by other software suppliers (some of the Borland documentation was as good - Spring and Quattro documentation was better than doc for Excel and word). Of course the indexing in MS technical documentation is either terrible or non-existent and neither google nor bing solves that problem for them - that's a bigger fault than the numerous errors.

Tom

Hany Helmy SSChampion Points: 13921 More actions · Answer 11

Stewart "Arturius" Campbell (10/7/2014)
Koen Verbeeck (10/7/2014)
Great question, I didn't know about this feature.
+1
Learned something new today...:cool:

+1 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant