4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

milos_radivojevic.jpg

Milos Radivojevic

Milos Radivojevic is a database developer and consultant, speaker, and trainer located in Vienna, Austria. He has been working with SQL Server over 12 years. He is Microsoft SQL Server MVP and MCT and specializes in SQL Server for application developers and performance and query tuning. Currently he works as senior database developer in bwin.party (the largest regulated online gaming company in the world) where he works with some of the largest SQL Server databases. He is co-leader of the SQL Server PASS Austria. He is a speaker in international conferences (SQLBits, SQL Saturday, SQLU Summit) and speaks regularly at SQL Server PASS Austria meetings. He has developed two courses: SQL Server For Application Developers and (for SolidQ) SQL Server 2012 for Experienced Developers and DBAs (Co-author with Herbert Albert and Gianluca Hotz). His Twitter handle is @MilosSQL.

http://www.bwinparty.com http://milossql.wordpress.com/feed

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.
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.
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?
In this session we will advice how to avoid common developer mistakes and show how bad designed queries reduce the SQL Server optimizer's capabilities for choosing an optimal execution plan.

Blog posts RSS

Speaking at SQLBits Superheroes 15 Jan 2015
I am glad to be selected to present an extended version of one of my favorite sessions at SQLBits Superheroes in London (4th – 7th March 2015) about parameter sniffing.

The Schedule of SQL Saturday Vienna 2015 Is Live! 09 Jan 2015
The schedule of SQL Saturday #374 Vienna is live! It was a tough process to select from all these wonderful submissions! Unfortunatly we could not host all speakers, but we decided to limit number of selected sessions per speaker to one in order to get more speakers in Vienna. Here you can see the ...

SQL Saturday Vienna #374 Session Summary 27 Dec 2014
The Call for Speakers for the PASS SQL Saturday #374 Vienna has been closed yesterday, 26.12. 2014. We are really proud to share with you that we have got 98 session abstracts for our event! They have been sent by 34 speakers from 19 countries! That’s really impressive number and we want to ...

Beyond Statistics Histogram – Part 3 (TF 2389 feat. TF 4139) 22 Dec 2014
In the previous article we’ve shown how can we use TF 2390 to handle queries with literals beyond statistics histogram in SQL Server 2012. We saw that SQL Server creates some statistics on the fly for all columns used in filter expressions. If we would enable trace flag on the instance level that ...

Speaking at Deutsche SQL Server Konferenz 2015 in Darmstadt 20 Dec 2014
I am honored  to have been selected to speak at the largest SQL Server conference in the German speaking area “SQL Konferenz 2015“. The 2-day conference will be held from 4 to 5 February 2015, with a pre-con day on 3rd February. I’ll be presenting a session about Key Ascending ...