471,092 Members | 1,050 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

Arrays and lists in SQL 2005

I am glad to announce that there is now a version of my article "Arrays and
Lists in SQL Server" for SQL 2005 available on my web site.

THe URL for the article is
http://www.sommarskog.se/arrays-in-sql-2005.html. If you are curious about
the performance numbers they are in an appendix at

The old version of the aritlce remains, as the new article covers SQL 2005
only. The old version is now at

The old URL, http://www.sommarskog.se/arrays-in-sql.html leads to a page
that links to both articles.

And the reason that there are two articles is simply that SQL 2005 adds
so many new features: nvarchar(MAX), the CLR, the xml data type, CTE that
all can be used in the realm of arrays and lists.
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
Mar 3 '07 #1
1 4235
Great article Erland! The performance analysis is an excellent reading by
itself! Few people would take the time to implement such a detailed test.

Thank you for sharing!

Plamen Ratchev
Mar 4 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

35 posts views Thread by Troll | last post: by
5 posts views Thread by Cant Think Today | last post: by
11 posts views Thread by Soeren Sonnenburg | last post: by
4 posts views Thread by mom_newbie | last post: by
38 posts views Thread by Peteroid | last post: by
4 posts views Thread by bei | last post: by
11 posts views Thread by Hakusa | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.