Unit Test Sql Server Code
In part 3 of this series of blogs on "getting more agile" I am going to look at unit testing...
2015-03-03
410 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing and why we need to do it.
My code is...
2015-03-03
19 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing...
2015-03-03
67 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing...
2015-03-03
58 reads
How to Fix Latch Problems when Working with Ascending Keys in SQL Server
Traditionally, we want our Clustered Index to have the following attributes:
Narrow: So that our clustered index and the non-clustered indexes that point...
2015-03-03
681 reads
50 Shades of Brown – The Series
That’s right I’m cashing in on the “50 Shades” franchise and twisting it to meet my own sordid needs to...
2015-03-03
671 reads
A Handy function
If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...
2015-03-03
179 reads
Simple-Talk Article
In December, I was asked to write an article(s) on Database Refactoring. It started as 2 topics, but then consolidated...
2015-03-03
843 reads
SQL Server, Error message 1785, and cascading deletes: How it kills kittens
I've been gone for a bit, forgive the long delay. Who would have thought the hatred for a cascading delete...
2015-03-03
1,120 reads
Should I check tempdb for corruption?
You all know that checking our databases for corruption regularly is a must. But what about tempdb? Do you need...
2015-03-02
4,601 reads
Blogs
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
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