Continuation from the previous 78 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Update: In SQL Server 2016 the Nonclustered Columnstore Indexes are UPDATABLE, and you can do any updates without any troubles, for more please read Columnstore Indexes…
Continuation from the previous 77 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have decided to spend some time exploring the opportunities that Columnstore Indexes offer in the relation of the temporary objects. Temporary objects represent a very…
To support Microsoft with the upcoming release of the SQL Server 2016, OH22 have decided to open another public 2-days deep dive workshop on Columnstore Indexes. This public workshop will take place in Cologne on 10th & 11th of May…
Continuation from the previous 76 parts, the whole series can be found at https://www.nikoport.com/columnstore/ I have written previously about SQL Server Integration Services and their interaction with Columnstore Indexes in Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer…
Continuation from the previous 75 parts, the whole series can be found at https://www.nikoport.com/columnstore/. While playing with SQL Server 2016 CTP 3.2, I have found some interesting feature being mentioned inside the engine. The strange thing was called a compression…