Milos Radivojevic is database consultant located in Vienna, Austria. He is Head of MSSQL Database Engineering at Entain. He is very active in the SQL Server community: he is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of three SQL Server books: Mastering SQL Server 2017, SQL Server 2017 Developer’s Guide and SQL Server 2016 Developer’s Guide.
Milos Radivojevic's Sessions
TSQL Performance TipsSQLBits 2012
SQL Server optimizer doesn't use and index seek for execution of your query although the query is high selective? What is better, when and why: LIKE vs: SUBSTRING, IN vs. EXISTS, SUBQUERY vs. JOIN. Why you should not use the UPPER or LOWER functions?
TSQL Performance TipsSQLBits 2012
SQL Server optimizer doesn't use and index seek for execution of your query although the query is high selective? What is better, when and why: LIKE vs: SUBSTRING, IN vs. EXISTS, SUBQUERY vs. JOIN. Why you should not use the UPPER or LOWER functions?
Parameter Sniffing Problem with Stored ProceduresSQLBits 2011
In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
Parameter Sniffing Problem with Stored ProceduresSQLBits 2011
In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
Parameter Sniffing Problem with Stored ProceduresSQLBits 2011
In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
Parameter Sniffing Problem with Stored ProceduresSQLBits 2011
In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
TSQL Performance RecommendationsSQLBits 2011
In this section we will show how to avoid performance problems caused by poor query design (functions in WHERE clause, data type conversions…) and explain how local variables and parameters affect the generation of execution plan.
TSQL Performance RecommendationsSQLBits 2011
In this section we will show how to avoid performance problems caused by poor query design (functions in WHERE clause, data type conversions…) and explain how local variables and parameters affect the generation of execution plan.
TSQL Performance RecommendationsSQLBits 2011
In this section we will show how to avoid performance problems caused by poor query design (functions in WHERE clause, data type conversions…) and explain how local variables and parameters affect the generation of execution plan.
TSQL Performance RecommendationsSQLBits 2011
In this section we will show how to avoid performance problems caused by poor query design (functions in WHERE clause, data type conversions…) and explain how local variables and parameters affect the generation of execution plan.