Certifiable?
I have recently begun to contemplate pursuing the MCSA Certification. I have been working with SQL Server for almost 20...
2013-05-17
635 reads
SQLSaturday #220 Atlanta
From the tweets, it looks like there will be about 800 attendees sitting in on 11 different tracks with 5...
2013-05-17
519 reads
Indexes – Unused and Duplicates
Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table...
2013-05-16
1,737 reads
SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?
This is my first SQLSaturday and I’m super excited to attend this event.
SQLSaturday’s are always a great opportunity to learn something exciting,...
2013-05-16
637 reads
Virtualization Networking Tips for SQL Server 2012 AlwaysOn
A while back Kendal Van Dyke (b | l | t) asked me a great question regarding the ideal VMware vSphere networking...
2013-05-16
1,536 reads
Parameterizing an Excel Spreadsheet
I’ve had a few discussions in the past week about not only including Excel spreadsheets on PerformancePoint dashboards, but specifically...
2013-05-16
3,033 reads
When the person you hire is not the person you hire
This is something I just heard about recently, but then experienced it for myself.
This story was told to me: A...
2013-05-16
895 reads
My 2013 SQL Saturday Schedule!
I’ve finally gotten my gear together for (what I consider) the “speaking season”. Here are the SQL Saturdays that I’m...
2013-05-16
618 reads
Bill Gate’s speech
One of my friend shared this content. I’m just sharing with you all.Good one and I like it pretty much!!!!Bill...
2013-05-16
618 reads
Len() and DataLength()
Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main difference of those 2 is that Len() gets the...
2013-05-16
19 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