Can you partition a temporary table?
Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too would wonder the same thing. That withstanding, it is...
2014-05-23
12 reads
Can you partition a temporary table?
Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too...
2014-05-29 (first published: 2014-05-23)
3,861 reads
Reblog: May 16 to May 22
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-05-23
468 reads
Management Reporter Security
Are you confused by how user roles in AX 2012 are integrated with Management Reporter roles? Have problems adding or...
2014-05-23
867 reads
Wishing For Error Messages That Are Good Search Terms
Here’s a SQL error you might get:
not able to access the database “SomeDB” under the current security context.
If you don’t...
2014-05-23
525 reads
Complexity. How it is calculated.
What are the magic pink numbers you can see in Code Outline window?The answer is very simple - these are Code Complexity...
2014-05-28 (first published: 2014-05-23)
700 reads
Naked Statistics
A few weeks ago I stumbled up on this book review of Naked Statistics by Nathan Yau. The introduction on...
2014-05-23
899 reads
Failed To Lock Virtual Machine’s Configuration
[Updated]
I rebuilt my Hyper-V virtual machines / virtual network by deleting the old ones and building new machines on a portable...
2014-05-23
14,769 reads
Building The SQLSaturday Orlando Marketing Plan–Part 10
My experiment with Meetup.com hasn’t worked out well so far. I set up the event site and sent it around...
2014-05-23
537 reads
Friday Followup For May 23, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-05-23
409 reads
Blogs
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...
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
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