With SQLPort approaching it’s 6th birthday (21st of April), I have to admit that the works on the user group have already started around 2 months before that date. The moment when the SQLPort was announced at the last TechDays…
Columnstore Indexes – part 81 (“Adding Columnstore Index to InMemory Tables”)
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…
Columnstore Indexes – part 80 (“Local Aggregation”)
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…
Tuga IT 2016 – Registrations are open
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…
Columnstore Indexes – part 79 (“Loading Data into Non-Updatable Nonclustered Columnstore”)
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…