It's a pretty vast topic. Look for "parallel queries" in SQL Server Books Online. It works exactly as it does in Oracle but there are differences in terms of configuration options like indexes in SS2k cannot be set with different parallel options like they can in Oracle but you can use query hints and 4 configuration parameters to play around with this.