Get Inspired – SQL Inspire 2011 New York
Coming up next week is the SQL Inspire 2011 event in New York City. It’s an event with a number...
2011-11-01
1,683 reads
SQL Tribal Knowledge
Calling all unpublished* SQL Server folk!
I’m now accepting abstracts for a new project we’re putting together – a community-written book of...
2011-11-01
875 reads
SQL Server Release Services Blog and TechDays 2011- Places Worth Watching (Oh, & In Case You Missed it, SQL 2008 SP3 Was Already Released :)
Yes, SQL Server 2008 SP3 is out ...
TechDays 2011 SQL Server and Data Platform Track
2011-11-01
1,023 reads
Presenting on SQL Internals, Recovery Models, & Backups! OH MY Today
Today I’m presenting “SQL Internals, Recovery Model’s, and Backups. OH MY!”, for Pragmatic Works. I did this presentation once before...
2011-11-01
500 reads
Fame and Social Media
Reading this post about Alton Brown from Good Eats triggered me to think on the topic. It looks like initially...
2011-11-01
473 reads
10 More Days Until Inspiration! - SQLInspireNYC 2011
Can't believe we're ONLY 10 days out from what's shaping up to be quite an extraordinary awesome event! We've been...
2011-11-01
1,302 reads
November Question: What is your favorite, and not so favorite hardware to run SQL Server on?
Selecting which hardware to run SQL Server on is often discussed among DBAs. So, for this month’s question, “What is...
2011-11-01
508 reads
Quick and Dirty Index Info
From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are a few tools at your disposal to look up...
2011-11-01
18 reads
Quick and Dirty Index Info
From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are...
2011-11-01
742 reads
BI Pyramid (read categories of users in a BI solution)
Purpose of any business intelligence solution is to provide users information and enable them to make intelligent decisions that benefit their...
2011-11-01
827 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