Storing Event Data
Among the several core concepts of Extended Events is the concept of storing event payloads / data.
Related Posts:
How to: File Target use in Extended Events December 27, 2018
Dynamics...
2015-09-16
7 reads
Jason Brimhall
Storing Event Data
Among the several core concepts of Extended Events is the concept of storing event payloads / data. When an event fires, it...
2015-09-16
789 reads
Actions In Extended Events
The next component to discuss is Actions. I have discussed various aspects of events, schemas, categories and packages as some...
2015-09-15
1,470 reads
Actions In Extended Events
an action invokes memories of verbs and "to do" something. If you recall from the quick definition in the article on Extended Events Objects, an action is "a means...
2015-09-15
11 reads
Extended Events Objects
So far, I have talked about some of the metadata associated with Extended Events. But I have not yet started...
2015-09-15 (first published: 2015-09-08)
1,929 reads
Free SQL Training in Seattle
The annual SQL Server Professional migration is about to begin. Many of us will be descending upon the city of...
2015-09-15
677 reads
Free SQL Training in Seattle
Free Training in Seattle!
Related Posts:
Seattle SQL Pro Workshop 2017 October 19, 2017
Seattle SQL Pro Workshop 2017 Schedule October 26, 2017
T-SQL Tuesday 109: Influence Somebody Invite December 4,...
2015-09-15
8 reads
Extended Events and Fixed Schemas
Working with databases, XML, and many software applications, it is not uncommon to deal with fixed schemas. In the database world, it is fairly fundamental to have some sort...
2015-09-14
28 reads
Extended Events and Fixed Schemas
Working with databases, XML, and many software applications, it is not uncommon to deal with fixed schemas. In the database...
2015-09-14
534 reads
Extended Events – Event Anatomy
So far in these brief discussions about Extended Events, I have covered several core concepts including a basic introduction into...
2015-09-11
619 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