Know When it’s Good Enough
Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love...
2014-01-28
717 reads
Jan PASS Data Architecture VC presents Ike Ellis on Tips & Tricks
Please join the PASS Data Architecture virtual chapter on Thursday Jan 30th at noon central for SQL Server Tips and...
2014-01-28
1,131 reads
If You’re Not Doing Anything….
Hey… Pssst… Yeah, you there on the couch. Listen, if you’re not doing anything around lunchtime on February 6th, I...
2014-01-28
639 reads
Inside the Statistics Histogram & Density Vector
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-04 (first published: 2014-01-28)
4,155 reads
Master Data Services for the Beginner Part 03
Introduction
In yesterday’s discussion we looked at creating entities and their related attributes. We learnt that a ‘model’ could be very...
2014-02-05 (first published: 2014-01-28)
6,245 reads
Powershell in a Month Day 13 – Remote Control
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-27
1,055 reads
Transact-SQL (T-SQL) query to return the status and detail information for all SQL Server Full-Text Catalogs on an SQL Server instance
We have about 200 user databases in which we have the full-text search enabled and these databases contain several tables....
2014-01-27
1,864 reads
Basic RegEx in SSMS
Have you ever had that moment where you have gone "Geez.. I wish I'd learnt this stuff ages ago" after...
2014-02-04 (first published: 2014-01-27)
6,177 reads
February 2014 – SQL Server Monthly Maintenance Checklist
image source
It’s a cold, cold day here in Minnesota. A great day for staying in and working on some in-home...
2014-01-27
542 reads
Vote on Connect Items for SQL Server 2008/2008 R2 and 2012 Service Packs
As we get closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2...
2014-02-03 (first published: 2014-01-27)
2,503 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