embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

In-Memory Indexes: SpaceX® Performance!

Speaker:

Mike Byrd

Abstract:

This session does an in-depth dive into hash, range, and columnstore indexes in the in-memory environment. It will be about 25% presentation and 75% demos with emphasis on when and how to apply in-memory indexes for stated environments/scenarios. The demos will include performance comparisons to similar disk based indexes as well as the cost in RAM for the in-memory tables and storage memory for the equivalent disk based indexes. Performance is everyone’s goal, and this session will boast your in-memory performance to Falcon Heavy® performance.

Bio:

Former rocket scientist and USAF Fighter Pilot — now a SQL Server geek (22 years). Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies. Presenter at 17 SQL Sat sessions in 2016 plus 10 in 2017. Presented TSQL Precon at Dallas SQLSaturday 2015. Instructed several TSQL classes to private businesses including Advanced TSQL class to Solarwinds Corp, Austin, TX last year. Currently performing DBA/Developer work for several clients. Specialties: SQL Server performance tuning; TSQL/DBA mentoring

Recorded At:

SQL Saturday 766 Houston 2018

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>