Extended Events – Event Anatomy
As a follow-up to the introduction to what an Event is, it makes sense to discuss the components of an event. What makes up an event? What is the...
2015-09-11
14 reads
Jason Brimhall
Extended Events – Events
If you recall, an event is some point of interest that may or may not occur within an application. Obviously, if the event is triggered, then that point of...
2015-09-10
30 reads
XEvent Session Supporting Cast
So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated...
2015-09-10 (first published: 2015-09-04)
991 reads
Extended Events Categories
I recently delved into a brief explanation of Packages as they correlate to Extended Events. In that article, I left...
2015-09-09
995 reads
Extended Events Categories
Packages have a couple of descriptors (or classifiers) that can be useful to help figure out what events contained within that package might be related to other events.
Related Posts:
How...
2015-09-09
11 reads
One Easy Strategy for the Database Enterprise
Working with the default XEvent session and trying to make it more suitable to Enterprise worthy.
Related Posts:
SQL Servers Black Box Recorder - system_health December 29, 2018
Finding Installed Event...
2015-09-09
11 reads
One Easy Strategy for the Database Enterprise
Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server...
2015-09-09
710 reads
Extended Events Objects
Today I want to start diving into some of this data a little deeper as we progress some of the of the core concepts surrounding Extended Events.
Related Posts:
Correlate SQL...
2015-09-08
13 reads
Learning Extended Events in 60 Days
Want to Learn Extended Events over the course of your lunch break for a couple of months? This is the Table of Contents for learning Extended Events over the...
2015-09-08
63 reads
Learning Extended Events in 60 Days
This post will serve as the landing page for a series I am calling 60 Days of Extended Events. The...
2015-09-08
775 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Using CHOOSE()
Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
The DBA is Dead! Long Live the !
Comments posted to this topic are about the item The DBA is Dead! Long...
Question of the Day
Using CHOOSE()
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers