Joe Celko

Arrays in SQL that Avoid Repeated Groups

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

3D Printing Ear Savers Aug 6th 2020

By

I have now printed over 20,000 ear savers. I hit 20k printed yesterday on...

Creating a SQL Clone Agent and a First Image

By

In a previous post, I set up the SQL Clone server. This is really...

Availability Group issues fixed with Alerts

By

Learn how to use the SQL Server Agent Alerting system to capture Availability Group...

Read the latest Blogs

Forums

how to find why the stored procedure took time to execute

By saum70

Hi, This is one of the incident at our clients side and does not...

Using Pivot in SQL

By Mysterio

I am trying to create a query from this table: above is my table,...

Query optimization

By curious_sqldba

Hello..i am running into an issue where below query is requesting large amount of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

BDC Storage

See possible answers