Blog Post

Finding Missing indexes

Situation SQL Server registers every missing index. Here is how you retrieve that information from the missing index DMV’s [crayon-5c335dbc1c266788449988/]...

2018-07-07

428 reads

Blog Post

Kubernetes

Have you heard the name Kubernetes, it is another open source in the market by Google and works one Containers,...

2018-07-06

327 reads

Blogs

Are Blogs Still Relevant? I Think They Still Are.

By

As for me, I'll keep writing whenever time permits. I don't expect every post...

Reading Blogs: T-SQL Tuesday #204

By

This is an interesting invitation this month. Jeff Ianucci is a new host, and...

Are Blogs Still Relevant? - T-SQL Tuesday #204

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

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...

Slow - Linked server query

By krypto69

Hi I have this slow query that is pulling data from a linked server....

Too Many Choices

By Steve Jones - SSC Editor

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

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