Continuation from the previous 111 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the Server...
2017-09-20 (first published: 2017-09-14)
1,717 reads
I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released.
The biggest...
2017-09-04
348 reads
Continuation from the previous 110 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
The topic of the Segment Elimination (aka...
2017-08-30
694 reads
Competitive Sports is one of the incredible miracles to me and I love them greatly. I can watch almost any...
2017-08-29
292 reads
Continuation from the previous 109 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In this blog post I wanted to...
2017-08-27
511 reads
Continuation from the previous 108 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Do you remember one of the major...
2017-08-16 (first published: 2017-07-30)
1,594 reads
T-SQL Tuesday #93
I decided to join the T-SQL Tuesday blog series that Kendra Little is leading this month, on the...
2017-08-08
565 reads
Continuation from the previous 107 parts, the whole series can be found at http://www.nikoport.com/columnstore/
As we are approaching the RTM (release...
2017-07-29
847 reads
Continuation from the previous 106 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I would like to thank Sunil Agarwal...
2017-06-25
694 reads
I am glad to share that I will be speaking at 24 Hours of PASS – PASS Summit 2017 Preview that...
2017-06-24
666 reads
When Covid took out the PASS organization, I had someone say to me, “Well,...
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
My report has been working fine. Now, when I run the report, the Location...
I have a server set up as publisher/distributor and another as subscriber to a...
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers