SQL Server - ALTER DATABASE to set a smaller FILEGROWTH for this file.
This error message can appear in the SQL Server Error Log files .
Autogrow of file 'MY_DB' in database 'MY_DB' took...
2012-04-04
3,382 reads
Blog Posts
SQL Server 2012: Multidimensional vs tabular
To expand on what I talked about in SQL Server 2012 (“Denali”): Details on the next version of SSAS, there is...
2012-04-04
6,514 reads
Stress Thoughts-Part 7
I’m going to finish up my thoughts on stress by talking about the philosophy I’ve evolved, some of the tricks...
2012-04-04
823 reads
The evolving role of the database professional
The role of the database professional is quickly evolving to conform with the ever changing demands of the business world....
2012-04-04
1,213 reads
Toshiba Satellite C655-S5503 Review
If you are “in computers” according to your family and friends, you are typically expected to provide lifetime, free tech...
2012-04-04
1,496 reads
What’s stopping you?
I mentioned earlier this week that I’m working on a new presentation for SQLSaturday #119 next month. The talk revolves...
2012-04-04
527 reads
Oracle Tips for MSBI Devs #4: Executing an Oracle Stored Proc with IN Parameters in SSIS Execute SQL Task
The first tip I published discussed how to execute an Oracle procedure with no parameters. In this tip, I will...
2012-04-03
725 reads
Powershell – Validating an IP Address
A task that I have had to do several times over the years is determine if an IP Address string...
2012-04-03
4,176 reads
SQL SERVER Replication – Troubleshooting Steps for Beginners
Few days back there was a replication issue in one of the QA servers. Since the DBA was out of...
2012-04-03 (first published: 2012-03-26)
5,399 reads
The first blog post….
Daunting! By way of introduction, I’m Mat This blog is mostly for myself, to document what I know and maybe...
2012-04-03
596 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