So then, what’s the definition of an object……..?
Not blogged for a while due to client and project commitments but something which has surprised me when speaking with...
2012-01-25
599 reads
Improving cube processing time
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and...
2012-01-25
11,382 reads
Windows 8 Easy Refresh?
I saw this write up about the built in ability to both restore to factory settings as well as just...
2012-01-25
664 reads
Venting Frustration
We as DBA’s face an ever growing list of things to do and services to support. We work in high...
2012-01-25
600 reads
Notes from 'Putting a Better SQL Server in Production' - the Ideal Pre-Prod checklist from Robert L. Davis
Last week, I sat in on Putting a Better SQL Server in Production - this is an ideal pre-prod checklist from...
2012-01-25
1,334 reads
Congratulations to Philippe Falardeau for Monsieur Lazhar's Oscar Nomination (Played by Fellag, the Algerian Comedian Famous For Le Visa)
Congratulations to Philippe Falardeau - he has made the official Oscar Nominations!
http://www.monsieurlazharmovie.com/tourné à Montréal – Filmed in Montreal! The hilarious Algerian comedian...
2012-01-25
2,744 reads
Windows Phone 7 and epic efforts to publish applications
Reblogged from betim drenica's blog:
There is plenty of time I am developing applications for Windows Phone and…
tools are great (aka...
2012-01-25
1,212 reads
Windows Phone 7 and epic efforts to publish applications
Reblogged from betim drenica's blog:
There is plenty of time I am developing applications for Windows Phone and… tools are great...
2012-01-25
1,379 reads
About those backups...
So I went to present at Charleston PASS on Thursday night and of course I had my standard contact information...
2012-01-30 (first published: 2012-01-25)
2,011 reads
Nothing Changes If You Don't Volunteer
http://www.flickr.com/photos/cubagallery/4690390650/
Hello Dear Reader, last time on Day's of Our Lives there was an election, some people resigned, and other's...
2012-01-25
803 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
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
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