Presenting at SQLSaturday Tampa
The schedule just went up, I’ll be presenting PCI for the SQL DBA this year. Looking forward to visiting Tampa...
2014-02-05
497 reads
The schedule just went up, I’ll be presenting PCI for the SQL DBA this year. Looking forward to visiting Tampa...
2014-02-05
497 reads
Strange that I’ve never had/wanted to do this before, helping someone do it today and renaming it causes everything to...
2014-02-03
1,341 reads
Ran across this poster of movie quotes – $20 will get you a copy. Why might you be interested? The visualizations...
2014-01-31
1,221 reads
Yesterday Kendal Van Dyke posted a file to Skydrive with consolidated information from all the events published so far. He...
2014-01-31
1,150 reads
If you missed it live you get a second chance! http://www.mssqltips.com/sql-server-video/284/security-compliance-and-sql-server-video/. Had about 300 attend and more questions than we...
2014-01-30
1,095 reads
I reviewed my daily report and saw that some jobs failed on six instances overnight, the common factor being that...
2014-01-30
2,171 reads
I hope you can make time for a learning break at work today – register directly at https://www2.gotomeeting.com/register/279348610 to learn more...
2014-01-29
543 reads
I’ve never written a novel or a movie script, but I’ve sure consumed a lot of both and enjoy both....
2014-01-28
788 reads
My first webinar of the year! I’m joining forces with the GreenSQL and MSSQLTips to present Security, Compliance, and SQL...
2014-01-27 (first published: 2014-01-13)
975 reads
Over the past week there has been information finally coming out about how the Target breach occurred. This write up...
2014-01-24
929 reads
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
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...
Hi, In my Always On Availability environment, I am seeing two encrypt_option values as...
Hi everyone I have a bunch of CSV files that I need to bulk...
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