powered by Altairis GeekCore - kalendář akcí pro vývojáře a IT profesionály

LAST MINUTE - Advanced Query Tuning Techniques with Guy Glantser

Datum a čas: přidat do kalendářepřidat do kalendáře středa 16. května 2018, 18:00 - 20:00
Místo: Praha - Microsoft
Organizátor: Czech PASS- Czech PASS
Use this link to register!

This meetup will be special. We will welcome Guy Glantser - Data Platform MVP and the leader of the Israeli PASS local group and also the CEO and founder of Madeira Data Solutions. Guy will share with us some Advanced Query Tuning Techniques. That's what he says about his session:

You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now what?

In this session we will analyze common use cases of poorly performing queries, such as improper use of scalar functions, inaccurate statistics and the impact of parameter sniffing. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced but practical techniques. By the end of this session, you'll have many powerful techniques to apply to solving query performance issues.

Sounds interesting, right? Don't hesitate and sign up. Seats are limited!

Level: 300 - 400
Language: English
Duration: ~120 minutes

Místo konání: Praha - Microsoft

Vyskočilova 1561/4a, 140 00 Praha 4

POZOR, Microsoft se od října 2015 přestěhoval!

Stále sídlí v BB Centru, ovšem nikoliv v budově Alpha, ale v budově Delta. Ta se nachází přibližně 200 m na východ od původního sídla.