Default Instance Reports – Configuration Changes History
Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured...
2017-08-02 (first published: 2017-07-17)
1,394 reads
SQLStudies
Default reports in SSMS
As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are...
2017-07-27 (first published: 2017-07-13)
2,637 reads
Save and save often
It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday!...
2017-07-11
444 reads
What is the system_health extended events session?
Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about...
2017-07-19 (first published: 2017-07-05)
2,164 reads
SQL Homework – July 2017
For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a...
2017-07-03
413 reads
SQL Crossword : T-SQL Keywords : June 2017
I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked...
2017-07-07 (first published: 2017-06-28)
2,435 reads
Temp table quiz
Brent Ozar (b/t) posted a pop quiz on twitter earlier today.
Go ahead and give it a shot .. I’ll wait.
So?...
2017-06-26
678 reads
Dynamically generate the command line DMA statement for each database
If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run...
2017-06-21
661 reads
Adding Identity to an existing column
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He...
2017-06-19
2,973 reads
Turning ANSI_PADDING off, and why you shouldn’t
I ran into an interesting error the other day while doing a partition switch.
Partition switch failed because : column ‘xyz’...
2017-06-26 (first published: 2017-06-15)
3,182 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