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.
How I Know If I am DBOWNER or Not in SQL Server? – Interview Question of the Week #222
Question: How I Know If I am DBOWNER or Not in SQL Server?