SQL Lunch Rescheduled
Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled. The event will be on...
2012-03-14
660 reads
Blog Posts
SQL Lunch Rescheduled
Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled. The event will be on March...
2012-03-14
806 reads
SQL Saturday 103 Recap
SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean. I was fortunate enough to be able...
2012-03-14
628 reads
SQL Server 2012 AlwaysOn & A Thorough Setup
It’s surprisingly easy to set up the new AlwaysOn features. I’ve done it on VMs running on my laptop, from...
2012-03-14 (first published: 2012-03-12)
3,163 reads
SQL Server 2012: Tabular Models vs PowerPivot Models
In SQL Server 2012, there is a new data model, called tabular, that is part of the new feature called the...
2012-03-14
2,787 reads
Table Size and Missing FK Indexes
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a couple of different queries that I like to use....
2012-03-14
11 reads
Table Size and Missing FK Indexes
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a...
2012-03-14
1,129 reads
Understanding the concept of SQL Server Failover Cluster
Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately...
2012-03-14
17,395 reads
A Quick Introduction to Data Compression in SQL Server 2008
There is one thing every DBA knows with certainty, and that is that databases grow with time. MDFs grow, backups...
2012-03-13
2,022 reads
Command Prompt connectivity –U option
When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows...
2012-03-13
540 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