BEGIN:VCALENDAR VERSION:2.0 PRODID:-//SQLBits/com CALSCALE:GREGORIAN METHOD:PUBLISH X-MS-OLK-FORCEINSPECTOROPEN:TRUE BEGIN:VEVENT DTSTART:20120331T095000Z DTEND:20120331T105000Z LOCATION:SQLBits Conference - Reims SUMMARY:TSQL Performance Tips DESCRIPTION:SQL Server optimizer doesn't use and index seek for execution of your query although the quer 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? How to avoid non-SARG-able WHERE clauses? Which query takes about 3 minutes in SQL Server 2008 and only one second in SQL Server 2012?

In this session we will answer these questions and show how bad designed queries lead to poor execution plans. We will offer recommendations and tips 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. We will discuss and compare different query approaches and operators (IN vs. EXISTS, EXISTS vs. COUNT(*), UNION vs. UNION ALL, IN vs. BETWEEN…)  and give appropriate recommendations. We’ll also cover database constraints from the performance point of view. X-ALT-DESC;FMTTYPE=text/html:

TSQL Performance Tips

SQL Server optimizer doesn't use and index seek for execution of your query although the quer 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? How to avoid non-SARG-able WHERE clauses? Which query takes about 3 minutes in SQL Server 2008 and only one second in SQL Server 2012?

In this session we will answer these questions and show how bad designed queries lead to poor execution plans. We will offer recommendations and tips 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. We will discuss and compare different query approaches and operators (IN vs. EXISTS, EXISTS vs. COUNT(*), UNION vs. UNION ALL, IN vs. BETWEEN…)  and give appropriate recommendations. We’ll also cover database constraints from the performance point of view.

Milos Radivojevic

Milos Radivojevic is a database developer and consultant, speaker, and trainer and is located in Vienna, Austria. He has been working with SQL Server over 10 years. He is MCT and MCITP for SQL Server 2008 and specializes in SQL Server for application developers and performance and query tuning.In March 2013 he joined bwin.party's database development team.

http://www.bwinparty.com UID:SQLBITS1358SEQUENCE:0 DTSTAMP:20130620T023849Z END:VEVENT END:VCALENDAR