Fixing SQL Server - iPod
If we will get a new version of SQL Server every 3 years, how can we make the process smoother.
2008-01-29
47 reads
Editorial - iPod
The Mistake - iPod
SQL Server 2008 has been delayed and Steve Jones thinks the entire process of building this version has been poorly handled.editor
2008-01-28
39 reads
Tell Me What You Need - iPod
Ever worked on a software project where you didn't get all the requirements? One where the functions and features change in midstream? Steve Jones comments on some possibilities on why this happens.
2008-01-27
39 reads
2008-01-24
50 reads
The End of Estimation - iPod
How interesting would it be to not have to guesstimate what size server to buy for your next application? Steve Jones may have found a way to help you.
2008-01-23
51 reads
The In-House Expert - iPod
Are specialists worth keeping inside of a company? Or does it pay to hire generalists and then get consultants as needed? Steve Jones comments on the choices you might face as your career grows.
2008-01-22
51 reads
2008-01-21
49 reads
A Pay Raise - iPod
There's a shortage of IT workers, which should lead to a pay raise for some people. Steve Jones takes a look at some recent news about IT salaries.
2008-01-20
39 reads
Testing - iPod
We get tested in a variety of ways before we take a job, but what should be open for examination besides our technical skills? Answer this week's poll with your opinion.
2008-01-17
39 reads
Free and Cool - WMV
Two big events this week captured Steve Jones' attention. A little MySQL and Apple commentary to break up the week.
2008-01-17
49 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
nitazoxanide 500 mg Buy Online - Medzsupplier
Nitazoxanide 500 mg Buy Online is a search term used by people looking for...
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...
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