“Pretty Plans vs. Performance” or “Grant Gets Pwned”
If you get an execution plan that looks like this:
I wouldn’t blame you for immediately thinking about query tuning. Especially...
2014-12-29 (first published: 2014-12-19)
6,167 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Speaker of the Month: December 2014
For the month of November I was at the PASS Summit and Live360, so I didn’t get to find new...
2014-12-08
553 reads
Speaker of the Month: November 2014
I have been very remiss in my blogging of late. Apologies.
One thing I haven’t blogged about is Speaker of...
2014-12-05
509 reads
PASS Summit 2014 Speaker Idol
For the first time ever at the PASS Summit, a competition was held to select a speaker for the 2015...
2014-11-13
785 reads
I’m Still Not on the Board
I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different....
2014-11-11
701 reads
PASS Summit 2014: WIT Luncheon
Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time...
2014-11-06
627 reads
Database Lifecycle Management
There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every...
2014-10-31 (first published: 2014-10-20)
6,999 reads
Navel Gazing
I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to...
2014-10-17 (first published: 2014-10-12)
6,606 reads
Why Haven’t You Changed Everything?
The first in what I hope will be many regular reports on what I’m doing on the PASS board.
To answer...
2014-10-17
604 reads
Query Performance Tuning in SQL Server
I have a pre-con coming up at the PASS Summit. You can read about it here. I named it “Query...
2014-10-16
685 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