In-Memory Indexes: SpaceX® Performance!
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.
Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek (24 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, 10 in 2017, 8 in 2018 (Cambridge) and Chicago, Jacksonville, Dallas, Pensacola, Austin, and Baton Rouge in 2019; as well as several local SQL Server user's groups in Ft. Worth, Austin, and San Antonio; and 2 Virtual DBA presentations in 2018.
- Houston SQL Saturday 43 Recordings
- SQL Performance 20 Recordings