Get Information on Current Traces Running
This is just a quick informational query to save as a snippet to get some quick information on running traces,...
2014-12-02
956 reads
T-SQL Tuesday #61 – Giving Back
The Season of Giving
The annual PASS Summit (otherwise known as the #SQLFamily reunion) is over. Here in the United States,...
2014-12-08 (first published: 2014-12-02)
6,446 reads
SQL Server 20082008 R22012 || Remove Node from failover cluster
Steps to remove node from failover cluster for SQL Server 2008 onwards :-
Note :-
a) Same process will be used to...
2014-12-02
1,116 reads
Creating Placeholder Files
I recently wrote about placeholders for disk space. While you can use any file, like large images, video, etc., I’ve...
2014-12-01
1,079 reads
Last Weeks Top “Reading” Links #111
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-12-01
528 reads
SQLFamily.Org
Back in March 2013 I wrote We Need A Place For SQLFamily News after the death of the spouse of...
2014-12-01
522 reads
Exam Prep 70-463: Intro to Columnstore Indexes
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-09 (first published: 2014-12-01)
5,924 reads
Using a date or int column as the clustered index.
The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on...
2014-12-08 (first published: 2014-12-01)
7,000 reads
SSIS Parent-Child Architecture in Catalog Deployment Mode
This is the third in a series of posts about SSIS parent-child architecture. You can find the index page here.
In...
2014-12-05 (first published: 2014-12-01)
7,341 reads
Azure SQL Server Database
SQL Server in Azure
You can create and leverage cloud based SQL Server instances using Microsoft Azure. However, if you have...
2014-12-04 (first published: 2014-12-01)
6,784 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