From the Labs of SQL Prompt
I love SQL Prompt as an add-in for SSMS. The intellisense is very handy for me and I’ve gotten used...
2012-05-25 (first published: 2012-05-21)
2,706 reads
Blog Posts
How to restore the tail end of a transaction log
Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...
2012-05-25 (first published: 2012-05-21)
2,528 reads
SQL Server – Cannot resolve collation conflict
A friend of mine contacted me through email today having a very common problem with a query he had written....
2012-05-25
798 reads
The Done Stamp
I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...
2012-05-25
587 reads
Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Earlier sql server was having diagnoses tool.
Default trace.
SQLDiag
And other tools but could not...
2012-05-24
1,424 reads
It’s OK To Eat Alone
There’s a lot to be said for the philosophy of Never Eat Alone, using meals as a great time to...
2012-05-24
761 reads
Recently Used Tables and Databases
Recently developed these queries to assist with the evaluation of development or sandbox environments. Sometimes disk space demands that old...
2012-05-24
1,574 reads
SQLServerCentral.com Track Offered at 2012 SQL Server Connections in Las Vegas this Fall
As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...
2012-05-24 (first published: 2012-05-21)
2,165 reads
What happens when a SSAS Tabular model exceeds memory?
If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database...
2012-05-24 (first published: 2012-05-21)
3,704 reads
Analyzing TPC-E Benchmark Performance by Physical Processor Core
The TPC Benchmark E (TPC-E) is an OLTP performance benchmark that was introduced in May, 2007. The TPC-E benchmark is...
2012-05-23
2,119 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
Unencrypted connections in Always on Availability Group
Hi, In my Always On Availability environment, I am seeing two encrypt_option values as...
Error loading multiple CSV files in SSIS
Hi everyone I have a bunch of CSV files that I need to bulk...
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