Synonyms in SQL Server – Good and Bad
When SQL Server 2005 was released, a nifty little feature was included called synonyms. Despite being around since SQL Server...
2018-12-14
305 reads
Fun time Friday - A week is a long time in....
A week is a long time in...
SQL Server LandA week is a long time in SQL Server land. This week I have been busy working on a version migration...
2018-12-14
15 reads
Fun time Friday - A week is a long time in....
A week is a long time in...
SQL Server Land
A week is a long time in SQL Server land. This week...
2018-12-14
185 reads
ASF 017: Alex Whittles interview
Introduction Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the...
2018-12-14
209 reads
Setting up CentOS to run docker for SQL Server
This blog post is about running SQL Server in a docker container on CentOS Linux distribution.
This was both an experiment...
2018-12-13
310 reads
Maintenance Plan Owner – Back to Basics
Have you ever taken over a server that had several maintenance plans on it? Have you ever really checked who the owner of those plans is? Or, maybe you...
2018-12-13
57 reads
Maintenance Plan Owner – Back to Basics
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit...
2018-12-13
235 reads
Power BI Monthly Digest – December 2018
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-12-13
591 reads
Difference Between Restore with Recovery & Restore with Norecovery
Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the process of backup. In case of SQL Server, restoration...
2018-12-13
79 reads
Difference Between Restore with Recovery & Restore with Norecovery
Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the...
2018-12-13
44,411 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
Alamat BCA KCP Pasar Kenari Telp:08218200203
Telp/Wa 628218200203 Gedung Sutrado, Jl. Kenari 2 No.5 Lt. 1, RT.2/RW.3, Kenari, Kec. Senen,...
Alamat BCA KCP Biak Telp:08217555651
Telp/Wa 628218200203 Jl. Biak No.44 AB, RT.8/RW.11, Cideng, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Plaza Index Telp:08217555651
Telp/Wa 628217555651 Gedung Plaza Bank Index Ground, Jl. M.H. Thamrin No.57 Floor Suite GF-21,...
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