Get Out There and Challenge Yourself
It’s been almost five months since I posted my last article, and so much has changed since then. I have...
2015-02-11 (first published: 2015-02-03)
6,581 reads
TSQL Tuesday #63 – How do you manage security?
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2015-02-03
931 reads
POSTPONED to 02/11 - Speaking at the Omaha SQL Server User Group *Tomorrow* Night!
UPDATE - due to weather conditions today (snow this AM and sub-zero cold tonight) we are postponed to next Wednesday 02/11...
2015-02-03
921 reads
The most recent backup problem
When I first began this blog, back at the beginning of my DBA career, it was purely a place for...
2015-02-03
682 reads
Parsing SQL Saturday Data – Getting the Titles
I wrote about downloading the SQL Saturday data with Powershell, and that has worked well. However, I also need to...
2015-02-02
934 reads
PowerPoint Slides Available for Download
I promised that I would post the slide decks for my presentations, and now I have finally followed through on...
2015-02-02
695 reads
Blame it on Connect
Some weeks ago I blogged about the discouraging signals coming from Connect and my post started a discussion that didn’t...
2015-02-02
563 reads
T-SQL – Query to get Distinct,Sorted, Comma Separated values in to a variable
CREATE TABLE #temp(name char(3))
INSERT INTO #temp VALUES ('CD')
,('AB')
,('LM')
,('BC')
,('GH')
,('KJ')
,('AB')
DECLARE @cols AS NVARCHAR(MAX);
SELECT @COLS = substring(list, 1, len(list) - 1)
FROM (SELECT list =
(SELECT DISTINCT...
2015-02-10 (first published: 2015-02-02)
10,414 reads
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not have system database & your MSDB got corrupted then...
2015-02-02
17 reads
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not...
2015-02-02
10,584 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
nitazoxanide 500 mg Buy Online - Medzsupplier
Nitazoxanide 500 mg Buy Online is a search term used by people looking for...
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...
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