SQL Server 2014 In Memory technologies - In Memory OLTP (aka Hekaton) & ColumnStore
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.
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
- Austin SQL Saturday 27 Recordings
- Hekaton 2 Recordings