The Importance of Regular Blogging
Between my old website, which I started back in 2007 (which has since disappeared) and my blog, which I switched...
2012-05-28
1,027 reads
Blog Posts
Unsubscribing
One of the things I’ve been doing lately is pruning (again) the number of newsletter type emails I get. Some...
2012-05-28
833 reads
Denali – Day 27: System Center Advisor (aka ‘Atlanta’)
Denali – Day 27: System Center Advisor (aka ‘Atlanta’) As Microsoft is working more on Cloud base system, on that basis...
2012-05-27
1,001 reads
Denali – Day 26: Tool: Power View- Reporting Power View (Aka Crescent)
Denali – Day 26: Tool: Power View -Reporting Power View (Aka Crescent) If you are good with: Xls Pivot table Power...
2012-05-26
1,062 reads
New built-in functions in SQL Server 2012
Introduction:
Microsoft SQL Server 2012 Release Candidate 0 introduces 14 new built-in functions. These functions will make the migration path for...
2012-05-26
25,371 reads
SQL Saturday #132 Pensacola and Wheeling, WV PASS UG
I have 2 upcoming speaker opportunities in June and am very excited about presenting this material.
June 9th is in...
2012-05-26
753 reads
Backup duration statistics
Here is a simple query which can list backup duration statistics for all database, including the max, min, avg of...
2012-05-25
2,738 reads
Building a Presentation Map
This idea came up during a critique of a presentation. I may have re-invented (or re-labeled) something that is already...
2012-05-25
617 reads
Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)
Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)
MDS and Best Practice Analyzer new features were introduced in sql...
2012-05-25
697 reads
Exercise in the Margins
This article about exercising when you can is really interesting. It contains a number of hints about exercising and fitting...
2012-05-25
1,168 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