Query Hash Formula Changes Between Versions
The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...
2015-04-21
632 reads
How to Configure E-mail in SQL Server Step by Step–TIP #96
For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL ...
2015-04-21
637 reads
Follow the yellow brick what? My road to public speaking.
Follow the yellow brick Road!
Original Image Credit: airdiogo on flickr
If you would have asked me 2 years ago if...
2015-04-21
2,001 reads
Moving SQL Server data between filegroups – Part 1 – Database Structures
Why is moving data between filegroups hard?
****As a consultant its common to walk into a customer site and find databases that are contained in one very large file. For...
2015-04-21
21 reads
SQL 2014 CU5
By David Postlethwaite
If you are using SQL Server 2012 or 2014 RTM you will find that SSMS offers very limited...
2015-04-21
786 reads
In-Memory OLTP: Part 3 – Checkpoints
This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...
2015-04-20
425 reads
In-Memory OLTP: Part 3 – Checkpoints
This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...
2015-04-20
1,100 reads
The MERGE Statement – One Statement for INSERT, UPDATE and DELETE
Starting with SQL Server 2008, we can use the MERGE statement to solve some every day scenarios in more elegant...
2015-04-20
2,317 reads
T-SQL HOST_ID and HOST_NAME
HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL...
2015-04-20
3,532 reads
The hidden security of msdb
To be fair it’s not actually hidden, just not so well known.
Have you ever wondered how to grant permissions...
2015-04-20
1,548 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