Arrays and Lists in SQL Server

An SQL text by Erland Sommarskog, SQL Server MVP.

There are three versions of this article:

• Arrays and Lists in SQL Server 2008 (Using Table-Valued Parameters). This version is devoted entirely to table-valued parameters.
• Arrays and Lists in SQL Server 2005 (When TVPs Do Not Cut it). This version cover all other methods than TVP in SQL 2005 and later.
• Array and Lists in SQL Server 2000 and Earlier.

To this come two performance appendixes to the first two articles:

• Arrays and Lists in SQL Server, Data from Performance Tests in SQL 2005.
• Arrays and Lists in SQL Server, Data from Performance Tests in SQL 2008.

The appendixes are not identically written, and you would need to read both to get all conclusions. Data for performance tests for SQL 2000 is within that article.

Back to my home page.