Question received via email: The question was about is there any way to know how many rows each thread execute in parallel operations.
Recently, while working with the customer who had a Memory issue, we ended up talking about Clean Pages and Dirty Pages Count.
Question: How Much Memory is in Locked Pages? Answer: Before we see the answer to this question, I suggest you read the blog post here first.
Question: How to List All Memory Optimized Tables in SQL Server? We will see two different scripts here: One for Database and Second for Tables.
Question: When was Table Accessed Last By User?
Question: When Was SQL Server Last Restarted?