Limiting user access to your database
There are situations where you need to grant SELECT permission to a particular user and limit that access to a...
2012-04-11
2,475 reads
Blog Posts
SQL Server – default trace FAQ
Has someone deleted a table?
Are you trying to track auto grow events? Problem scenarios such as Database autogrow and slow...
2012-04-11
1,030 reads
Top 3 Reasons Why Evernote is worth $1 billion to me
Everyone heard about Facebook’s recent purchase of Instagram for $1 billion dollars. No one can imagine how they came with such...
2012-04-11
860 reads
PASS DBA Virtual Chapter: Replication with Hilary Cotter
I’m pleased to announce that this Wednesday April 11th 2012 Hilary Cotter will be presenting for the PASS DBA Virtual...
2012-04-10
1,476 reads
Simple Tips To Speed Up Your SSIS Data Flow
There are a few design choices that can make your SSIS packages run super fast when loading data from table...
2012-04-10
5,013 reads
Speaking In April #SQLSat111 and #SQLSat107
All Quite on the Western Front
It is going to get noisy soon though! I”m speaking at SQLSaturday #111 in Atlanta...
2012-04-10
956 reads
SQL Database roles and members
Q. How can I obtain the members of a role within a database?
A. One method is to use sp_helprolemember
EXEC mydatabase.dbo.sp_helprolemember
--returns...
2012-04-10
955 reads
SQLCLR: Good? Or Evil? #MemeMonday
Is SQLCLR good or evil? Thomas LaRock (Blog | @SQLRockstar) is asking that question this month in his #MemeMonday blog party.
Let’s...
2012-04-10
1,123 reads
T-SQL Tuesday #029 – SQL 2012 and Treating TempDB like it’s really Temporary.
A while back, my young son thought it would be fun to use a CD as a virtual surfboard on...
2012-04-10
1,568 reads
T-SQL Tuesday #029 – Useful Feature of SQL Server 2012
This month, T-SQL Tuesday is being hosted by Nigel Sammy. Since the RTM of SQL Server 2012 just occurred, he...
2012-04-10
1,600 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect
How can you achieve good enough without compromising the process/product? In the world of...
How to Convert FileTime to DateTime
By Patrick
One of my customers recently wanted to rename each of the SQL audit files...
The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should...
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