Fast fix of tempdb contention issues using Hekaton
You have read that Microsoft came up with this new thing .. Hekaton they say. The new kid on the block. (Not that new actually .. been there for the better part of the last 10 years, but people still do not know too much about it) And from time to time people blog about it. Some say that it can fix TempDB issues. So let’s see then, what can and what can’t it do for TempDB: Switch table variables…