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 SQLSaturday Slovenia 22 Nov 2014
I’m proud to announce that I will present at SQLSaturday Slovenia on December 13th, 2014. This time I will talk about Hekaton topic. The session name is “SQL Server 2014 In-Memory OLTP Challenges for Developers”. This will be second SQLSaturday conference in Slovenia. I was ...

Beyond Statistics Histogram – Part 1 18 Nov 2014
In this article I will start to examine estimations and execution plans for queries that compare values in columns with literal values which are beyond the statistics histogram for that column. The problem is also known as key ascending column statistics problem. As in previous posts we remain here ...

A Funny Bug with New CE or Introduction to Out-of-Histogram Estimations 11 Nov 2014
Since the release of SQL Server 2014 you can find several articles and blog posts about the changes in the new redesigned cardinality estimator. An excellent and detailed guide about the changes in the new CE you can find in the white paper Optimizing Your Query Plans with the SQL Server 2014 ...

New Cardinality Estimator Part 8 – Bug No. 2 06 Nov 2014
In this article I will describe another query pattern where new CE in SQL Server 2014 brings significant regression. And, similar to the case in this post I would interpret the behavior of new cardinality estimator in this case as a bug, too. Let’s recreate our usual sample table and populate it ...

SQL Saturday Vienna On 28th February 04 Nov 2014
Now it is official: SQL Saturday will return to Austria on Feb 28th 2015! And this time it us indeed a Saturday. Stay tuned for another ‪#‎sqlsatVienna‬!