In-Memory OLTP and the Identity Column
Over the past month I've been playing around with the new In-Memory OLTP (code name: "Hekaton") features within SQL Server...
2013-11-12
1,530 reads
Everyday SQL
TSQL Tuesday #47 - Your Best SQL Server SWAG
The host for T-SQL Tuesday #47 is Kendal Van Dyke (blog|twitter), and his topic of choice is about the best...
2013-10-08
976 reads
One Year Later
Wow! It’s been one year since I launched my blog, and my how things have changed.
Accomplishments Over the Past...
2013-09-24
712 reads
The Case of the NULL Query_Plan
As a DBA, we're often asked to troubleshoot performance issues for stored procedures. One of the most common tools at...
2013-09-06 (first published: 2013-09-03)
3,275 reads
How to Tell If Your Users are Connecting to the Availability Group Listener
You've spent a lot of time planning and building out a new SQL Server 2012 environment complete with Availability Group...
2013-08-29 (first published: 2013-08-27)
2,442 reads
PASS Summit 2013 - You Ain't From Around Here Are Ya?
I know what y'all are thinkin', what's Charlotte got to do with SQL Server? Just hear me out. There's a...
2013-08-20
1,298 reads
Are You the Primary Replica?
UPDATED -- Jul 3, 2015 -- To verify database exists, per comments by Konstantinos Katsoridis. Thanks for finding the bug!
In my recent adventures...
2013-07-23
1,667 reads
Setup an Availability Group with Multiple Subnets in VMware Workstation
Before we get started, I want to make it clear this is NOT how you would normally configure all these...
2013-07-16
2,540 reads
VMware vSphere Storage Performance - Thick vs Thin Provisioning
Industry experts will tell you that virtualization of your environment is not done to improve performance, it's done to make...
2013-06-25
4,483 reads
Investigating Plan Cache Bloat
SQL Server includes a DMV, sys.dm_exec_query_stats, that returns performance statistics for each query plan cached in memory. However, it can...
2013-05-28
1,148 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