You Are Responsible for You
Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...
2011-05-12
748 reads
Locking While Dropping or Altering an Index
Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking...
2011-05-12
7,577 reads
Pragmatic Tools Week: Task Factory
If you've ever spent any time doing SSIS development work, you'll eventually come to a point when developing something and...
2011-05-11
1,442 reads
DBA VC Presentation May 11
Come one, come all!! Oh wait, it’s too late now. I just finished giving my presentation to the DBA VC (virtual chapter). There was good attendance and there were...
2011-05-11
6 reads
DBA VC Presentation May 11
Come one, come all!! Oh wait, it’s too late now. I just finished giving my presentation to the DBA VC...
2011-05-11
670 reads
T-SQL: Identifying, inserting and removing spaces in strings
Frequently, when working with strings you will need to identify, insert or remove spaces before, after or in between characters.
For example, you may...
2011-05-11
3,830 reads
Troubleshooting Performance -1
Whenever you get a call from user that they are facing any performance issue what would you do. As I...
2011-05-11
478 reads
Patch Week
My email account started getting notices of Windows patches yesterday, indicating it’s patch week again. If you manage Windows devices,...
2011-05-11
901 reads
Networking and Connections
This quote says it all:
It’s from an article on the 9/11 memorial and how an algorithm was used to inscribe...
2011-05-11
753 reads
PASS Summit 2011 Session Preference Survey
PASS has added a new feature to the session selection process for the PASS Summit 2011, which they are calling...
2011-05-11
610 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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