Thanks for joining Anthony Martin (@SQLMartini) and I at the Boston BI User Group Meeting in October. During the session,...
2015-10-28 (first published: 2015-10-20)
2,629 reads
There is a particularly irritating and persistent belief that indexes (usually it’s the clustered that gets picked on) are always...
2015-10-26 (first published: 2015-10-20)
2,837 reads
Next week at the PASS Summit I’ll be presenting a session called Statistics for the New Data Pro.
You can read...
2015-10-20
393 reads
It’s a week before the Networking Dinner at the PASS Summit. Andy Warren and I are hosting the event next...
2015-10-20
502 reads
It’s a week before the Networking Dinner at the PASS Summit. Andy Warren and I are hosting the event next...
2015-10-20
539 reads
What is connection pooling? Lets start with a definition from MSDN.
Connecting to a data source can be time consuming. To...
2015-10-27 (first published: 2015-10-20)
5,233 reads
In this article I will be taking you into the world of the pair_matching target. The pair_matching target should connote that this target works on matching like events into...
2015-10-20
13 reads
In the last article I showed how to discover all of the settings that are available to a particular Target....
2015-10-20
942 reads
[2015-Oct-20] A sourcing system failed to return correct results (returned value was a very high figure with double digit number...
2015-10-26 (first published: 2015-10-20)
2,289 reads
What is connection pooling? Lets start with a definition from MSDN. Connecting to a data source can be time consuming....
2015-10-20
133 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