hash and stream aggregation
Duration: 60 minutes
Track: Enterprise Database Administration & Deployment
The session (level 300) will introduce the differences between the hash and stream aggregation.
You will see the differences in terms of the internal algorithm, performance, scalability, hardware consumption and understand the limitations.
In the end of the session you will able to predict which physical aggregate operator SQL Server will implement to run the query and you have learned to implement the right index strategy to boost the query execution.