BT

Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ

Topics

Choose your language

InfoQ Homepage SQL Server 2008 Content on InfoQ

  • MERGE Syntax for SQL Server 2008

    SQL Server 2008 will include new syntax for merging data between two rowsets. The MERGE statement allows developers to use one command to perform deterministic inserts, updates, and deletes on a table based on a source table.

  • Sparse Columns Added to SQL Server 2008

    SQL Server 2008 has lifted the limit of 1024 columns per table with a new option called "sparse columns". While this seems like its excessive, some developers have been running up against this limit.

BT