Columnstore indexes without aggregation still help when a query reads many rows but only a few columns. This post builds a rowstore table and a columnstore copy of one million rows and compares reads, size and execution mode. It also shows the case where a plain b-tree index wins.
SQL SERVER – Table Variable or Temp Table – Performance Comparison – INSERT
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 – Brief Note About RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Type Resource
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.
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.