Waiting, is it a Bad Thing?
Despite the desire to get away from the GUI talk in these articles about Extended Events, I have so far...
2016-01-06
763 reads
Jason Brimhall
Waiting, is it a Bad Thing?
One of the more useful troubleshooting tools (granted when used properly and not with a knee jerk approach) is waits. There are waits in SQL Server that are very...
2016-01-06
22 reads
A day in the Stream
Explore the little function called sys.fn_MSxe_read_event_stream and discover just a little bit more of what Extended Events may be doing behind the scenes with the live data viewer.
Related Posts:
Quick...
2016-01-05
31 reads
A day in the Stream
Enough talk of the GUI with Extended Events (see previous articles in the series if you want to revisit the...
2016-01-05
3,842 reads
Log Files from Different Sources
Well, it has been quite a pause between articles in the series. It is well past time to continue the...
2016-01-05 (first published: 2015-12-30)
1,828 reads
Hidden GUI Gems
The GUI for Extended Events offers some power to help you get started with trying to work with Extended Events....
2016-01-02
1,485 reads
Hidden GUI Gems
I have a few gems that are available to you in the GUI. These gems should help solidify your understanding of the tools available through the GUI to help...
2016-01-02
7 reads
Filtering Logged Data
Explore how to customize the view of the GUI for working with XEvent Log files or XEL files. This further customization does include working with filters.
Related Posts:
Get a List...
2016-01-01
33 reads
Customize the XEvent Log Display
Explore how to configure the XEvents GUI with specific views to suit your needs and tastes for data display by adding, removing or changing the column orders.
Related Posts:
Easy Open...
2015-12-31
16 reads
Customize the XEvent Log Display
In the previous article I showed a couple of methods to merge Extended Event Log files. In that article I...
2015-12-31
1,032 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