Tips for Attending a SQL Saturday
Matt (blog | twitter) is preparing for his first SQL Saturday presentation next weekend in Washington, DC. He’s asked:
I wanted to get an idea of some good, bad, and...
2018-11-29
22 reads
New Resumable Online Index Create SQL Server 2019
SQL Server 2019 brings a very exciting new feature that, is long overdue. Resumable online index create is one of...
2018-12-13 (first published: 2018-11-28)
2,271 reads
Adding the Constraint Name to the PK at the End of Create Table–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-17 (first published: 2018-11-28)
2,862 reads
Price increase for Azure in Canadian dollars
On 1 December 2018, Microsoft is increasing Azure subscription prices in Canadian dollars by 5%. The following is taken directly...
2018-11-28
251 reads
A curious case of case when and Null values
For some reason I have always written my Case statements using the following logic:
SELECT
CASE
WHEN @Priority = 1 THEN 'Very High'
WHEN @Priority...
2018-12-12 (first published: 2018-11-28)
2,839 reads
How to be an MVP Book
When it comes to characteristics of an MVP, the two groups (geek and jock) are no longer at the opposite ends of the spectrum. Rather, they are very similar...
2018-11-28
12 reads
How to be an MVP Book
How to be an MVP in LIFE
One of the fun things about being involved in the community is the opportunity...
2018-11-28
303 reads
Oh Query, Query, Query
I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week.
I...
2018-12-18 (first published: 2018-11-28)
2,761 reads
Early Bird SQL Bits Pricing
You can register today and save for the next few days. It’s only £799 for the full SQL Bits 2019...
2018-11-28
322 reads
Gathering all the Logs and Running the Availability Group Failover Detection Utility with PowerShell
30/11/2018 – Function has been updated to deal with named instances.
Last week the Tiger Team released their Availability Group Failover Detection...
2018-12-17 (first published: 2018-11-28)
2,003 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