Continuation from the previous 4 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Now it is time to take a detailed look of the upcoming and less documented attractions related to Clustered Columnstore Indexes: Important Note: I am referring to the CTP1 of the…
Clustered Columnstore Indexes – part 4 (“Basic T-SQL”)
Continuation from the previous 3 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Lets take a look at the concrete T-SQL syntax of the Clustered Columnstore Indexes: Create Clustered Columnstore Index [name] on [table]; The only difference to the Nonclustered Indexes is basically the…
Columnstore Indexes – part 3 (“More Internals”)
This is the third in the series dedicated to the Clustered Columnstore Indexes. The first part can be found here – https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/, while the whole series can be found at https://www.nikoport.com/columnstore/ This blogpost is continuing focusing on the part of…
Clustered Columnstore Indexes – part 2 (“Internals”)
This is the second in the series dedicated to the Clustered Columnstore Indexes. The first part can be found here – https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Lets try to explore about some more complicated things, which will be daily stuff for those who will…
Columnstore Indexes – part 1 (“Intro”)
This is a first blog post in a very large series of posts about the CLustered Columnstore Indexes: Columnstore Indexes – part 2 (“Internals”) Columnstore Indexes – part 3 (“More Internals”) Columnstore Indexes – part 4 (“Basic T-SQL”) Columnstore Indexes…