Take your T-SQL code to the next level – lessons learned from Czech Savings Bank

Missing indexes, parameter sniffing, UDF functions, nonSARGable predicates, … - who haven’t heard about them? They are and will be the most typical performance killers in many environments. But they are for sure not the only ones which should deserve your attention and where you should stop yourself.

In this session, we will have a look on other not that common mistakes which the presenter – Pavel Málek – encountered during his career in the largest Czech bank. Expect to see not only some real problematic code written by real developers but also theoretical background information about them and underlaying infrastructure. Some of the presented cases can show you how to vastly improve performance of your SQL Server via some unexpected solutions.

Level: 300

Language: Czech