Precon at PASS Summit 2017 – Columnstore Indexes: Practical Solutions & Techniques
It is with an incredible joy and gratitude that I am able to share that I will be delivering a...
2017-06-13
539 reads
It is with an incredible joy and gratitude that I am able to share that I will be delivering a...
2017-06-13
539 reads
This blog is a kick-off the series that will be dedicated to the graph databases and engines, being more specifically...
2017-06-03
1,226 reads
Continuation from the previous 105 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
One of the most important and recurring...
2017-05-30
923 reads
Continuation from the previous 104 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
For a very long time I was...
2017-05-27
771 reads
I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog...
2017-04-23
2,115 reads
Continuation from the previous 103 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is a logical continuation...
2017-04-22
555 reads
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have been wanting to write on...
2017-04-05
437 reads
Continuation from the previous 101 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In SQL Server 2014 we have received...
2017-04-03
441 reads
I am glad to announce thatTuga IT 2017 Tickets are finally on sale!
Wait a second, you might think – on sale?...
2017-04-03
343 reads
Continuation from the previous 100 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost will focus on warning you...
2017-04-01
408 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