SQLRally 2012–Thursday
Arrived at the convention center about 7:30, managed to arrive at the right end of the convention center and walked...
2012-05-11
705 reads
Blog Posts
Tech Days 2012 in Kosovo
Another Tech Days Prishtina where I will speak about SQL Server 2012 for IT Pros. After a success event in...
2012-05-11
1,842 reads
Which SELECT * Is Better?
The short answer is, of course, none of them, but testing is the only way to be sure.
I was asked,...
2012-05-11 (first published: 2012-05-07)
5,395 reads
#SQLRally Women in Technology Panel of WIN AND AWESOMENESS
Best. Luncheon. EVAR.
I just finished up moderating this year’s Women in Technology panel here at SQLRally, and it was fantastic. ...
2012-05-10
699 reads
“Query cost (relative to the batch)” <> Query cost relative to batch
OK, so that is quite a contradictory title, but unfortunately it is true. There is a common misconception that the query with...
2012-05-10
2,332 reads
Command line to configure windows firewall for SQL server access
I regularly deploy SQL Server to new Windows Server 2008 hosts and one thing that I find quite a chore...
2012-05-10
3,479 reads
Denali — Day 10: Sequence object
Denali – Day 10: Sequence object
Sequence is an object introduced in Denali, this is similar to ORACLE sequence, earlier sql server...
2012-05-10
1,265 reads
DQS Composite Domains and Value Combinations
As I’ve been working with Data Quality Services over the past few weeks, I’ve spent a lot of time working...
2012-05-10
1,140 reads
DQS Composite Domains and Value Combinations
As I’ve been working with Data Quality Services over the past few weeks, I’ve spent a lot of time working...
2012-05-10
774 reads
Getting Inspired with SQL Someday
Recently, I caught my during a kickoff with a new client saying, “Hello I am John, and I love SQL....
2012-05-10
489 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