See how to change a memory-optimized table to a standard table
Yes you can revert a memory optimized table back to a standard disk-based table. While the preponderance of material you’ll find on the Internet will tell you how to migrate to In-Memory OLTP memory optimized tables there’s very little advice on how to move back if the new memory optimized tables didn’t work out. In-Memory OLTP is a great technology but there could be a number of reasons for moving back. In-Memory OLTP is best when you have a situation where the application is waiting for locks and latches.
from SQL Server Pro http://ift.tt/1kCjeYg
Nenhum comentário:
Postar um comentário
Leave your comment here!