SQLSaturday Portugal Porto 2014 Recap
Incredibly as it sounds, it took us 2 years of work to get the 18th of October. It took a...
2014-11-04
199 reads
Incredibly as it sounds, it took us 2 years of work to get the 18th of October. It took a...
2014-11-04
199 reads
I am extremely excited to share that the first event of Porto.Data is all set for the 20th of November...
2014-10-29
142 reads
Continuation from the previous 41 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Important Disclaimer – I have started writing this blog post over 1 months...
2014-10-23
351 reads
Did you ever faced a situation when needing to generate dynamically a SQL Server Reporting Services Report on-demand, at some...
2014-09-22
409 reads
Continuation from the previous 40 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Note: This article is in’s 2nd version, after correcting comments done by...
2014-09-13
241 reads
Continuation from the previous 39 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
It’s time to take a look into the algorithms that Microsoft is...
2014-09-09
312 reads
Este ano (2014) a 3ª edição do “24 Horas de PASS” em Português será realizada nos dias 7 e 8...
2014-09-05
105 reads
A couple of days ago, when I was in Germany – I have received some extremely exciting news that I was...
2014-09-05
139 reads
A couple of days ago, Tillmann has released a new version of his amazing SSIS data source for Google Analytics...
2014-08-27
1,257 reads
Continuation from the previous 38 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
In this post I shall try to discover more interesting information about...
2014-08-26
608 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