It's not Business, It's Personal
Hello Dear Reader. I find myself at this late hour unable to sleep. Yesterday the slate of speakers for the...
2014-06-26
857 reads
Finding the last successful CHECKDB
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
3,259 reads
Finding the last successful CHECKDB
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
439 reads
Passion
I know I tend to be overly passionate. It’s something that has gotten me into trouble in the past. It’s...
2014-06-26
859 reads
PASS Summit – What Does It Mean To Me?
PASS Summit – what does it mean to me? So listen, I’m not perfect. I will never claim to be and...
2014-06-26
406 reads
SQL Server 2014 – How to add features to existing instance ?
SQL Server 2014 – How to add features to existing instance ? :-
1) Start installation center
2) Run Global Rule, You need to...
2014-06-26
13,448 reads
SSIS Parent-Child Architecture in Package Deployment Mode
This is the second in a series of posts about SSIS parent-child architecture. You can find the index page here.
In...
2014-06-26
6,183 reads
Entity Framework Fluent API and Indexing
With the release of Entity Framework 6.1 the Fluent API can now be used to create indexes. It’s still pretty...
2014-06-26
150 reads
Speaking at PASS Summit 2014
Achievement unlocked.
I am more than delighted to announce that I was selected to speak at the upcoming PASS Summit 2014...
2014-06-25
147 reads
PASS Summit 2014 – I’m speaking!
On June 25, 2012, I set a goalfor myself. It was this:
In the next 3 years, I want to present...
2014-06-25
693 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