Tracking down CPU spikes using process explorer and DMVs
What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish...
2014-10-21 (first published: 2014-10-15)
8,145 reads
Can’t Create A Timeline in Excel on Multidimensional Cube
Excel 2013 - We can’t create a Timeline for this report because it doesn’t have a field formatted as Date.
After getting...
2014-10-15
3,370 reads
Hell No, DMO - DMV is what it shall be!
So, I've finally decided to draw a line in the sand. I've been doing some writing lately. The radio silence...
2014-10-15
1,852 reads
Murder In Utah
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2014-10-14
6 reads
Murder In Utah
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-10-14
593 reads
T-SQL – Scripting Stored Procedure to Create backup copy on same database
This post is one of the request from OP.
Download SQL Backup SP in the same database
The probelm statement 1:-
Create a...
2014-10-14
901 reads
Database Mirroring States (SQL Server)
SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :- Mirroring state Description SYNCHRONIZING The contents of the mirror database are lagging behind the contents of...
2014-10-14
35 reads
#TSQL2sday #59 – My Heroes
Here is my list of heroes for #TSQL2sday. None of them are directly tied to technology, much less SQL Server....
2014-10-14
550 reads
Some Thoughts On Running a Chapter
Last week I spent some time after my presentation to Space Coast SQL talking to Kathleen Branch, the chapter leader,...
2014-10-14
875 reads
T-SQL Tuesday #59–My Hero
It’s October, and another busy fall is underway for me. It’s also the second Tuesday, so it’s T-SQL Tuesday time...
2014-10-14
698 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