Google IQ Test
Friday (Dec 20, 2013) the Google Doodle was a crossword puzzle. I was curious so I clicked and yes, it...
2013-12-23
681 reads
Friday (Dec 20, 2013) the Google Doodle was a crossword puzzle. I was curious so I clicked and yes, it...
2013-12-23
681 reads
Achieving a certification is less about the actual accomplishment, and how you get there. Read some of Andy Warren's thoughts.
2013-12-23
137 reads
I’m a bit late posting this, but it’s worth a couple minutes to check out the Community Choice awards, might...
2013-12-23
914 reads
Last week I had one of those days when I read something and then heard someone talking about the same...
2013-12-16
890 reads
For those that attended the webcast I did last week for Idera the companion whitepaper is now available for download....
2013-12-11
828 reads
Today I ran through the first tutorial at Code.org. It has 20 very short lessons that use Angry Birds and...
2013-12-11
615 reads
Today at 3 pm EST I’m presenting Surviving The First Week As The New DBA. Some of the topics I’m...
2013-12-05
680 reads
Today we have a guest editorial from Andy Warren. Today Andy talks about his changing role as a DBA and how many tasks he doesn't need to handle anymore.
2013-11-29
210 reads
The Abilene Paradox by Jerry Harvey is not a new book, written in 1988. It’s part of some reading I’m...
2013-11-27
1,318 reads
Today we have a guest editorial from Andy Warren. There are often issues with how we get along with each other at work. Andy asks how you might handle a tough decision over a simple problem.
2013-11-27
167 reads
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
Hello T-SQL experts I have a table containing team codes and descriptions. Unfortunately, many...
Hi, In my Always On Availability environment, I am seeing two encrypt_option values as...
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