In a bold and decisive move earlier today, the University of Florida has decided to dissolve their computer science education...
2012-04-26 (first published: 2012-04-24)
3,818 reads
Last Thursday I had the pleasure of speaking in Orlando, FL at the OPASS monthly meeting. I spoke on Extending...
2012-04-24
1,142 reads
The overall opinion seems to be that the 22nm Ivy Bridge represents a relatively small boost to CPU performance (typically...
2012-04-23
1,051 reads
2012-04-23
1,240 reads
In my earlier post, I have explained how to move the MSDTC disk to new SAN. In this post we...
2012-04-23
9,488 reads
This is just a quick post to remind folks who are current Microsoft MVPs that Pragmatic Works offers NFR licenses...
2012-04-23
1,099 reads
Pop quiz!
It’s time to true-up with Microsoft, what are your current license counts?Operations needs to schedule maintenance on ServerY, what...
2012-04-23
2,730 reads
Here’s the situation. We’re absolutely falling down as men and professionals. Ladies, feel free to read on and comment, but...
2012-04-27 (first published: 2012-04-23)
2,624 reads
Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a...
2012-04-24 (first published: 2012-04-23)
33,114 reads
When connecting to a server from SSMS using Windows Authentication, you are limited to using only user which you used...
2012-04-23
2,439 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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