Friday, August 8, 2008
SQL Server 2008 RTM
MS SQL Server 2008 just went Release-To-Manufacturing. It's pretty exciting because it features the MERGE statement, the FileStream data type and, the single most cool feature, array parameters.
There's a lot of code out there using a CSV string as a parameter to obtain multiple parameters. Splitting the CSV string in T-SQL is very inelegant and reduces performance a bit. Native support for array parameters will lead to improved performance and will also get the ORMs out there to generate more efficient code, as they usually avoid the CSV string trick and go with dynamic SQL leading to parsing overhead for the SQL statement.