T-SQL for UDFs
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for...
2016-01-15
119 reads
Flexibility of T-SQL for designing user defined functions
SQL Server has plenty of built-in functions but sometimes we just have to combine some of them to create functions for...
2016-01-15
88 reads
2016-01-15
15 reads
Temporary Post Used For Theme Detection (7bc987a8-70ff-4bce-b0b5-d4bad4ef7912 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (c6d728fb-93d8-4ec0-a66c-6dd5e7281550 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2016-01-14
454 reads
PowerShell- Monitoring Multiple Services On Multiple Servers Using WMI Class -Win32_Service
The requirement is to check only those services where startup mode set to Auto and services that stopped. In my...
2016-01-14
628 reads
Change Availability Group Endpoint IP
I had someone email me and ask how they could change the IP address on their Availability Group Endpoint. It’s...
2016-01-26 (first published: 2016-01-14)
1,538 reads
What is RESULT SETS?
I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before...
2016-01-26 (first published: 2016-01-14)
8,290 reads
10 Years of Blogging
Yesterday, on the 13th of January 2016, my blog has reached it’s 10th anniversary. It all started precisely 10 years...
2016-01-14
450 reads
Rebuilding a Heap–Don’t Do It
I saw someone mention recently that you can run a REBUILD on a heap table. I hadn’t realized that, but...
2016-01-14
1,784 reads
Goodness-of-Fit Testing with SQL Server Part 4.1: R2, RMSE and Regression-Related Routines
By Steve Bolton
…………Throughout most of this series of amateur self-tutorials, the main topic has been and will continue to be...
2016-01-25 (first published: 2016-01-13)
1,974 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