>>No, Table in memory is faster (2x-3x) for writing than standard table, because use another engine.
>
>Is there any side effect? Because, if this is so fast, I wonder why Microsoft simply did not put that in the core instead of an option.

:-) Yes.
- if you use stored procedures and functions, you must rewrite it
- you need much memory

MartinaJ.