Israeli SQL Server User Group

 

 

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:

            Microsoft

         PASS

            

            

Next Meeting

Next Meeting

Monday,

June

05

June 2017 Usrael Usersgroup Meetup

  • In-Person @ 2 HaPnina St. Raanana, HaSharon, Israel (map)
  • 17:30 - 20:00 Jerusalem Daylight Time
  • Language: English

1.  Is It Sargable or Not? – Maria Zakourdaev (60 Minutes)

Do you think you know how to write good queries? Are your queries sargable?

A query, failing to be sargable, typically has a negative effect on query execution time. In this session we will talk about this important phase of query optimization – how to convert queries to be sargable.

2.  NOLOCK Surprises – Alex Friedman (45 Minutes)

NOLOCK is the magic turbo button that's making your queries faster. You know that it can get you some dirty data, but that's just the tip of the iceberg. In this session, Alex will take you on a guided tour of the murky depths of NOLOCK, and you will experience firsthand all the nasty surprises it has in store. If you have ever used NOLOCK in a query, this session is for you




  • 1.  Is It Sargable or Not? – Maria Zakourdaev (60 Minutes)

    Do you think you know how to write good queries? Are your queries sargable?

    A query, failing to be sargable, typically has a negative effect on query execution time. In this session we will talk about this important phase of query optimization – how to convert queries to be sargable.

    2.  NOLOCK Surprises – Alex Friedman (45 Minutes)

    NOLOCK is the magic turbo button that's making your queries faster. You know that it can get you some dirty data, but that's just the tip of the iceberg. In this session, Alex will take you on a guided tour of the murky depths of NOLOCK, and you will experience firsthand all the nasty surprises it has in store. If you have ever used NOLOCK in a query, this session is for you

  • 1.  Is It Sargable or Not? – Maria Zakourdaev (60 Minutes)

    Do you think you know how to write good queries? Are your queries sargable?

    A query, failing to be sargable, typically has a negative effect on query execution time. In this session we will talk about this important phase of query optimization – how to convert queries to be sargable.

    2.  NOLOCK Surprises – Alex Friedman (45 Minutes)

    NOLOCK is the magic turbo button that's making your queries faster. You know that it can get you some dirty data, but that's just the tip of the iceberg. In this session, Alex will take you on a guided tour of the murky depths of NOLOCK, and you will experience firsthand all the nasty surprises it has in store. If you have ever used NOLOCK in a query, this session is for you

 

 

Israel Blogging Community:

Guy Glantser Dubi Lebel Matan Yungman Meir Dudai Geri Reshef Maria Zakourdaev Noam Brezis Eitan Blumin Asaf Aviv Michael Zilbershtein Itai Binyamin Ronen Ariely Pini Krisher

 

 

SQL Joke of the month:

DBAs make the best husbands. They understand relationships and know how to commit

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids