Business Intelligence

Conteúdo relacionado à área de Business Intelligence

Atualização Cumulativa 3 para SQL Server 2016 SP1

A Microsoft disponibilizou para download nesta semana a Atualização Cumulativa 3 para SQL Server 2016 SP1. O primeiro Service Pack do SQL Server 2016 foi lançado pela empresa em 17 de novembro de 2016 e está disponível para download aqui. SQL Server 2016 O SQL Server 2016 traz recursos críticos inovadores com desempenho em memória … Continue Lendo "Atualização Cumulativa 3 para SQL Server 2016 SP1"

Microsoft disponibiliza o SQL Server 2017 CTP 2.0

A Microsoft anunciou nesta semana em seu blog a disponibilidade no TechNet Evaluation Center do SQL Server 2017 CTP 2.0, a versão de testes pública mais recente do novo SQL Server. Performance inigualável Faça consultas até 100 vezes mais rápido do que o disco com columnstore in-memory e transações até 30 vezes mais rápido com … Continue Lendo "Microsoft disponibiliza o SQL Server 2017 CTP 2.0"

Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)

Continuation from the previous 103 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post is a logical continuation of the blog post that I have published in December 2016 – Columnstore Indexes – part 93 (“Batch Mode…

Columnstore Indexes – part 103 (“Partitioning 2016 vs Partitioning 2014”)

Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I have been wanting to write on this topic for quite some time, but with all the exciting themes that I have on my todo list…

Columnstore Indexes – part 102 (“CCI with Secondary Rowstore Indexes on SQL 2014”)

Continuation from the previous 101 parts, the whole series can be found at http://www.nikoport.com/columnstore/. In SQL Server 2014 we have received a possibility to update the Columnstore Index directly with an addition of the Clustered Columnstore Index. This addition had…

Columnstore Indexes – part 101 (“Estimated? Similar! Similar How?”)

Continuation from the previous 100 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blogpost will focus on warning you against considering just 1 aspect when analysing Columnstore Indexes performance, while coming back to the good old theme of…

Columnstore Indexes – part 100 (“Identity”)

Continuation from the previous 99 parts, the whole series can be found at http://www.nikoport.com/columnstore/. In Data Warehousing one will not be shocked to find a number of tables using IDENTITY property on a column, a lot of times to create…

Columnstore Indexes – part 99 (“Merge”)

Continuation from the previous 98 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post is focused on the MERGE statement for the Columnstore Indexes, or as I call it – the worst enemy of the Columnstore Indexes.…

Columnstore Indexes – part 98 (“Null Expressions & String Aggregates”)

Continuation from the previous 97 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Continuing with the spirit of the previous blog post on the string data type limitations I decided to add a couple more items that are showing…

Columnstore Indexes – part 97 (“Working with Strings”)

Continuation from the previous 96 parts, the whole series can be found at http://www.nikoport.com/columnstore/. After many years of using & fighting the String data type in Columnstore Indexes, I have finally decided to write a blog post that is dedicated…
Go to Top