Matt Zakrzewski

SQL CLR Data Types and Performance

Using SqlTypes can have a significant impact on the performance of your SQL CLR implementations. Is it for the better? Read this article to find out.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(30)

You rated this post out of 5. Change rating

2010-07-21

8,224 reads

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

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

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

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

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

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

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;