Turning Off Logging
I'm sure that most of you know that you cannot turn off logging in SQL Server. You can minimize the...
2007-12-17
1,452 reads
Lists of Tools
I ran across this list of interesting tools by Scott Hanselman and there is some good stuff to look at...
2007-12-14
1,376 reads
Google Knol As Community Competitor?
I ran across this in the Google bloghttp://googleblog.blogspot.com/2007/12/encouraging-people-to-contribute.html announcing a new beta feature called Knol that allows an author to...
2007-12-14
1,687 reads
Finding the relationship of a filegroup and a partition
The other day, I was trying to find out which partition is on which filegroup for a a partitioned table....
2007-12-12
1,612 reads
12000!
A short congratulations to myself. I was answering posts last night after tech editing another chapter of the book I'm...
2007-12-12
1,492 reads
Driving Debate
I write a daily editorial, which is one of the reasons that I don't post here as often as I'd...
2007-12-11
1,407 reads
Managing Funds for User Groups
This question seems to come up a lot and it's worth discussing. Few user groups are incorporated, fewer still are...
2007-12-11
653 reads
Podcasting
A new video setup is on the way!!!!
Actually I'll do a couple podcasts on podcasting over the holidays here since...
2007-12-10
3,052 reads
Disappearance
Wow, it's been a long time since I posted here. I actually had to search for my name to find...
2007-12-10
670 reads
How do you make a Wiki work?
Following up on my post about Wikipedia, I read an article in Eweek, 25 Tips for a Better Wiki Deployment...
2007-12-09
642 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 Batu Ceper Telp:08218200203
Telp/Wa 628218200203 Jl. Batu Ceper No.18 A-B, RT.1/RW.2, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP Kartini Telp:08218200233
Telp/Wa 628218200233 Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, RT.3/RW.2, Kartini,...
Alamat Bank BCA Wisma 46 Telp:08217555651
Telp/Wa 628217555651 Wisma 46 Lantai Dasar, Jln. Jend. Sudirman Kav. 1, RT.5/RW.3, Senayan, Kec....
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