Getting Started With R In SQL Server 2017
Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment...
2018-03-22 (first published: 2018-03-13)
4,332 reads
Allowing Azure Service to Connect to your Azure SQL server.
Allowing Azure Service to Connect to your Azure SQL server.
In this video David will look at the impact of allowing...
2018-03-23 (first published: 2018-03-13)
1,719 reads
A look back from the future. – TSQL Tuesday #100
The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact...
2018-03-13
295 reads
T-SQL Tuesday #100!
The monthly blog party is back and we’ve reached the mythical number 100. The host of this month is the...
2018-03-13
309 reads
Using Stored Procedures in SQL Server For Better Performance
Intoduction to Stored Procedures in SQL Server
SQL Server uses Different types of stored procedures. They are the quickest method of accessing and manipulating database on the server. SPs are...
2018-03-13
19 reads
Using Stored Procedures in SQL Server For Better Performance
Intoduction to Stored Procedures in SQL Server
SQL Server uses Different types of stored procedures. They are the quickest method of...
2018-03-13
729 reads
Crystal Balls
In the centenary edition of the monthly blogging party that is T-SQL Tuesday, Adam Machanic asks us to look forward...
2018-03-13
343 reads
Full Automatic Tuning: SQL Server 2026’s Most Killer Feature
This post is a response to this month’s T-SQL Tuesday #100 prompt by the creator of T-SQL Tuesday himself, Adam Machanic. ...
2018-03-13
283 reads
Full Automatic Tuning: SQL Server 2026's Most Killer Feature
This post is a response to this month's T-SQL Tuesday #100 prompt by the creator of T-SQL Tuesday himself, Adam Machanic. T-SQL Tuesday is a way for SQL Server bloggers...
2018-03-13
17 reads
Full Automatic Tuning: SQL Server 2026's Most Killer Feature
This post is a response to this month's T-SQL Tuesday #100 prompt by the creator of T-SQL Tuesday himself, Adam Machanic. T-SQL Tuesday is a way for SQL Server bloggers...
2018-03-13
17 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