Prakash will walk you through a centralized process using PowerShell where the key information collected, organized and sent via HTML...
2016-06-02
753 reads
I’m going to be speaking for the downtown Chicago SQL Servers User Group at 5:30pm on June 9th! I plan to...
2016-06-02
452 reads
I was writing a poorly performing UDF the other day and then wanted to replace it with a better performing...
2016-06-07 (first published: 2016-06-02)
1,746 reads
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans...
2016-06-02
356 reads
You want to start working with Azure and the Azure Data Platform, but getting started is not easy. Just knowing...
2016-06-10 (first published: 2016-06-02)
1,522 reads
It’s been about six months now since my career to a sharp right turn. At the request of my kids, I left a decade of consulting for a role...
2016-06-02
23 reads
It’s been about six months now since my career to a sharp right turn. At the request of my kids,...
2016-06-02
377 reads
I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster)...
2016-06-10 (first published: 2016-06-02)
4,641 reads
Come on guys, lets “UP- vote” this suggestion for the actual SQL Server product – even the “Scary DBA” likes the...
2016-06-02
254 reads
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans by right clicking and choosing the “Compare Showplan” option...
2016-06-02
11 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