SQLSaturday Portugal 2015 – Above & Beyond
At the same day, 4 years ago me & my team were already in the process of organising the very first...
2014-12-17
443 reads
At the same day, 4 years ago me & my team were already in the process of organising the very first...
2014-12-17
443 reads
Welcome to the 2nd blog post in the Azure Columnstore series, as previously mentioned in the Azure Columnstore, part 1...
2014-12-16
662 reads
With today’s announcement on the availability and support of the Columnstore indexes in the Preview version of Azure SQLDatabase, I...
2014-12-12
656 reads
If you are looking for one of the most awesome and most import conferences in Europe, then surely you need...
2014-12-04
438 reads
Continuation from the previous 44 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
I have blogged a couple times (part 29 – “Data Loading for Better...
2014-12-02
367 reads
Continuation from the previous 43 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to the monitoring aspects of the Columnstore Indexes,...
2014-11-23
408 reads
It is official – since a couple of weeks I have become a co-leader of one of the newest Virtual Chapters...
2014-11-20
287 reads
Continuation from the previous 42 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to the Transaction Log behaviour, which might explain...
2014-11-19
430 reads
While on my trip to PASS Summit 2014, I have selected one more book to read on the long flights...
2014-11-17
456 reads
Every autumn one can observe the pilgrimage of almost all Microsoft Data Platform specialists (SQL Server, Excel, Azure Platform) for...
2014-11-16
317 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