Israeli SQL Server User Group

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:

            Microsoft

         PASS

            

            

Next Meeting

Next meeting

Monday,

August

06

Database Hardware for OLTP Performance and the Truth about Table Variables

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

1. Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance – Glenn Berry (90 Minutes)

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you!

This session covers current and upcoming hardware from Intel and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

2. 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.

 

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