Also, if you need to retrieve columns in the SELECT that it can get from the PK, but not from the other ignored indexes, that's probably why.   You'd have to...

When you comply with the requested information, I can help you.  You were asked for "CONSUMABLE" data.   Please provide.

Without knowing what your stored procedure does, that's an almost impossible to answer question.   There might well be a dozen different ways to get to the same result, but the...

Index analysis can only take you so far.   Have you updated statistics recently?   Stale stats can make the optimizer make bad query plan choices.

I think a quick set of definitions is in order.   Folks tend to throw terms around like latency and it's meaning depends on what element of your performance you're referring...

As it's execution context is going to rely on the account that the Linked Server uses, maybe you need to use a dynamic linked server instead, by using OPENROWSET, and...

I can see where this is going, but there's really no good way to ask the database that question.  The problem is that the Marks value you are looking to...

A couple of things to try:

1.) Try another browser, just to be sure you haven't run into something weird with IE.
2.) Try re-booting your machine to be...

What, exactly, did you do, to generate this error?   What are you trying to accomplish?

One more thing.  That CASE statement does not need to have it's latter elements repeated that way.   Try the following as an alternative, where I'll assume that SUBCATEGORYID is a...

Two things.   To_char is an Oracle function, and this is a SQL Server site.   The problem with your syntax error is likely to have been caused by the data type...

One last thought... carriage return is actually CHAR(13), not CHAR(10).   However, in the world of ASCII, they typically appear in order CHAR(13) followed by CHAR(10).   The latter is the New...

As you have the stored procedure, I guess the question is, what help are you looking for?  This is a SQL Server forum as opposed to a web-help kind...