Nov
18
accepted Entries in suspect_pages but checkdb shows no error
Nov
18
answered Entries in suspect_pages but checkdb shows no error
Nov
15
revised Entries in suspect_pages but checkdb shows no error
added code details
Nov
15
comment Entries in suspect_pages but checkdb shows no error
event_type is 1 and 2, I'll correct my question so that it's easier to see
Nov
15
asked Entries in suspect_pages but checkdb shows no error
Nov
13
awarded  Popular Question
Nov
13
awarded  Yearling
Nov
11
comment How to determine high tempdb disk IO that goes down after restart
You can also use the "sp_blitzquerystore" procedure, it has many parameters and can help you analyze data in the query store brentozar.com/archive/2017/06/introducing-sp_blitzquerystore
Nov
8
comment How to determine high tempdb disk IO that goes down after restart
you should try to run sp_blitz or sp_blitzfirst when it's happening instead of restarting the server : brentozar.com/blitz
Nov
1
revised How to make sure change_tracking statistics stays updated
updated my query to fix an error
Nov
1
revised How to make sure change_tracking statistics stays updated
added my query solution
Nov
1
accepted How to make sure change_tracking statistics stays updated
Nov
1
comment How to make sure change_tracking statistics stays updated
I'll mark your answer as the answer. I'm going to setup a job to update stats every x min for tables that have changed a lot since the last update statistics. I'll edit my question to add the query in case it can help someone
Nov
1
comment How to make sure change_tracking statistics stays updated
About the auto update async, Brent Ozar recommends setting it off. brentozar.com/blitz/auto-update-stats-async-enabled What do you think about that? I already have "auto update" setting on. But I never tried the auto update async
Nov
1
comment How to make sure change_tracking statistics stays updated
Yes thanks, I already did read her blog. This is where I get my queries to monitor my change tracking tables :-)
Nov
1
revised How to make sure change_tracking statistics stays updated
added database compatibility
Nov
1
comment How to make sure change_tracking statistics stays updated
Compatibility level 130 SQL 2016, I'll add it to the question
Nov
1
asked How to make sure change_tracking statistics stays updated
Nov
1
awarded  Yearling
Oct
30
comment Which Plan is Better? WHERE EXISTS Instead of INNER JOIN
@BBaggins I edited my answer to add a lot of details about the memory grant. You should also look at the link I put in it to help you understand the memory grant. The second plan is better at estimating memory needs but it takes too much. The first one probably spills to tempdb because it underestimates the rows too much.