I have been testing IN-Memory OLTP. With the release of 2017 most of the restrictions I have encountered have been addressed (Support for CASE, Unlimited Indexes on Memory Optimized Table...

Thanks for the Article. Do you think this approach, Connect to Azure Sql Database over the internet, could be used as a primary backend database for a production .net program running...

I would look at doing the Update Statistics before the reindex.

The reindex update the stats on the indexes.

The update status updates all statistics even sql server generated one.

The difference is...

Thanks also.