SQLPort in Aveiro
Its not a big secret that Microsoft Data Platform community in Portugal has not stopped its expansion – we are trying...
2016-09-11
437 reads
Its not a big secret that Microsoft Data Platform community in Portugal has not stopped its expansion – we are trying...
2016-09-11
437 reads
I am happy to share that the newest release of the CISL (Columnstore Indexes Script Library) – 1.3.1 is live!
Do...
2016-08-28
608 reads
I am very honoured to share that I have been picked up to speak at the German SQLSaturday in Munich...
2016-08-25
489 reads
To support more and more people jumping to Columnstore INdexes, OH22 have decided to open another public 1-day deep dive...
2016-08-24
418 reads
Continuation from the previous 85 parts, the whole series can be found at http://www.nikoport.com/columnstore/
With the release of SQL Server 2016,...
2016-07-29
973 reads
I am extremely proud to share with everyone the news that the long-awaited and quite overdue release of the CISL...
2016-07-24
448 reads
I am glad to share that finally today we have announced that a workshop for Sysadmins, DBAs & DevOps Engineers – called
SQL...
2016-06-27
470 reads
There is a huge time for suspense for everyone in the Microsoft Data Platform space, whenever its time to submit...
2016-06-25
432 reads
Continuation from the previous 84 parts, the whole series can be found at http://www.nikoport.com/columnstore/
I wanted to write a blog post...
2016-06-21
505 reads
Continuation from the previous 83 parts, the whole series can be found at http://www.nikoport.com/columnstore/
In this blog post I wanted to...
2016-06-20
623 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