Thank you! It is very helpful.

Attaching atain as TXT

The attached script nicely blows up the 2 tables to 5 million rows, and to 8 GB database size.

I need to device several examples of Bad Queries (possibly purposefully written...

Its nice, but I need to use Real tables.

Like the ATTACHED SQL. Blowing up the tables.. And then here is the plan below of what time m trying to do....

I understand that using this below will be only a part of it.

Making sure row is not longer than 8060 bytes is another..  what else?

-------------------------------------------------------

-- The queries below need to...

Grant,

what would be a short checklist

of 1,2,3,... of things that DEFINITELY qualify a table for turning it into Memory Optimized and a list of COUNTERINDICATIONS against turning it into in-memory...

Is it a pre-requisite for implementing Columnstore indexes to have the table Memory Optimized?   (=in-memory OLTP?)

This has been always a problem..

Unless you absolutely need to uninstall it, you can just install a new named instance, and forget about the not (fully) uninstalled the previous one..

Also, question regarding your book 'SQL Server 2017 Query Performance Tuning': If we use SQL 2016 Enterprise, not 2017, are our developers going to benefit from this book? I mean,...

Grant,

Thank you so much for your input. (I have been spot-reading your book, by the way, for years. It has been VERY helpful as well).

Our company, after I shared about...

Thanks! Very helpful suggestion.

Thanks everyone for your input.

I really appreciate it.

Will take all of it into account.  Happy Thanksgiving!

no results at all. I tried in 3 dfferent servers. 0 result. while there are bunch of users logged in , running a lot of Select statements...

there is no SQL_TEXT column in either master.sys.sysprocesses or sys.dm_exec_requests..

cannot run this query.

Thanks everyone for your input on that.  And Thank you, Grant.