I've a very simple SQL which is performing very poorly. Most of the time its waiting for Memory/CPU.
Clustered index on PrimaryKey (ID).
Non-Clustered index on NBR
I've nested loop with Non-clustered Seek and Key Lookup on NBR. Is that a normal?
This table has 2 million rows and the rows are not contained in 1 single page.
I can not remove the STARS in the SQL for this time.
ALTER PROCEDURE [dbo].[GetNbr]
SET NOCOUNT ON;
SELECT * FROM big_2milrows_table with(nolock)