Walmart Store Openings through Power Map
A couple weeks back, I was taking a look at a map that had been put together on Flowing Data...
2014-02-21 (first published: 2014-02-18)
2,393 reads
PolyBase explained
PolyBase is a new technology that integrates Microsoft’s MPP product, SQL Server Parallel Data Warehouse (PDW), with Hadoop. It is designed to...
2014-02-25 (first published: 2014-02-18)
18,202 reads
Hilux – @BBC #TopGear
May drives a modified Hilux to the rim of that unspellable Icelandic volcano that subsequently shut down Europe’s airspace
via Search...
2014-02-18
355 reads
The CASE Statement and Performance
In case you don’t know, this query:
UPDATE dbo.Test1
SET C2 = 2
WHERE C1 LIKE '%33%';Will run quite a bit slower than this...
2014-02-25 (first published: 2014-02-18)
6,550 reads
Dealing with the mysterious “True” column in BIML
Recently I ran into the following error when compiling BIML into SSIS packages:
The message itself is not very revealing:
The data...
2014-02-18
1,025 reads
Virtual Teams: 3 Ways to Improve Efficiency and Performance #virtual #teams
How to enhance the performance of virtual teams
Virtual teams have some advantages, from allowing the best talent recruitment regardless of...
2014-02-18
477 reads
Create Database Error "operating system error 112(There is not enough space on the disk.)"
I try to create database by generating script of another database, which was a huge Database. When I run the script below
USE [master]
GO
CREATE DATABASE [YourDB] ON PRIMARY
( NAME...
2014-02-18
88 reads
Improving SQL Server Performance by using Instant File Initialization
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-21 (first published: 2014-02-18)
3,641 reads
Why Sales Organizations Fail
Companies face specific challenges at each stage of their lives. This is a great article on why many sales organizations...
2014-02-18
574 reads
How to check for last SQL Server backup
As a database professional, I get asked to review the health of database environments very often. When I perform these...
2014-02-24 (first published: 2014-02-18)
3,128 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