Parallelism is a key factor in the performance of large queries. It allows SQL Server to perform a large operation quickly and yet at other times can appear to hinder performance. It is a complex topic that can often be difficult to troubleshoot and tune. This session will explain the how parallelism works, why it is good, and when it is bad. Some of the key takeaways will be:
Robert is a Sr. Product Consultant and Chief SQL Server Evangelist for Idera Software. Previously, he was the Program Manager for the SQL Server Certified Master Program in Microsoft Learning. He was also a Sr. Production DBA at Microsoft with more than 12 years’ experience with SQL Server -- author of Pro SQL Server 2008 Mirroring -- writer for SQL Server Magazine -- Microsoft Certified Master: SQL Server 2008 -- Speaker/trainer.