10 must follow blogs that might not be in your list
There are few memes going around in the SQL world. Probably the most popular of them is TSQL Tuesday (#tsql2sday)....
2012-04-16
1,750 reads
Blog Posts
Apply SP1 to SQL Server 2008R2 on active/active cluster.
While researching the steps required to service pack SQL Server on an active active cluster I came across a lot...
2012-04-16
903 reads
Creating a User without a Login – Contained Databases
In SQL Server 2012, we have a new feature: partially contained databases. In a previous post, I showed how to...
2012-04-16
12,419 reads
How to use Report Builder 3.0
I did a webinar during the 12 days of 2012 on how to use Report Builder 3.0. In this webinar...
2012-04-16
1,442 reads
Instant File Initialization Security Risk
A while ago I blogged about instant file initialization. A colleague of mine pointed out that there is a small...
2012-04-16
899 reads
PowerShell and T-SQL: Implementing UNION, INTERSECT, and EXCEPT
I’ve been thoroughly enjoying my experience this year with the Scripting Games. This is the first year I've competed and...
2012-04-16 (first published: 2012-04-12)
6,667 reads
Script to analyse space usage by your Service Broker
I believe that service broker is one of the best features from SQL server 2005, well along with the xml...
2012-04-16
2,337 reads
SQL Saturday #111 Atlanta recap and links and stuff and things….
I particularly enjoy SQL Saturdays in Atlanta for a few reasons. It gives me an excellent excuse to come out...
2012-04-16
695 reads
SQL Saturday 136 – Wellington. Speakers review.
TweetG’day,
On Saturday 16th April 2012, I attended SQL Saturday #136 in Wellington, New Zealand.
The day was run by Dave Curlewis [Blog...
2012-04-16
1,098 reads
SQLSaturday #151 Announced–Orlando!
Just got the email, Orlando will be having its sixth annual SQLSaturday this year on September 29th, 2012, at Seminole...
2012-04-16
565 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect
How can you achieve good enough without compromising the process/product? In the world of...
How to Convert FileTime to DateTime
By Patrick
One of my customers recently wanted to rename each of the SQL audit files...
The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should...
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