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
http://www.sommarskog.se/arrays-in-sql-perftest.html.

The old version of the aritlce remains, as the new article covers SQL 2005
only. The old version is now at
http://www.sommarskog.se/arrays-in-sql-2000.html.

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
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
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
http://www.SQLStudio.com
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.