In this blog post, we will talk about Performance Comparison between Table Variable or Temp Table. Comprehensive Database Performance Health Check
SQL SERVER – Regular Table or Temp Table – TempDB Logging Explained
After the blog posts about temp and regular table, I have received questions about it hence I am writing this blog post about TempDB Logging.
SQL SERVER – Regular Table or Temp Table – A Quick Performance Comparison
For a data load, which is faster: a regular table or temp table? My client asked, and I answered with proof and a working demo you can run yourself.
SQL SERVER – Check for Update in SSMS
How to check for an update in SSMS depends on the installed generation. My fintech-customer walkthrough showed SSMS 18 settings.
RESOURCE_SEMAPHORE_QUERY_COMPILE Wait: Check Lock Pages in Memory
RESOURCE_SEMAPHORE_QUERY_COMPILE was the first wait type in a client’s wait statistics. Readers asked how I knew to look at Lock Pages in Memory. Here is the script I used, and the setting that resolved the problem.
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.