Event Tracing for Windows Target
There are many useful targets within SQL Server’s Extended Events. Of all of the targets, the most daunting is probably...
2019-01-03
1,377 reads
Jason Brimhall
File Maintenance – Cleaning Up Old Files
Using SSIS to Maintain the File System
We have all run into a need or a desire to clean up old...
2019-01-03 (first published: 2018-12-21)
2,885 reads
Checking your Memory with XE
It is well known and understood that SQL Server requires a substantial amount of memory. SQL Server will also try...
2019-01-02
341 reads
Checking your Memory with XE
It is well known and understood that SQL Server requires a substantial amount of memory. SQL Server will also try to consume as much memory as possible from the...
2019-01-02
16 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous inside of SSMS, but run miserably inside the application.
Related...
2019-01-01
37 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous...
2019-01-01
443 reads
Finding Installed Event Sessions
As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying...
2018-12-31
212 reads
Finding Installed Event Sessions
Get off that arctic island and warm up with a little XE fun. This script is quite simple but will show you what you may have out there on...
2018-12-31
10 reads
SQLs Black Box Recorder – sp_server_diagnostics
The diagnostics process will trap various server related health (diagnostics) information related to the SQL Server instance in an effort to try and detect potential failures and errors.
Related Posts:
SQL Servers...
2018-12-30
135 reads
SQLs Black Box Recorder – sp_server_diagnostics
Yesterday i shared the first article in a three part series about the SQL Black Box Recorder, that you can...
2018-12-30
335 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