2018-11-19
5 reads
T-SQL Tuesday 108 – A poetic summary
This is November and T-SQL Tuesday time,
I hope you are ready to read the summary – I am the host and...
2018-11-19
188 reads
PASS Summit 2018 - Photos
My album of people and events at Summit 2018. Somehow a number of photo opportunities were missed!
[foogallery id=“1880”]
2018-11-19
9 reads
T-SQL Tuesday 108 – Learning R
I am the proud host of TSQL Tuesday for the month of November 2018.
My call to post entries is here ....
2018-11-28 (first published: 2018-11-18)
2,244 reads
Last week reading (2018-11-18)
No, you don’t need a blockchain Thomas LaRock (T) says: “Don’t buy a blockchain solution unless you know for certain...
2018-11-18
220 reads
Part 2: Predictive Modeling using R and SQL Server Machine Learning Services
Deploy Machine Learning code with SQL Server
2018-11-18
28 reads
Part 2: Predictive Modeling using R and SQL Server Machine Learning Services
Recap!
Part 1 of Predictive Modeling using R and SQL Server Machine Learning Services covered an overview of Predictive Modeling and the...
2018-11-27 (first published: 2018-11-18)
3,732 reads
How to Find SQL Server Performance Bottlenecks and Fix These Issues
SQL Server is undoubtedly a popular way to manage database. Due to its efficiency, business organizations largely depend on this for data management. This dependency often causes performance bottlenecks...
2018-11-17
70 reads
How to Find SQL Server Performance Bottlenecks and Fix These Issues
SQL Server is undoubtedly a popular way to manage database. Due to its efficiency, business organizations largely depend on this...
2018-11-17
16,625 reads
How to Write a Better T-SQL Code
Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers. Always Use a...
2018-11-17
70 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