This week I was reading Pinal Daves post about Autogrowth Events
http://blog.sqlauthority.com/2015/02/03/sql-server-script-whenwho-did-auto-grow-for-the-database/
as it happened I had a requirement to make use...
2015-02-25 (first published: 2015-02-15)
6,279 reads
By Steve Bolton
…………Based on what little experience I’ve gained from writing this series on finding outliers in SQL Server databases,...
2015-02-24 (first published: 2015-02-14)
8,837 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-02-13
386 reads
In this series of posts I am going to talk about what it is we need to do, as Sql...
2015-02-12
336 reads
In this series of posts I am going to talk about what it is we need to do, as Sql developers and DBAs to improve our working practices so...
2015-02-12
7 reads
In this series of posts I am going to talk about what it is we need to do, as Sql...
2015-02-12
52 reads
In this series of posts I am going to talk about what it is we need to do, as Sql...
2015-02-12
50 reads
I’ve been using tSQLt a bit to do some testing and one of the things I’ve tested is standards for...
2015-02-27 (first published: 2015-02-12)
8,021 reads
We’re being told over and over that “throwing hardware at the problem” is not the correct solution for performance problems...
2015-02-24 (first published: 2015-02-12)
8,161 reads
When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was...
2015-02-12
924 reads
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers