Denali – Day 4: Editions & Licensing
Denali – Day 4: Editions & Licensing
Editions:
Here is a brief edition summary of Editions available for all sql server from 2005 to...
2012-05-04
606 reads
Blog Posts
DQS Domain Validation Rules
A compelling feature of the new Data Quality Services in SQL Server 2012 is the ability to apply rules to...
2012-05-04
737 reads
Living a Dream
It was a little over a year ago that I stood on stage at the Rocky Mountain Tech Trifecta and...
2012-05-04
1,211 reads
Slowing Changing Dimension (SCD) demystified – Part 2
In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type...
2012-05-04
740 reads
SQL Saturday Houston Recap
Last month I made the trip with some other Dallas-area speakers down to Houston’s second annual SQL Saturday event. This...
2012-05-04
583 reads
SQLRally at Starbucks Networking Event
Craig Purnell and I are hosting an informal networking event at SQLRally this year on Friday May 11th from 7-8:30...
2012-05-04 (first published: 2012-04-12)
1,716 reads
Changing Priorities
If you’ve been following this blog for a while, you have probably noticed that the content here has been a...
2012-05-03
707 reads
Content is King: Great (paraphrased) advice from TheOatmeal.com
TheOatmeal.com has provided the absolute best counsel regarding creativity vs marketing. The comic I’m talking about is entitled “How to get...
2012-05-03
840 reads
Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration
Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration
I know this should be first or second blog post when...
2012-05-03
875 reads
Eight Words
I remember a lot of things about that day. It was July in Texas, which is to say, it was...
2012-05-03 (first published: 2012-05-02)
2,548 reads
Blogs
AI Innovation in Microsoft Keynote
By Chris Yates
I’m thrilled to be covering the Microsoft Keynote: Fuel AI Innovation with Azure Databases on Day...
Benefits of Migrating from Azure Synapse Analytics to Microsoft Fabric
By James Serra
Many customers ask me about the advantages of moving from Azure Synapse Analytics to...
PASS Summit 2024 – A Very Different World
By Brian Kelley
The last data centric conference I attended was the PASS Summit in 2019. A...
Forums
What's New for the Microsoft Data Platform
Comments posted to this topic are about the item What's New for the Microsoft...
Using Outer Joins
Comments posted to this topic are about the item Using Outer Joins
Question of the Day
Using Outer Joins
I have this data in a SQL Server 2019 database:
Customer table CustomerID CustomerName 1 Steve 2 Andy 3 Brian 4 Allen 5 Devin 6 Sally OrderHeader table OrderID CustomerID OrderDate 1 1 2024-02-01 2 1 2024-03-01 3 3 2024-04-01 4 4 2024-05-01 6 4 2024-05-01 7 3 2024-06-07 8 2 2024-04-07I want a list of all customers and their order counts for a period of time, including zero orders. If I run this query, how many rows are returned?
SELECT c.CustomerName, COUNT(oh.OrderID) FROM dbo.Customer AS c LEFT JOIN dbo.OrderHeader AS oh ON oh.CustomerID = c.CustomerID WHERE oh.Orderdate > '2024/04/01' GROUP BY c.CustomerNameSee possible answers