CHOOSE() in SQL Server
Watch this week's video on YouTube
While I know I don't utilize most of the features available in SQL Server, I like to think I'm at least aware that those features exist.
This...
2019-06-04
20 reads
Bert Wagner
CHOOSE() in SQL Server
Watch this week's video on YouTube
While I know I don't utilize most of the features available in SQL Server, I like to think I'm at least aware that those features exist.
This...
2019-06-04
21 reads
12 Ways To Rewrite SQL Queries for Better Performance
Watch this week’s video on YouTube. Thanks to you, we just crossed the 2k subscriber mark! Over the past several week’s I’ve been exploring ways to rewrite queries to improve...
2019-06-13 (first published: 2019-05-28)
3,778 reads
12 Ways To Rewrite SQL Queries for Better Performance
Watch this week's video on YouTube
Over the past several week's I've been exploring ways to rewrite queries to improve execution performance.
I learned a lot of these techniques over time from...
2019-05-28
14 reads
12 Ways To Rewrite SQL Queries for Better Performance
Watch this week's video on YouTube
Over the past several week's I've been exploring ways to rewrite queries to improve execution performance.
I learned a lot of these techniques over time from...
2019-05-28
43 reads
Predicate Execution Order on Mixed Data Type Columns
Watch this week’s episode on YouTube. SQL Server’s cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query...
2019-06-04 (first published: 2019-05-21)
588 reads
Predicate Execution Order on Mixed Data Type Columns
Watch this week's video on YouTube
SQL Server's cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query executions....
2019-05-21
13 reads
Predicate Execution Order on Mixed Data Type Columns
Watch this week's video on YouTube
SQL Server's cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query executions....
2019-05-21
23 reads
Animating a Magic 8 Ball in SQL Server Management Studio
This post is a response to this month’s T-SQL Tuesday #114 prompt by Matthew McGiffen. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-05-24 (first published: 2019-05-14)
894 reads
Animating a Magic 8 Ball in SQL Server Management Studio
This post is a response to this month's T-SQL Tuesday #114 prompt by Matthew McGiffen. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-05-14
20 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