Continuation from the previous 9 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Now it is time to see the actual compression in action, and so for the beginnings I have downloaded Contoso BI database. This is a good enough database to start playing…
Clustered Columnstore Indexes – part 9 (“SQL Server 2014 CTP1 Observations”)
Continuation from the previous 8 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ I have been playing with the internals of the master database of the SQL Server 2014 CTP1 and hence have discovered a couple of interesting things: – While Replication will not…
Clustered Columnstore Indexes – part 8 (“Locking”)
Continuation from the previous 7 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ In this part we shall play with Locking :) Lets setup our table with all defaults and with a Clustered Columnstore Index: IF OBJECT_ID(‘dbo.CCTest’, ‘U’) IS NOT NULL drop table dbo.CCTest;…
Clustered Columnstore Indexes – part 7 (“Transaction Isolation”)
Continuation from the previous 6 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ In this part we shall be dedicating to the Transactional support for Clustered Columnstore Indexes: Isolation Levels: As I have already mentioned in part 2, Isolation support for Clustered Columnstore Indexes…
Clustered Columnstore Indexes – part 6 (“Observing the behavior”)
Continuation from the previous 5 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ In the previous 5 parts of this blog series I have described how some of the things related to Clustered Columnstore Indexes are functioning, and so in this part I wanted…