Columnstore Indexes – part 78 (“Temporary Objects”)
Continuation from the previous 77 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to spend some time...
2016-03-05
504 reads
Continuation from the previous 77 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to spend some time...
2016-03-05
504 reads
To support Microsoft with the upcoming release of the SQL Server 2016, OH22 have decided to open another public 2-days...
2016-02-26
884 reads
Continuation from the previous 76 parts, the whole series can be found at http://www.nikoport.com/columnstore/
I have written previously about SQL Server...
2016-02-23
690 reads
Continuation from the previous 75 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
While playing with SQL Server 2016 CTP...
2016-02-04
792 reads
After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post...
2016-01-24
638 reads
Yesterday, on the 13th of January 2016, my blog has reached it’s 10th anniversary. It all started precisely 10 years...
2016-01-14
444 reads
After a very long waiting period, I have finally released the initial version of my Columnstore Maintenance solution for SQL...
2016-01-11
401 reads
Sometimes one receives amazing gifts at the most unexpected moment. I was beyond thrilled to find out that I was...
2015-12-30
833 reads
Another year is coming to an end and I am doing a review of which goals I have managed to...
2015-12-27
766 reads
Continuation from the previous 74 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post focuses on one of...
2015-12-26
532 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
i have huge table with lot of data and is also wide. i took...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers