Israeli SQL Server User Group



Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:





Next Meeting

Next Meeting




Index Fragmentation and Table Variables in SQL Server

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

1. The Truth about Table Variables – Guy Glantser (30 Minutes)

I always tell people to avoid table variables as much as they can. I have good reasons. But recently I discovered a scenario in which a table variable performed better than a temporary table. So I made some more research, I learned some new things, and I would like to share them with you.

2. Index Fragmentation: Internals, Analysis, and Solutions – Paul S. Randal (Remote Session, 90 Minutes)

As soon as you have more than one index on a table, you're going to start seeing fragmentation. Many people know that this fragmentation is bad, but why is it bad? And what is the best way to get rid of it? Come find out from the person who wrote the tools for detecting and removing index fragmentation. In this session, you’ll learn how fragmentation occurs and why the process that leads to it can often be as damaging to performance as the fragmentation itself. You'll also learn how to test for fragmentation, the different methods of removing it, and everything you need to consider when putting together an appropriate fragmentation-management strategy.



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