T-SQL Tuesday #136: Your Favorite (or Least Favorite) Data Type
T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Brent Ozar (blog | twitter) asks us to talk about data...
2021-03-09
12 reads
Setting the Sample Rate for Automatic Statistics updates
I talked a few posts ago about Automatic Sample Sizes for Statistics Updates. From SQL 2016 CU4 we've been able to override that. You can manually update a statistics...
2021-03-11 (first published: 2021-03-09)
389 reads
Azure SQL Database – Contained user Model
I always follow a contained user model when setting up users within my Azure SQL Database. I do this so the user in question has access to only specific...
2021-03-12 (first published: 2021-03-09)
346 reads
T-SQL Tuesday #136: Your Favorite (or Least Favorite) Data Type
T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Brent Ozar (blog | twitter) asks us to talk about data...
2021-03-09
16 reads
Introducing WordPress Stories: A New Way to Engage Your Audience
Interested in a new way to create and publish engaging content on your WordPress site? Today, we're unveiling our new Stories feature, now available in the WordPress apps.
2021-03-08
25 reads
Logging Messages with Raiserror – #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I recently ran across some people discussing how...
2021-03-12 (first published: 2021-03-08)
375 reads
Daily Coping 8 Mar 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-03-08
16 reads
Webinar – Building a Proper SQL Server Database Security Model
Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation on how to build a database security model in SQL Server. We’ll primarily focus on...
2021-03-08
73 reads
Stellar Toolkit for MS SQL - Software Review
As a SQL database administrator, I am responsible for maintaining our organization's SQL Server and databases. But despite implementing best database maintenance practices, including backups and performing DBCC CHECKDB...
2021-03-08
35 reads
Stellar Toolkit for MS SQL - Software Review
As a SQL database administrator, I am responsible for maintaining our organization's SQL Server and databases. But despite implementing best database maintenance practices, including backups and performing DBCC CHECKDB...
2021-03-11 (first published: 2021-03-08)
835 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