August 2017 | Get the most out of MSSQL !

Can we use in-memory oltp instead of columnstore index for DW queries

Posted on August 10, 2017March 20, 2021 by jayanth.kurup

Recently when having a chat with a client I was asked if it will be a good idea to replace a view with a static in memory table so that users querying the table for a dashboard will have better performance considering the data will be in the RAM. Bottom line the best place to…

Scaling SQL Express with Stretch table feature

Posted on August 2, 2017March 20, 2021 by jayanth.kurup

Recently I was asked by a client if the Stretch table feature will work with SQL Express and if so what the limitations are. This seemed like an interesting use case so we explored further and here is what we found. Can SQL EXPRESS edition in SQL 2016 be used with stretch tables feature in…