Backup database in CMS
Sometime you know the database name which you want to backup, but you don't know which server it is on....
2012-05-09
1,103 reads
Sometime you know the database name which you want to backup, but you don't know which server it is on....
2012-05-09
1,103 reads
Denali – Day 9: Additional Scalability Features
15,000 Partitions earlier it was 1000For the enterprise system having huge amount of data to...
2012-05-09
492 reads
A compelling feature of the new Data Quality Services in SQL Server 2012 is the ability to apply rules to...
2012-05-09 (first published: 2012-05-04)
3,615 reads
http://www.flickr.com/photos/saygoodie/4548042971/
Hello Dear Reader starting today out in Dallas Texas at the Dallas Convention Center is the Second Annual SQL Rally. ...
2012-05-09
668 reads
Quebec's Shameful, Coercive Language Law‘Je me souviens’ les palmarès Top 20 de la loi 101 sacrée qui nuit à la...
2012-05-09
15,538 reads
It’s one thing to be able to backup a database, it’s another thing to be able to restore it into...
2012-05-09
4,487 reads
This month, Chris Shaw (Blog | @sqlshaw) is leading the charge on the T-SQL Tuesday. This event is basically a blogging...
2012-05-08
996 reads
Denali – Day 8: Startup Parameter
Startup Parameters means you are providing the parameter to sql server at the start of sql...
2012-05-08
752 reads
In the April 2012 Question of the Month, I asked readers to tell me their favorite DBA books. I have...
2012-05-08 (first published: 2012-05-01)
5,332 reads
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these, and how do you deal with them in SQL...
2012-05-08
501 reads
By Chris Yates
I’m thrilled to be covering the Microsoft Keynote: Fuel AI Innovation with Azure Databases on Day...
By James Serra
Many customers ask me about the advantages of moving from Azure Synapse Analytics to...
By Brian Kelley
The last data centric conference I attended was the PASS Summit in 2019. A...
Comments posted to this topic are about the item What's New for the Microsoft...
Comments posted to this topic are about the item 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