Bloated
What is going on with all this production data? Steve Jones talks about the need to manage data growth and is it really worth the resources.
2008-04-13
28 reads
Editorial - iPod
Behind the Curtain
Commentary on the database related news of the past week. SQL Server 2008 Certification, deep inside SQL Server and the Library of Congress.
2008-04-12
27 reads
Historical Dollars
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
2008-04-10
36 reads
The Social Mesh
Steve Jones talks about some research from Dr. Cross, a professor from his alma mater, into social networks and how work gets done in a company.
2008-04-09
28 reads
The Feature Debate
Is SQL Server keeping up with MySQL or is it the other way around. Steve Jones comments on a few of the differences in the platforms.
2008-04-08
30 reads
Securing Data
It's important that you do more than just implement perimeter security with firewalls. Steve Jones talks about how we can better secure our systems.
2008-04-07
27 reads
The Cost of Support
Microsoft is not planning on releasing Service Pack 3, but what is the best model for supporting software? Steve Jones gives a few thoughts.
2008-04-06
29 reads
Windows 7 and More
A look back at the news of the past week including Windows 7, SSD performance, April Fools, and consistency in SQL Server.
2008-04-05
229 reads
2008-04-03
521 reads
Try To Be More Inefficient
Steve Jones is recommending that you don't work the most efficient way at your job. Sometimes.
2008-04-02
28 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