Today we will see Brief Note About RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Type resource. I wrote a blog post about Enable Lock Pages in Memory LPIM.
Lock Pages in Memory: When to Enable It and How to Check
Lock Pages in Memory is a Windows right that stops Windows from paging out the SQL Server buffer pool. This post explains what it does and what it doesn’t, how to grant it to the service account and how to check the result with T-SQL. It also covers the max server memory setting that must go with it.
How to List All DML Triggers Created or Modified in the Last N Days in SQL Server? – Interview Question of the Week #242
List all DML triggers created or modified in the last N days in SQL Server, and why modify_date moves when nobody edited the code.
NonParallelPlanReason: Why a Query Refuses to Go Parallel
Read NonParallelPlanReason in actual and cached plans, then check MAXDOP, scalar functions, table variables, and query cost.
Counting Locks per Session With sys.dm_tran_locks
Count locks per session by resource and mode, connect open transactions, and recognize escalation while keeping snapshot limits clear.
SQL SERVER Management Studio 18 – Enable Dark Theme
We are all techies and we love to use a dark theme in our IDEs. I get quite often a question about how to enable dark theme in SQL Server Management Studio.
Database Mail Health Check: Unsent Items and the Event Log
The alert job succeeded, yet nobody got the email. Here are three read-only checks that show whether Database Mail is really working.