Grant Fritchey - Friday, February 9, 2018 8:07 AM
I basically forbid the use of Table Variables because of their non-persistent nature for troubleshooting and the single row estimates they normally kick up unless you do a recompile. The only place we use them is where we have to, such as in iTVFs. I'm a bit new to the in-memory thing... is there a way to tell iTVFs to use In_Memory? Is it a simple as creating the iTVFs on the in-memory group?
--Jeff Moden
Change is inevitable... Change for the better is not.