That's not the whole stored procedure definition, is it?  The execution plan shows that there's a cursor involved.  Also, do you have an example of the table parameter (@TableWaybillID) that...

Please specify exactly what you need the user to be able to do.  First you said it was only for one particular database; now you seem to be saying that...

There's no reason to run SQL Server on an old operating system.  You should use SQL Server 2016.  I don't know what the individual benefits are, but I do know...

Do you have the option to change code?  The SelectWaybillID stored procedure uses a cursor - probably dreadfully inefficient.  Please will you post the full definition of the stored procedure,...

Sounds as if you may have a disk bottleneck.  But I think you need a slightly more detailed analysis of your wait stats.  Paul Randal's and Brent Ozar's blogs have...

What other applications run on the server?  How much memory is in the server and what is max server memory set to in sys.configurations?

John

The first problem is that your table mytable doesn't appear in the query.  The second is that your subquery isn't correlated to the outer query.  Therefore, all rows in the...

Yes, or just grant db_owner membership in the database in question.

John

You're not going to learn anything if you get other people to do your homework for you, especially if they give you the wrong answer.  The solution provided is incorrect...

The DESC in the ORDER BY clause only applies to the column it immediately follows.  Try this:
ORDER BY year DESC, month, date

John