There is one parameter (userID) which is being passed into the query via cmd.Parameters.Add. The C# type of this variable is long (Int64) and the types of the columns it's being compared to in the db ...
As a consultant whose job description includes putting out performance fires, I get to see a lot of problematic queries that can dramatically harm overall server performance and throughput. Wondering ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results