SQL Server Gems

Friday, December 29, 2006

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)

0 Comments:

Post a Comment

<< Home