Session Action Metadata
In a previous article, I introduced the core concept of Actions. In that article, I explained that an Action is...
2015-09-30
1,153 reads
Jason Brimhall
Session Action Metadata
Knowing how to access the deployed session metadata and the event metadata attached to that session, I will now begin the dive into how to find the same relevant...
2015-09-30
14 reads
Predicate Order is Critical
I have mentioned predicate order previously and wanted to make sure I drive home the importance of the predicate order...
2015-09-29 (first published: 2015-09-23)
3,196 reads
Session Event Metadata
There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to know where and how to find it. In this...
2015-09-29
11 reads
Deployed Session Settings
Deployed Session Settings are stored within the system databases and then exposed via system catalog views. These settings help define a session. This article shows how to access those...
2015-09-28
17 reads
The Extended Event GUI
The Extended Events GUI provides a visual access to the Extended Events engine that can help to better understand the XEvents Engine and how a Session is built.
Related Posts:
Profiler...
2015-09-25
13 reads
Assembling a Session
With the core concepts in place as a good foundation to Extended Events, we start pushing these things together to help with assembling a session in Extended Events.
Related Posts:
Short...
2015-09-24
5 reads
Assembling a Session
Up to this point, I have taken a lot of time to discuss the various components of Extended Events. There is...
2015-09-24
552 reads
Extended Events – Events
After thrilling dives into the XEvent Core Concepts of packages, channels and objects, today we have the core concept of...
2015-09-23 (first published: 2015-09-10)
1,444 reads
Freecon – Oct 27 in Seattle
Just over a week ago I announced that SQL Solutions Group was getting ready to host a day of training,...
2015-09-23
814 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