Understanding Parallel Query Processing in SQL Server 2005
I was having a discussion with a friend the other day on the parallel query processing capabilities available in SQL Server 2005. After the discussion, I was surfing the web for more information when I chanced upon this MSDN link, which sheds insights on parallel query processing capabilities in SQL Server 2005. Check out http://msdn2.microsoft.com/en-us/library/ms178065.aspx
It is nice to see that a similar Volcano-operator has found its way into SQL Server, and is used similarly as a means to construct parallel query plans. As a little note: In fact, parallel query processing techniques have been a very well-studied topic (e.g. [1]) over the years.
References
[1] Parallel database systems: the future of database processing or a passing fad?
- Article by Jim Gray and David Dewitt (famous database researchers within the database community)
It is nice to see that a similar Volcano-operator has found its way into SQL Server, and is used similarly as a means to construct parallel query plans. As a little note: In fact, parallel query processing techniques have been a very well-studied topic (e.g. [1]) over the years.
References
[1] Parallel database systems: the future of database processing or a passing fad?
- Article by Jim Gray and David Dewitt (famous database researchers within the database community)

0 Comments:
Post a Comment
<< Home