DeepDive SQL Performance - Parallel Processing in SQL Server
Duration: 8 hours
What does this course cover?
Officially SQL Server supports parallel queries since SQL 7.0. This might be true, but what if we want to run more queries in parallel? There are several scenarios where such requirements are justified and we can implement them using SQL Server technologies like Service Broker, Powershell, command line scripts etc. This course is intended equally for administrators and developers.
Pre-requisites: What do you need to know?
Experience with SQL Server Analysis Services
WHEN and WHERE is this course running?
Typical maintenance tasks as
- Index maintenance
- Updating statistics
- Reloading database
Developer tasks as
- Monthly batch processing