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

SQL Server 2014 In Memory technologies – In Memory OLTP (aka Hekaton) & ColumnStore

Speaker:

Reinaldo Kibel

Abstract:

With the advent of new hardware servers with hundreds of Gigabytes of RAM memory and incredibly faster CPUs with multi-core dies Microsoft has catapulted SQL Server above competitors with some new In Memory technologies. Did you ever want to have no locking, no blocking, no latch? For highly transactional systems, In Memory OLTP can boost performance 10x by hosting a table in memory and compiling the stored procedure in C code/DLL. Did you ever wanted to have queries return blazing fast for slow changing data? Updatable ColumnStore index allows for quick results to be returned as massive compression on the column exist and data is kept in RAM. Having participated in SQL14/Hekaton TAP, I’ll be showing demo on both of these technologies, gotchas, best practices.

Bio:

With over 17 years of experience in Microsoft SQL Server technology Worked at Microsoft among other Work in one of the largest MS SQL installation in the world at Dell Database Strategist at Dell Business Platform Technology Advisor at MS

Recorded At:

SQL Saturday Austin 2015

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>