Generate restore script automatically by backup history table
I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select...
2012-04-30
6,885 reads
Blog Posts
Less Energy through Better Design
When I attended SQL Saturday #131 at the Chandler Gilbert Community College, I was struck by a few design elements...
2012-04-30
1,993 reads
Locked out of SQL Server.
This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql...
2012-04-30
2,613 reads
SQL Saturday #131 Recap
This past weekend I attended a SQL Saturday in the desert. SQL Saturday #131 was held in Phoenix, AZ
It’s April,...
2012-04-30
1,915 reads
SQL Server – Four-part object names
Generally it is considered good practice using two-part names for objects. It make the code more readable and avoids confusion...
2012-04-30
3,126 reads
SQL Server 2008 Diagnostic Information Queries (May 2012)
Since tomorrow is May 1, I think it is time to publish the latest set of SQL Server 2008 Diagnostic...
2012-04-30
1,933 reads
SQL Server 2012: Biggest Little Core-house
You sure do got a 'purty motherboard...
Now that SQL Server 2012 is generally available to the public, many companies are...
2012-04-30
2,965 reads
SSAS File System Error
I received this error the other day when trying to process a particular SSAS cube:
Error 18 File system error: The...
2012-04-30
2,891 reads
There is awesomeness to be had at #SQLRally
Two days of precons.
60 regular sessions over two days.
The now-famous Women in Technology luncheon.
Open access to Microsoft Customer Service and...
2012-04-30
1,499 reads
Updated Thoughts on Antivirus on SQL Servers
I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't...
2012-04-30 (first published: 2012-04-24)
5,824 reads
Blogs
AI Innovation in Microsoft Keynote
By Chris Yates
I’m thrilled to be covering the Microsoft Keynote: Fuel AI Innovation with Azure Databases on Day...
Benefits of Migrating from Azure Synapse Analytics to Microsoft Fabric
By James Serra
Many customers ask me about the advantages of moving from Azure Synapse Analytics to...
PASS Summit 2024 – A Very Different World
By Brian Kelley
The last data centric conference I attended was the PASS Summit in 2019. A...
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