As replacement for traditional table variables, and in some cases for #temp tables that are local to a stored procedure. This is particularly useful if there is a lot of tempdb contention in the ...

SQL Server 2014 CTP1 introduced hash indexes for memory-optimized tables. Hash indexes are very efficient for point lookups, when you know exactly the value you are looking for. However, they do not ...