Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
17,391 reads
Jason Brimhall
Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
159 reads
An Identity Crisis: Is it Profiler or is it Extended Events?
I have been working on this article for far longer than one might think is necessary for something of this...
2017-12-22
123 reads
An Identity Crisis: Is it Profiler or is it Extended Events?
Despite it being new, it seems there are a handful of "facts" already published about it that may or may not be accurate. Due to that, I want to...
2017-12-22
15 reads
Capture Index Maintenance Operations
If an application vendor has something built into their code to perform index maintenance, unbeknownst to you, that is a near-worst case scenario.
Related Posts:
Where is that Mask? December 28,...
2017-12-20
13 reads
Capture Index Maintenance Operations
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index...
2017-12-20
669 reads
T-SQL Tuesday #097: Learning Plans
Stylishly Late
I am fabulously late and therefor breaking the guiding rules that make up TSQLTuesday. Where’s the ruler to slap...
2017-12-18
477 reads
T-SQL Tuesday #097: Learning Plans
If you are not progressing, you are regressing. In the same vein, if you are not learning, you are regressing.
Related Posts:
T-SQL Tuesday #102: Giving Back May 8, 2018
T-SQL...
2017-12-18
18 reads
Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error that is vague, we sometimes find ourselves wanting to...
2017-11-17
45 reads
Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error...
2017-11-17
339 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