Counting Events
After reading through the articles about the pair_matching target (here) and the article on the histogram target (here), this one is...
2015-10-23
606 reads
Webinar – What’s New for Business Intelligence in SQL Server 2016
I’ll be giving a webinar for MSSQLTips.com on Thursday 29th October 2015.
The title is What’s New for Business Intelligence in SQL Server...
2015-10-23
834 reads
Performance and using of VARCHAR boxes as filters in SSRS reports
Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...
2015-10-22
40 reads
Performance and using of VARCHAR boxes as filters in SSRS reports
Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...
2015-10-22
40 reads
Performance and using of VARCHAR boxes as filters in SSRS reports
Very few people have thought about this performance killer. It is all about report parameter of text type.
The initial situation
There...
2015-11-04 (first published: 2015-10-22)
2,474 reads
Git Push in SQL Source Control
I’m excited. Git support is growing in SQL Source Control and the release recently contains Git push/pull support. If you...
2015-11-03 (first published: 2015-10-22)
2,302 reads
Git Push in SQL Source Control
I’m excited. Git support is growing in SQL Source Control and the release recently contains Git push/pull support. If you...
2015-10-22
1,951 reads
ZOOMIT!
Guilty.
I’m at least one of the people who yelled Zoomit during a keynote at PASS Summit.
I want to take a moment...
2015-10-22
566 reads
Histograms and Events
In this article I show how to use and configure the histogram target. In addition, I explain how to get to the data trapped into this target. Lastly, I...
2015-10-22
8 reads
Histograms and Events
The last few articles covered the pair_matching target and some uses and details that go along with it. For a...
2015-11-03 (first published: 2015-10-22)
1,884 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