The CHECK constraints unlike behaviours
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...
2016-06-13
18 reads
The CHECK constraints unlike behaviours
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...
2016-06-13
278 reads
Implementing Fuzzy Sets in SQL Server, Part 0: The Buzz About Fuzz
By Steve Bolton
…………I originally planned to post a long-delayed series titled Information Measurement with SQL Server next, in which I’d...
2016-06-20 (first published: 2016-06-13)
2,414 reads
Finding File Growths with Extended Events
I give a SQLSaturday session called "Introduction to Extended Events" and at a recent presentation I had a pair of...
2016-06-17 (first published: 2016-06-13)
6,495 reads
Monday Morning SQL Break – June 13, 2016
Usually on my Monday posts, I include a pretty bland cookie cutter header. Nothing to extravagant, just an introduction. It’s...
2016-06-13
774 reads
Choosing the Right SQL Server Edition
Post #6 of #entrylevel #iwanttohelp in support of Tim Ford’s (b|t) beginner’s initiative.
If you’re just getting started with SQL Server,...
2016-06-13
1,253 reads
Learning Azure Data Platform
One of the issues I’ve seen with Azure is that is changes rapidly. It’s cool in that new things get...
2016-06-13
531 reads
The CHECK constraints unlike behaviours
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...
2016-06-13
329 reads
Row-level Security Just Got Better: Passing Report Credentials to Analysis Services in SQL Server 2016
A new ground-breaking feature in SQL Server 2016 allows report user context to be passed through shared data sources, enabling...
2016-06-16 (first published: 2016-06-13)
1,498 reads
SQL Community n Speaking Assignments
Dear All,
It has been a while since I became less active on this blog. Reason for the same being that,...
2016-06-12
404 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