A Scary Comparison
What changes are coming in the editions for SQL Server 2008. Steve Jones finds a rather scary piece of literature.
2008-04-01
40 reads
Editorial - iPod
April Bloopers
Steve takes a day off from the editorials with this blooper reel from the podcasts. Be sure to watch the video.
2008-03-31
32 reads
The Credit Debate
As databases grow, we store more and more types of data. This Friday's poll asks what types of data you don't want to store.
2008-03-27
29 reads
Social Software
More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
2008-03-26
37 reads
Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-25
38 reads
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
2008-03-24
32 reads
A Bad Report Card
The Federal Communications Commission doesn't get a good report on it's data handling and management processes.
2008-03-23
38 reads
Feature (In)Complete
A look at some of the interesting database news from the previous week (March 24, 2008).
2008-03-22
218 reads
2008-03-19
35 reads
Fire Drills
How often do you have those fire drills, testing what you would do in the event of an emergency. Would you be satisfied with a 30% success rate?
2008-03-18
32 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