Meet the Geniiius Family
Over the next few weeks / months there will be plenty of opportunities to meet the Geniiius family, since we started...
2012-01-31
1,584 reads
Important SQL Notes collection by Jose Barreto
I have come accross below link while checking options to find top painful mirroring enabled databases.
Looks like there is no single...
2012-01-31
4,585 reads
2012-01-31
9 reads
2012-01-31
8 reads
2012-01-31
8 reads
2012-01-31
33 reads
Detect Worst Performing SQL Queries – Part 2
This series of Videos will walk through how to detect worst performing sql queries which is slowing down Microsoft SQL...
2012-01-31
1,514 reads
Tabular Model
One of the most exciting features in SQL Server 2012 is the introduction of the Tabular Model. The Tabular model...
2012-01-31
3,507 reads
Orlando IT Pro Camp 2012 Presentation
Presentation and scripts from my Storing Powershell Output session at Orlando IT Pro Camp 2012.
2012-01-31
1,786 reads
SQL Server 2012 Express RC
The new version of the lovely SQL Server edition, Express Edition!
Take a look the new link for the download and...
2012-01-31
3,244 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...
Alamat BCA KCP KEM Tower Telp:0821-8200-233
Telp/Wa 628218200233 Kem Tower, Jl. Landas Pacu Barat No.Kav 2 Blok B, RW.10, Gn....
Alamat BCA KCP Harmoni Plaza Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Harmoni Plaza Blok B No. 26-27, Jl. Suryopranoto No.2, RT.2/RW.8, Petojo...
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