How my SQL Server trainings helped Hannes and his company to improve their SQL Server based software
In the last months I have done a lot of SQL Server consulting engagements where I
have seen the craziest performance...
2011-07-05
842 reads
Converting OR to Union
When I looked at indexing for queries containing predicates combined with OR, it became clear that the are some restrictive...
2011-07-05
1,677 reads
SQL Server “Denali”: Project Crescent
Project “Crescent” is a new interactive data exploration and visual presentation experience coming in the next version of SQL Server, code-named “Denali”. It will...
2011-07-05
1,392 reads
SQLDIY: Statistics Information Including Last Update
One of the most important aspects of keeping your system running well is updating and managing your statistics. Since the...
2011-07-05
1,010 reads
Deleting Accounts from Websites
I ran across this article about How to Delete an Account from Any Website on the PC Magazine web site....
2011-07-05
924 reads
PASS SQL Rally 2011 Evaluations
In keeping with the all my other major speaking engagements, I’m posting the results of my pre-con and session evals...
2011-07-05
940 reads
T-SQL Enhancement: EXECUTE WITH RESULT SETS
All developers know, that it is very important to encapsulate code in classes and methods to be able to reuse...
2011-07-05
804 reads
SQL Server on steroids with RAM disk
I’ve faced pretty common situation recently – you need to work with huge data during development/testing. It’s good if you have...
2011-07-05
2,614 reads
Select from a table with no rows returned.
G’day,
I recently ran into a nice feature that I had never encountered before.
Sometimes, when developing or administrating an unfamiliar table...
2011-07-04
5,017 reads
Wild West Day
One of the things I’m missing today is Wild West Day at Red Gate. It’s not just because I don’t...
2011-07-04
1,599 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