Today I have a peformance issue where setting legacy cardinality estimator ON helps.

From 100s to 1 sec. Really interesting.

But is it is written on the very first page I do have it switched on - since the migration, I now about this switch. And I have still some...

In my opinion it is the same as "Legacy Cardinality Estimator" ON at database level.

If yes, I mention this on the very first page.

Martin

I have search the internet from what I understand, the trace flag has no impact on SQL 2016, and https://stackoverflow.com/questions/42630320/compatibility-level-upgrade-from-100-to-130-query-optimizer-fixes-flag

For the article https://logicalread.com/3-sql-ssql-server-trace-flags-troubleshooting-pd01/#.XseBbsAzXmF

there is no date and SQL 2016 and...

Any suggestions ?

Here it is, from SEntry anonymized, the question is, If I did it properly, I don't know how the anomymization si random, since I did both in different instance of...

I have no clue how to remove the attachments. Edit doesn't work, I can change only text.

we are prohibited from publishing code (our mother company uses some robots to search for, but they don¨t help us with any other thing as usuall). Bu  ican hoepfull publish...

• This reply was modified 5 years, 4 months ago by martinreiser.
• This reply was modified 5 years, 4 months ago by martinreiser.

The web page refuses upload of the plan

• This reply was modified 5 years, 4 months ago by martinreiser.

If you have tables with fewer than 200 rows, the statistics won't be changing very often unless you're doing lots of replacements of that data, so I don't see...