Columnstore Indexes – part 58 (“String Predicate Pushdown”)
Continuation from the previous 57 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have previously blogged on the predicate...
2015-07-05
838 reads
Niko's blog
Announcing Columnstore Indexes Script Library
Today, the 3rd of July 2015 marks the 2rd anniversary of my very first Columnstore Indexes blog post in the...
2015-07-05
460 reads
Columnstore Indexes – part 57 (“Segment Alignment Maintenance”)
Continuation from the previous 56 parts, the whole series can be found at http://www.nikoport.com/columnstore/
In this post I want to focus...
2015-06-28
1,068 reads
Speaking at PASS Summit 2015
I will reveal no big secret that on the night when email notifications of PASS Summit selection are sent, I...
2015-06-28
990 reads
Announcing Workshops – Columnstore Deep Dive
After 2 year of active blogging and almost 60 blog posts (56 + 3 on Azure) we have decided that it...
2015-06-16
448 reads
Columnstore Indexes – part 56 (“New DMV’s in SQL Server 2016”)
Continuation from the previous 55 parts, the whole series can be found at http://www.nikoport.com/columnstore/
Before starting to dive into the specific...
2015-06-15
678 reads
Columnstore Indexes – part 55 (“New Architecture Elements in SQL Server 2016”)
Continuation from the previous 54 parts, the whole series can be found at http://www.nikoport.com/columnstore/
The architectural changes in the upcoming SQL...
2015-06-08
608 reads
Columnstore Indexes – part 54 (“Thoughts on upcoming improvements in SQL Server 2016”)
Continuation from the previous 53 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This is a not very deep technical...
2015-05-27
950 reads
Azure Columnstore, part 3 – Modern Segment Elimination and Set Statistics IO
Welcome to the 3rd blog post in the Azure Columnstore series, this one is dedicated to one very important improvement...
2015-05-24
471 reads
Clustered Columnstore Indexes – part 53 (“What’s new for Columnstore in SQL Server 2014 SP1”)
Continuation from the previous 52 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This is a very small blog post...
2015-05-22
460 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers