Faster
In the human history, there was a huge drive (such an ambiguous meaning here) to get faster.
Maybe within our DNA...
2018-01-19
296 reads
Nico Neugebauer
- Website: http://www.nikoport.com
Jack of ALL Trades
Warning: If during reading this post, you feel like a lot of bells started ringing – I might have written about...
2018-01-18
391 reads
Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)
Continuation from the previous 117 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
As a logical continuation from the blog...
2018-01-05
855 reads
Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)
Continuation from the previous 116 parts, the whole series can be found at http://www.nikoport.com/columnstore/
An important issue I have faced already...
2017-12-29
997 reads
Presentations & Blogging of 2017 in Review
And here comes the 5th time I am reviewing what happened on the presentation an blogging side of my life,...
2017-12-29
597 reads
Columnstore Indexes – part 116 (“Partitioning Specifics”)
Continuation from the previous 115 parts, the whole series can be found at http://www.nikoport.com/columnstore/
After delaying for a couple of years...
2017-12-28
508 reads
Precon at SQLKonferenz 2018
One of my favourite conferences (and so far I was incredibly lucky to have spoken at every edition) is SQLKonferenz,...
2017-12-27
344 reads
Columnstore Indexes – part 115 (“Bulk Load API and Pressure”)
Continuation from the previous 114 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is dedicated to the...
2017-11-08
394 reads
Columnstore Indexes – part 114 (“Machine Learning Services”)
Continuation from the previous 113 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the unsung...
2017-10-29
710 reads
Columnstore Indexes – part 113 (“Row Groups Merging Limitations”)
Continuation from the previous 112 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post serves as the continuation...
2017-09-24
427 reads
Blogs
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Our SQL Server is Slow! What Do I Do First?
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Eliminate a function by writing out the code is now throwing an error
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
SQL Server Migration - Redirecting Old Instance Connections to New AG Listener
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
Question of the Day
A Strange Choice
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