I’m back !
Hello Everyone – its been a while.
I’ve been out of the blogging scene over the last year or so due to...
2012-05-12
660 reads
Blog Posts
New Blog
There areso many DBA in HK but I cannot find any good SQL server related blog or forum, so target...
2012-05-12
217 reads
Slides & Samples for my SQLConnections sessions
As I have announced announced in my sessions at the SQLConnections conferences in
Berchtesgaden/Germany, you can find my session materials (slides...
2012-05-12
795 reads
SQL Treeo – Extended properties or local file – please vote
Hi,
I was trying to solve SQL Treeo’s performance issue on slow connection. This posts is also covers feature request of...
2012-05-12
1,064 reads
SQLRally 2012-Closing Thoughts
It was interesting to watch an event that started 17 months ago with Dallas, Nashville, and Denver submitting applications to...
2012-05-12
1,154 reads
SQLRally 2012-Friday
Started the day early, heading to the Convention Center to be at Starbucks at 6:45 for the networking event I...
2012-05-12
946 reads
Denali — Day 11: SSMS enhancement
Denali — Day 11: SSMS enhancement
SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA...
2012-05-11
665 reads
RedGate SQLSearch & SQL Treeo friendship
Hi,
one of SQL Treeo users developed clever workaround for SQL Treeo SSMS Add-in to be more compatible with RedGate SQL...
2012-05-11
1,176 reads
SQL Rally Wrap Up
Another SQL Rally has wrapped up in Dallas, TX and it was great event. My favorite part about these larger...
2012-05-11
1,473 reads
SQL Saturday #119 – One week to go
One week from today I’ll be boarding a plane for my very first visit to Chicago* (airports not included).
One week...
2012-05-11
720 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