2015-10-19
17 reads
2015-10-19
7 reads
2015-10-19
9 reads
2015-10-19
20 reads
SQLSaturday – Portland : Detect Worst Performing SQL Queries During Peak Hour
Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected...
2015-10-19
15 reads
SQLSaturday – Portland : Detect Worst Performing SQL Queries During Peak Hour
Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them...
2015-10-19
835 reads
Webinar with PernixData – Tuesday at 1PM Pacific
Join PernixData and me tomorrow at 1PM Pacific for a webinar discussing an exciting technology from PernixData!
In-memory computing is gaining...
2015-10-19
314 reads
Data Warehouse Design Challenge: Relating a Temporal Fact Table to a Date Dimension
This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...
2015-10-19
475 reads
Data Warehouse Design Challenge: Relating a Temporal Fact Table to a Date Dimension
This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...
2015-10-23 (first published: 2015-10-19)
2,863 reads
Know Before You GO – Target Settings
When adding a Target to a session, a configurable setting may or may not be obviously available for use with the Target. In and of itself, this can be...
2015-10-19
12 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