Speaker of the Month, February 2014
I didn’t get out to many events in January, so I was somewhat limited in the pool of presenters that...
2014-02-07
711 reads
Nadella, Gates: Right Team For Microsoft? – InformationWeek
Does the pairing of Nadella and Gates foretell Microsoft’s return to glory or a new era of dysfunction? Take a...
2014-02-07
951 reads
Friday Followup For February 7, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-02-07
445 reads
Parent-Child SSIS Architecture
This is the first in a series of technical posts on using parent-child architectures in SQL Server Integration Services. The...
2014-02-07
2,219 reads
What Drives Microsoft’s Data Platform Vision?
FEATURED POST BY: Quentin Clark, Corporate Vice President, The Data Platform Group, Microsoft Corporation
If you follow Microsoft’s data platform work,...
2014-02-07
1,530 reads
MDX+SSAS #37–Ignore unrelated dimension or not
In Adventure Works cube 2008 or 2012, in the Dimension Usage tab, you will see that many intercepts of measure...
2014-02-07
2,552 reads
SQL Server Diagnostic Information Queries for February 2014
I improved the file-level latency query this month and made some other small improvements to a few other queries. Rather...
2014-02-06
1,187 reads
Murder in Richmond
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2014-02-06
6 reads
Murder in Richmond
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-02-06
828 reads
Rollback DBCC CHECKDB REPAIR !
I learned something new today while I was listening to one of the courses on corruption authored by the master,...
2014-02-06
1,590 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