Don’t Pass Null
I’ve been rereading an excellent book called “Clean Code” by Robert C. Martin. This book has some practices that each...
2012-06-08
1,200 reads
Peter Skoglund
A new neat feature in SQL Server 2012 is THROW
In SQL Server 2005 we got the TRY…CATCH construct which was a big help for developers to effectively handle errors...
2012-05-31
3,320 reads
How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)
How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)
One of...
2012-05-31
6,464 reads
Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1 (Republished)
When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...
2012-05-31
3,822 reads
How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server?
One of the most common DBA task is to synchronize data to Development, Testing, and Staging environments. Normally this is...
2012-05-23
15 reads
Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1.
When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...
2012-05-22
5 reads
2010-12-21
3,217 reads
Blogs
Day 2 at PASS Data Community Summit 2024
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
PASS Summit 2024 – Wednesday
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
Taming Database Challenges: Insights from Redgate Keynote
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
Forums
Deduplicating rows by choosing the row with the shortest string
Hello T-SQL experts I have a table containing team codes and descriptions. Unfortunately, many...
Unencrypted connections in Always on Availability Group
Hi, In my Always On Availability environment, I am seeing two encrypt_option values as...
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