O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing parallel query processing methods

In recent times, the processing power of a hardware system has been increased. This helps speed up the processing of large data and data warehouse queries, which can be termed as parallelism. By default, SQL Server utilizes the power of a multi-core hardware platform for a large amount of data management chores. Specifically, in query processing, the CPU is used extensively to perform multiple threads simultaneously. CPU can be a logical process or hyper-threaded cores. In this recipe, we will work on required tasks in implementing parallel query processing methods that can enable database or application tuning to help improve the performance.

Getting ready

In order to set up and get the advantage of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required