Parallel Programming SQL Server (edit)

Parallel processing is typically used for

  • Long-running reports
  • Bulk updates of large tables
  • Building or rebuilding indexes on large tables
  • Creating temporary tables for analytical processing
  • Rebuilding a table to improve performance or to purge unwanted rows

The Database Engine can execute different database tasks in parallel. The following tasks can be parallelized:

  •     Bulk load
  •     Backup
  •     Query execution
  •     Indices

The Database Engine allows data to be loaded in parallel using the bcp utility.

Craig Freedman's SQL Server Blog

Data Warehouse Query Performance in SQL Server 2008