Minion CheckDB Beta
Come meet Codex! We’ve had many of you asking to be part of the Minion CheckDB beta and now is...
2016-05-18
679 reads
Come meet Codex! We’ve had many of you asking to be part of the Minion CheckDB beta and now is...
2016-05-18
679 reads
I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me.
Starting...
2016-05-18
478 reads
This post demonstrates the methods of PIT recovery of the database. The step by step details of the recovery process...
2016-05-17
2,037 reads
(DE)
Kaum von den SQLBits XV in Liverpool zurück, auf der ich die Security-Features des SQL Server 2016 vorstellen durfte...
2016-05-17
749 reads
(Didn't realize until I was posting that this was my 100th post...whew!)
--
A few months ago we purchased a new "smart"...
2016-05-17
899 reads
ERROR :
Error Message 1 :
Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS...
2016-05-17
969 reads
This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good...
2016-05-24 (first published: 2016-05-16)
6,895 reads
I love questions. I recently received one about new plans in the Query Store (available in Azure SQL Database now and in...
2016-05-23 (first published: 2016-05-16)
2,729 reads
Let’s start with a very brief definition of some RAID levels.
RAID 0 : Stripe your data across multiple disks. Writing a...
2016-05-24 (first published: 2016-05-16)
1,483 reads
Unveil the inner workings of the esoteric build system...
As a data professional, I've never worked extensively with msbuild or other...
2016-05-16
3,246 reads
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, which is...
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