Optimization with temp tables – Example
The code optimization is a mandatory task for the programmable objects in SQL Server. During time some code can start working “badly” i.e. become slow. In that case a...
2016-05-05
11 reads
Optimization with temp tables – Example
The code optimization is a mandatory task for the programmable objects in SQL Server. During time some code can start working “badly” i.e. become slow. In that case a...
2016-05-05
8 reads
Optimization with temp tables - example
The code optimization is a mandatory task for the programmable objects in SQL Server. During the time some code can...
2016-05-05
230 reads
Optimization with temp tables – Example
The code optimization is a mandatory task for the programmable objects in SQL Server. During time some code can start...
2016-05-05
90 reads
Where do you put your business logic? In stored procedures?
There seems to be two trains of thought and I think this is mainly down to who and where your...
2016-05-13 (first published: 2016-05-05)
4,345 reads
Where do you put your business logic? In stored procedures?
There seems to be two trains of thought and I think this is mainly down to who and where your...
2016-05-05
42 reads
Where do you put your business logic? In stored procedures?
There seems to be two trains of thought and I think this is mainly down to who and where your...
2016-05-05
38 reads
Pensacola in June–SQL Saturday #491
One June 5, I’ll be back in Pensacola, FL for SQL Saturday #491. It’s been a few years since there...
2016-05-05
518 reads
Where do you put your business logic? In stored procedures?
There seems to be two trains of thought and I think this is mainly down to who and where your developers are. The first is that a stored procedure...
2016-05-05
16 reads
SQL Saturday Iowa City Precon – The Complete Primer to SQL Server Infrastructure
I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Iowa...
2016-05-05
389 reads
Blogs
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, which is...
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