Arrays

Arrays in SQL that Avoid Repeated Groups

  • Article

It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would be the best design. Most often, the wish for an array in SQL is a sign of a forlorn struggle against poorly-normalised data. One of the worst sins against Codd is the repeating group, as Joe Celko explains.

2011-07-20

3,438 reads

Blogs

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 24 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 SQL Server session preview

By

Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...

Read the latest Blogs

Forums

Where do I start from ?

By Corobori

Following with a user complain about SQL timeout I bumped into one issue with...

Function Code

By sizal0234

Hi, I have a fn with below code I want to understand the highlighted...

Backup size

By caz100

Hi Is it possible to have a database size showing 75 gigs and then...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers