Continuation from the previous 80 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Microsoft is doing an amazing job with the every single point release towards SQL Server 2016 RTM. For almost a year, every single month they have…
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…
The registrations for Tuga IT 2016 are finally open: http://tugait2016.eventbrite.com, hurry up cause we are starting to promote it very heavily right now. Last major event we did in Lisbon in 2015 was full by the 1st of April with…
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…