This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting of a curved line of wooden dominoes on a table with a single vermilion block lying across their path

RSFXDEVICEOPS Wait: Unneeded WAITFOR DELAY Slowing Queries

October 5, 2019
Pinal Dave
SQL Performance
Comprehensive Database Performance Health Check, Filestream, SQL Server, SQL Wait Stats

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.

Read More
Gouache painting of four wooden chests in an attic with their keys in front and one key in vermilion

Memory-Optimized Files: List Logical and Physical Names

October 4, 2019
Pinal Dave
SQL Performance
In-Memory OLTP, SQL DMV, SQL Memory, SQL Scripts

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.

Read More
Gouache painting of a row of park benches looking out over a pond with one vermilion bench turned the other way

MAXDOP Query Hint: Override the Server Setting for One Query

October 1, 2019
Pinal Dave
SQL Performance
MAXDOP, Parallel, SQL Scripts, SQL Server Configuration

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.

Read More
Gouache painting of tall narrow pantry jars of different lentils with one jar of vermilion lentils

Columnstore Indexes Without Aggregation: Do They Still Help?

September 30, 2019
Pinal Dave
SQL Performance
ColumnStore Index, SQL Index, SQL Scripts

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.

Read More
Illustrated cover: #Temp

SQL SERVER – Table Variable or Temp Table – Performance Comparison – INSERT

September 21, 2019
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Variable, Temp Table

In this blog post, we will talk about Performance Comparison between Table Variable or Temp Table. Comprehensive Database Performance Health Check

Read More
Illustrated cover: Temp Table Logging

SQL SERVER – Regular Table or Temp Table – TempDB Logging Explained

September 20, 2019
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL TempDB, Temp Table, Transaction Log

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.

Read More
Illustrated cover: Regular vs Temp Table

SQL SERVER – Regular Table or Temp Table – A Quick Performance Comparison

September 19, 2019
Pinal Dave
SQL Performance
ETL, SQL Scripts, SQL Server, Temp Table

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.

Read More
Previous 1 … 35 36 37 38 39 40 41 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com