Israeli SQL Server User Group

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:

            Microsoft

         PASS

            

            

Next Meeting

Next meeting

Monday,

July

02

T-SQL Ordering Woes – Itzik Ben-Gan

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

There are cases where you create indexes to support query elements that rely on order, but the optimizer seems to not realize this, and ends up applying a sort.
This session demonstrates a number of such situations and provides workarounds that enable the optimizer to rely on index order and this way avoid unnecessary sorting.
 

 

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