Decree: Set your partition offset and block size – make SQL Server faster
If I’ve said it once, I’ve said it 1,024 times: your SQL data and log drives need a 1024 KB...
2014-04-07
1,503 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-07
334 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-07
518 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-15 (first published: 2014-04-07)
3,338 reads
SSIS XML Task
The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML....
2014-04-07
450 reads
SSIS XML Task
The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML....
2014-04-14 (first published: 2014-04-07)
3,409 reads
Help! I'm stuck in Single User Mode and can't get out!
So, here’s a silly little take on a serious end-user issue where no-one could access the production database.
Got a call...
2014-04-10 (first published: 2014-04-07)
124,806 reads
I'm Speaking at SQL Saturday Houston, May 10th.
I will be speaking at my first SQL Saturday. I'll be in Houston May 10th. I'm rather surprised to be...
2014-04-07
582 reads
SQL Server licensing consideration
You might already read lots of post about SQL server 2012 is license per core rather then per socket and...
2014-04-07
525 reads
SQL Saturday Exeter
A couple weeks back was the second SQL Saturday to be held in Exeter. Although I wasn’t speaking this time,...
2014-04-07
576 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
Alamat BCA KCP Pasar Kenari Telp:08218200203
Telp/Wa 628218200203 Gedung Sutrado, Jl. Kenari 2 No.5 Lt. 1, RT.2/RW.3, Kenari, Kec. Senen,...
Alamat BCA KCP Biak Telp:08217555651
Telp/Wa 628218200203 Jl. Biak No.44 AB, RT.8/RW.11, Cideng, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Plaza Index Telp:08217555651
Telp/Wa 628217555651 Gedung Plaza Bank Index Ground, Jl. M.H. Thamrin No.57 Floor Suite GF-21,...
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