Continuation from the previous 79 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Given the number under-the-hood performance & manageability improvements that recent RC versions of SQL Server 2016 have had, I have decided to revisit them and update…
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…