Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of the content located...
2016-02-02
2,174 reads
Advent of Code – Day 2 – Using Cross apply
For this post i worked on second puzzle in the Adventofcode series. This wasn’t as challenging as the first one, but...
2016-02-02
317 reads
Excel Power Map vs. Power BI Globe Map visualization
[2016-02-02] PowerMap in Excel is a great tool with good design and comprehensive user experience. I’ve started using it about...
2016-02-09 (first published: 2016-02-02)
5,878 reads
Microsoft Azure Stack in Preview!
Microsoft made available the first technical preview of its new Microsoft Azure Stack offering today. It was announced last week. Azure...
2016-02-09 (first published: 2016-02-01)
1,886 reads
Loading a Text File from T-SQL
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-02-10 (first published: 2016-02-01)
3,396 reads
SSC Editorial: Design a Better SQL Server Pricing Model
Design a Better SQL Server Pricing Model ran on January 21, 2016 and as you can guess from the title is...
2016-02-01
590 reads
Monday Morning SQL Break – February 1, 2016
It’s Monday and time fora round-up of last week’s blog and twitter activity – and even an on-time post for all of...
2016-02-01
474 reads
Learning R: Happy With My Book Choice
This is just a quick update. I wrote about the two books I’m using to learn R. Well, I’m extremely...
2016-02-01
508 reads
Running code on the startup of SQL Server
Every now and again you need to run code when your instance starts up. For example you might want to...
2016-02-08 (first published: 2016-02-01)
1,477 reads
TempDB Excessive Memory Usage Example
I see TempDB using more memory than I feel it should and found a way to resolve it. Previously I dove into technical details and questioning what I saw...
2016-02-01
32 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
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...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
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