Encryption and the Performance DMOs
Ever wonder what you can see in the performance oriented DMOs when stored procedures were encrypted? Me neither. But, I...
2011-01-05
605 reads
My Review of SeV Revolution Jacket
Originally submitted at SCOTTEVEST, Inc.
26 Pockets are perfect for everyday and travel items; includes the TravelSmartSystem?. The SCOTTEVEST revolution began...
2011-01-05
1,651 reads
Who Should Vote for PASS SQLRally Sessions
Adam Machanic (@AdamMachanic) asked on Twitter if people who aren’t planning on attending PASS SQLRally should still vote for sessions...
2011-01-05
814 reads
Can You Dig It? – Find Estimated RowCounts
She can dig it!
D Sharon PruittIt’s the eighth post in the plan cache series. I took a few days off...
2011-01-05
398 reads
Building Reports and Analytics on Dynamics CRM – Lessons (Being) Learned
In concept, designing reports is such a simple thing… you connect to a data source,
write a SQL query, optimize the...
2011-01-05
954 reads
2011-01-05
11 reads
2011-01-05
19 reads
2011-01-05
12 reads
2011-01-05
28 reads
Quick SQL Server Sessions Troubleshooting
Summary
I get lot of queries from DBA’s asking what is the quickest way to figure out issue on SQL Server....
2011-01-05
1,453 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
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