Know Before You GO – Target Settings
The last few articles have covered various topics for the event_file and ring_buffer target. The topics range from basic queries in...
2015-10-19
624 reads
Jason Brimhall
Know Before You GO – Target Settings
When adding a Target to a session, a configurable setting may or may not be obviously available for use with the Target. In and of itself, this can be...
2015-10-19
12 reads
Reading Session Data from Memory
In this article, I introduce the topic of reading session data from memory along with some of the pitfalls and some words of caution.
Related Posts:
How to: File Target use...
2015-10-16
27 reads
Better Practices for Reading Event_file Targets
In this article, I am going to address some better practices for Reading Event_file targets attached to an XEvent Session.
Related Posts:
How to: File Target use in Extended Events December...
2015-10-15
11 reads
Better Practices for Reading Event_file Targets
I have demonstrated over the past couple of articles the basics involved with reading the
event_file target along with a more...
2015-10-15
643 reads
Dynamically Read event_file Data
In the previous article I covered the basics on extracting the payload for the events in a session from the event_file...
2015-10-14
856 reads
Dynamically Read event_file Data
There needs to be a more efficient means of grabbing the file without having to know the location. Knowing the session name should be adequate enough to parse the...
2015-10-14
13 reads
Auditing Needs Reporting
No matter the mechanism used to capture the data to fulfill the "investigation" phase of the audit, if the data is not analyzed and reports generated, then the audit...
2015-10-13
10 reads
Auditing Needs Reporting
Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server...
2015-10-13
694 reads
Intro to Reading Event_File Target Data
Having covered the metadata for a deployed session from just about every angle (yes there is more on metadata that could...
2015-10-13
955 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