Changing Your SQL Server Name
Reading Time: 2 minutesIs the name of your SQL Server correct?
Why Worry About The Server Name In SQL?
When the name...
2014-10-31
1,025 reads
Changing Your SQL Server Name
Is the name of your SQL Server correct?
Why Worry About The Server Name In SQL?
When the name of the actual...
2014-10-31
1,691 reads
Summit and something new…
Let me just say, I’m excited.
First of all, can you believe that the PASS Summit is next week? Next. Week.
Are...
2014-10-31
908 reads
I Won’t Be At the PASS Summit This Year
Due to a minor health issue I’ve decided to – for once – be conservative and cancel the trip this year. I’ve...
2014-10-31
1,282 reads
Friday Followup For October 31, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-10-31
868 reads
Lightning Talks at SQL Saturday?
We’re already in the early stages of preparing for our 2015 SQL Saturday. One thing that was missing from this year’s event was local speakers; we just didn’t have...
2014-10-31
18 reads
How to take Transaction Log backup ? TIP# 68
As we discussed in earlier tips how to take full backup and differential backup now in this tip we will...
2014-10-30
918 reads
How to Configure Search in SharePoint 2013 || Configure Search Topology in SharePoint 2013
Hello Friends,
I was getting lot of responses on blogs and mails. It will be difficult to cover all at once...
2014-10-30
1,995 reads
SQL Pass Summit 2014
Next week I will be in Seattle for the 2014 SQL Pass Summit event. If you are involved in projects...
2014-10-30
1,167 reads
Sort – Is it Really a Blocking Iterator?
SQL Server has two types of execution plan iterators: Blocking and Non-Blocking.
A non-blocking iterator gets rows in and sends rows...
2014-10-30
1,330 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