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
469 reads
Today, the 3rd of July 2015 marks the 2rd anniversary of my very first Columnstore Indexes blog post in the...
2015-07-05
469 reads
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
841 reads
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,074 reads
I will reveal no big secret that on the night when email notifications of PASS Summit selection are sent, I...
2015-06-28
999 reads
After 2 year of active blogging and almost 60 blog posts (56 + 3 on Azure) we have decided that it...
2015-06-16
462 reads
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
681 reads
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
613 reads
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
958 reads
Welcome to the 3rd blog post in the Azure Columnstore series, this one is dedicated to one very important improvement...
2015-05-24
477 reads
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
463 reads
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers