The RSFXDEVICEOPS wait, listed as PREEMPTIVE_OS_RSFXDEVICEOPS, was high at a client that did not use FileStream. Their queries carried a WAITFOR DELAY nobody remembered adding. When the clause came out, the wait dropped and the queries got fast again.
Memory-Optimized Files: List Logical and Physical Names
To list memory-optimized files, join sys.dm_db_xtp_checkpoint_files to sys.database_files. This post builds a small memory-optimized database, shows the container’s logical and physical name and counts its checkpoint files by type and state. It also explains why a container holds far more disk space than its data uses.
MAXDOP Query Hint: Override the Server Setting for One Query
The MAXDOP query hint sets how many processors one query can use, whatever the server setting says. This post proves it in both directions on a test table, shows that the hint can’t force a parallel plan and adds the database scoped setting between the two. Every step leaves the server setting alone.
Columnstore Indexes Without Aggregation: Do They Still Help?
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.







