Question: How Dirty or Clean SQL SERVER Database is (by Memory)?
This blog post is the follow up of the earlier blog post on the same subject.
How Much Memory is in Locked Pages? – Interview Question of the Week #228
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.
How to List All Memory Optimized Tables in SQL Server? – Interview Question of the Week #227
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.
When was Table Accessed Last By User? – Interview Question of the Week #226
Question: When was Table Accessed Last By User?
When Was SQL Server Last Restarted? – Interview Question of the Week #225
Question: When Was SQL Server Last Restarted?
How to Execute Query Without Using F5 or Query Toolbar in SSMS? – Interview Question of the Week #224
Question: How to Execute Query Without Using F5 or Query Toolbar in SSMS?
Dirty Pages – How to List Dirty Pages From Memory in SQL Server? – Interview Question of the Week #223
Question: How to List Dirty Pages From Memory in SQL Server? Answer: I received question today during my SQL Server Performance Tuning Practical Workshop.