I used SQL Profiler to trace SQL scripts and got one sql statement with 53142 reads (as picture), but I executed that sql statement but found its...

Thanks for reporting back what worked.

Yeah, compat level might help, but it could also burn things down. They're probably trying to avoid dealing the change to the cardinality estimation engine that occurred in 2014 by...

One possible explanation, assuming identical parameter values, is that a plan recompile occurred. The execution from Profiler was in one plan and the execution from SSMS was in a different...

The query doesn't have any kind of filtering through a WHERE clause? It's likely that running the query forces SQL SErver to move all the data in question through memory,...

Sounds like a parallelism deadlock. They're generally rare, but absolutely do happen. Usually, but not always, there are tuning opportunities that can make them go away; changes to the code,...

OK then.

My recent experience with "flat-earthers" taught me that it's almost useless trying to prove anything to true...

I am going to rewrite my query performance tuning book. It's a little out of date now. Pretty sure vNext is coming soon(ish). So yeah. I'm supposed to be working...

Hi all,

Fun enough, this thread 😉 Mixing state moves with unrelated thoughts about the need to document pgms code (how deep ? how far ?)

As a frog, I’ve learned...

Unfortunately, that actually proves that they don't know.  Bob Ward is still talking about the use of reorganize for index...

OK then.

My recent experience with "flat-earthers" taught me that it's almost useless trying to prove anything to true believers. For...

Yes.

Changing them just means using different percentages to determine when to perform reorganize vs rebuild.  The problem isn't the percentage - the problem is when to choose a reorganize. ...

Too bad you couldn't get a bit further south to Texas - which has no state income tax 🙂

The real question you need to answer is, are you a...

Ola's stuff works on the 5/30 methodology for index maintenance.  The maintenance plan rebuild task uses the 5/30 methodology - the code the article links to (Adaptive Index Defrag)...