Please don't post multiple threads for the same question.
No replies here. Replies to https://www.sqlservercentral.com/Forums/1914800/Need-Help-for-performance

Please don't post multiple threads for the same question.
No replies here. Replies to https://www.sqlservercentral.com/Forums/1914800/Need-Help-for-performance

If that's in a scalar user-defined function, it will be very slow. Nothing you can do about that, functions are very slow. Try converting it to not use a function.

There's no reason to have a subquery there.

SELECT [Agent Name] AS AgentName
  , [Reason Code] AS ReasonCode
  , SUM(Cast(Datepart(Second, [Duration]) AS INT)...

Recompiling it made the problem go away temporarily. It hasn't fixed it. Fixing will require changing the code or using plan guides or query store forced plans (if an upgrade...

Bad parameter sniffing, or some form of unstable plan. Almost always the result of the way stored procedures are written, and fixable by making sure that procedures only have one...

https://www.sqlinthewild.co.za/index.php/2011/08/16/compiles-and-recompiles/

SQL doesn't use the page file. If it ever gets paged out, something has gone *seriously* wrong (and there will be messages in the error log stating that it's been...

If you're using Entity Framework, and it's running ad-hoc SQL against the DB, no. Handle the error in your application and present to the user something meaningful.
If you have...

It's not SQL Server. vBulletin uses MySQL. So, given the version, this is MySQL 5.1.54 (still pretty outdated)

This isn't exactly T-SQL afterall - IF(votenum >= 1, votenum, 0)...

Why is SQL 2016 Enterprise not an option?

SQL 2012 is out of support, so just from that, it's a sub-par choice.