Yes collation fix helped...

"Second, look at the stuff in the SELECT list and FROM clause... basically, it's all a repeat of the same thing with a different qualifier.  That's...

Which edition of SQL Server are you using and what are the parameters you're using for the "reindexing job"?

The sample rate is at roughly a half second.  It's hard to tell what the actual data is from the graphic you posted but are they actually recording the time? ...

I recently tried to run a update statemene with joins on a table that has 200,000 records. I suppose it should be very quick.

But it turned out it ran30...

Two way street, first... what does the code look like now that you've improved it?

[EDIT] Either...

Post deleted.  I missed the fact that the post I answered was a spam post.

You're using SQL Sever 2019... that means that there's little need to do such things using the likes of C#.  Please see the following article and look for the 2019...

Try this as a start... How to Post Performance Problems , which might also give you a hint on how to start troubleshooting performance issues as...

I didn't have any issues with CHAR columns lately, but we have had to adjust the size on our claim number(was char(8)) and policy number(was char(9)) sizes...

Heh... plenty of time each week to do index maintenance, right?  😀 😀 😀

After almost 25 years, I wish MS would finally study Peter Norton's works and write something much...

@rick,

I remember those days but that's actually a really bad example for system of today.  Anyone that actually stores dates as a CHAR() in their normal database tables needs to...

Rick, please tell me that you're not advocating a "panacea length" for VARCHAR(N) where "N" is something like 256.  Please tell me you're not advocating the NUMERIC(18,N) should be a...

A popular college MIS system uses CHAR for many fields and this often leads to issues, not in the software, as that is built to account for this. However...

Lordy.  I understand that...

Um... ok.  I'm confused.  I thought you just said that SPAM is a bit of a problem.

The...