Como já é tradição neste época de ano, estou muito contente para anunciar a segunda edição do “24 Horas de PASS” completamente em Português que será realizada nos dia 13 e 14 de Novembro 2013. A iniciar pelas 11:00 de…
PASS Summit 2013
The anual PASS Summit, which is the best SQL Server event in the galaxy was held between 14th and 18th of October, in Charlotte, North Carolina. This year the biggest difference was definitely in the location, since for the first…
Leaving PASS HQ
The news are out and as of yesterday – I will be leaving PASS HQ on the 25th of October of 2013. It was a great experience for me, but it is time to go. Like in every job, like…
Clustered Columnstore Indexes – part 20 (“TempDB Spills – when memory is not enough”)
Continuation from the previous 19 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post is dedicated to the situations when available memory to the process ( execution plan ) will not be able to satisfy the context execution environment and one or more…
Clustered Columnstore Indexes – part 19 (“Batch Mode 2012 Limitations … Updated!”)
Continuation from the previous 18 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post is dedicated to the limitations of the Batch Mode of the Columnstore Indexes in SQL Server 2012 and the improvements which are already present in SQL Server 2014 CTP1.…