DeepDive SQL Performance - Parallel Processing in SQL Server

DM-PDDPP-EN

}

Duration: 8 hours

Level: 300

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

“Very interesting insights in this matter!” Rok Knavs

Head of Application Infrastructure, Cejle

WHEN and WHERE is this course running?

Course outline

Key Topics:

Typical maintenance tasks as

  • Index maintenance
  • Updating statistics
  • Reloading database

Developer tasks as

  • Monthly batch processing

All our courses can be offered as a private delivery and tailored for your team's specific needs

Contact us

WHEN and WHERE is this course running next?

Check dates