Blog Post

SQL Server Quick Tips

Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...

2019-09-24 (first published: )

1,012 reads

Blog Post

SQL Server Quick Tips

Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...

2019-09-17

9 reads

Blog Post

SQL Server Quick Tips

Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...

2019-09-17

18 reads

Weekly reading #26

Good morning! It was a tough weekend as we supposed to be in Goteborg on #SQLSatGothenburg but unfortunatelly the flu hit us hard. The talk was handed over by...

2019-09-17

19 reads

Weekly reading #26

Good morning! It was a tough weekend as we supposed to be in Goteborg on #SQLSatGothenburg but unfortunatelly the flu hit us hard. The talk was handed over by...

2019-09-17

40 reads

Blog Post

The "Go Pack"

I’ve found myself traveling quite a bit this year, with more travel on the horizon. Like many, I travel with a fair bit of technology and of course that...

2019-09-17

11 reads

Blogs

Paginated Reporting at Scale: Choosing the Right Microsoft Platform

By

"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...

The Book of Redgate: Fun with Images

By

We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...

Why companies use Palantir and how we help implement it in the Czech Republic

By

Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

Too Many Choices

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Too Many Choices

Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)

By sabyda

Comments posted to this topic are about the item Table Partitioning in SQL Server:...

Visit the forum

Question of the Day

Too Many Choices

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola
I run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;

See possible answers