Please note that this website will be temporarily unavailable during the period 5:00 PM PST on Friday, Dec. 19 and 11:59 PM PST on Saturday, Dec. 20 due to a planned server migration. PASS apologizes for any inconvenience.
The Global Hebrew Virtual Chapter is an online gathering place for SQL Server DBAs and Business Intelligence professionals to discuss all things SQL Server in Hebrew language.

Inspired by the PASS SUMMIT 2013, this virtual chapter is about finding a way for DBAs and BI professionals to network virtually in Hebrew language.

Next Meeting

Sun, Jul 20 2014 17:30 UTC


Guy Glantser:How to Use Parameters Like a Pro and Boost Performance

RSVP: https://attendee.gotowebinar.com/register/8027909686918256386

Session Recording: https://attendee.gotowebinar.com/recording/86850783381412354

Guy Glantser 

   Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, in dynamic statements or in ad-hoc queries. Although widely used, most people aren't aware of the crucial influence they have on query performance. In fact, wrong use of parameters is one of the common reasons for poor application performance. In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about the pros and cons of parameter sniffing as well as about simple vs. forced parameterization. But most important – we will learn how to identify performance problems caused by poor parameter handling, and we will also learn many techniques for solving these problems and boosting your application performance.

 Guy Glantser is the leader of the Israeli PASS chapter and also the CEO of Madeira SQL Server Services. His career has been focused on SQL Server for the past 17 years, performing various database roles as either an on-site DBA, an external consultant or an instructor. Guy is involved in many activities in the SQL Server community. He occasionally speaks at community events, such as TechEd, product launches and user groups around the world. He also co-hosts the Israeli SQL Server radio show.

Event Attachments