Checking your Memory with XE
It is well known and understood that SQL Server requires a substantial amount of memory. SQL Server will also try...
2019-01-02
341 reads
SQL RNNR
Checking your Memory with XE
It is well known and understood that SQL Server requires a substantial amount of memory. SQL Server will also try to consume as much memory as possible from the...
2019-01-02
16 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous...
2019-01-01
443 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous inside of SSMS, but run miserably inside the application.
Related...
2019-01-01
37 reads
Finding Installed Event Sessions
As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying...
2018-12-31
212 reads
Finding Installed Event Sessions
Get off that arctic island and warm up with a little XE fun. This script is quite simple but will show you what you may have out there on...
2018-12-31
10 reads
SQLs Black Box Recorder – sp_server_diagnostics
Yesterday i shared the first article in a three part series about the SQL Black Box Recorder, that you can...
2018-12-30
335 reads
SQLs Black Box Recorder – sp_server_diagnostics
The diagnostics process will trap various server related health (diagnostics) information related to the SQL Server instance in an effort to try and detect potential failures and errors.
Related Posts:
SQL Servers...
2018-12-30
135 reads
SQL Servers Black Box Recorder – system_health
Yesterday i shared the first article in a three part series about the SQL Black Box Recorder, that you can...
2018-12-29
358 reads
SQL Servers Black Box Recorder – system_health
In this article, the focus will be directed to the next leg of the black box recorder - or the system_health Extended Event Session.
Related Posts:
SQLs Black Box Recorder -...
2018-12-29
43 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