Mastering Index – Nonclustered Index
This article is the part of series Mastering Index, in this particular article we will be exploring Nonclustered Index. Take...
2016-10-10
479 reads
Help on SQL Server
Mastering Index – Clustered Index
This article is the part of series Mastering Index, in this particular article we will be exploring Clustered Index. Take...
2016-10-03
534 reads
Mastering Index – Introduction
One of the most interesting and talked about topic in database field is Index. I am writing this Series of...
2016-09-29
868 reads
Part 1 - Detecting and Monitoring Memory Pressure
I will be writing
this article in four parts because this topic is huge and amount of information
can be overwhelming for...
2016-09-27
502 reads
Order by Month Number and Show Month Name
This may feel very
simple to many developers and yes it is, but I saw this request somewhere in community
website.So thought...
2016-09-24
948 reads
Mastering Index - Filtered Index
Mastering Index - Filtered Index
This article is the part of series Mastering Index, in this particular article we will be exploring Filtered Index. Take...
2016-09-23
623 reads
Learn Basic SQL in 30 minutes
This article is for those who have no idea about Sql and I will be giving them a start point...
2016-09-21
450 reads
Books VS Internet
It’s is very easy to be
confused between investing in books or we should use the power of internet. If
you ask...
2016-09-19
239 reads
Sql Server - Detecting and Monitoring Memory Pressure
Introduction - Detecting and Monitoring Memory Pressure
I will be writing this article in four parts because this
topic is huge and amount...
2016-09-15
484 reads
Interview Questions for Companies
In this article I will be posting interview questions by companies. Whenever I am facing any interview or someone shares...
2016-09-13
337 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