I guess that would depend on what identity value you are looking for? The one created by that session on the specific table (Scope_Identity), the last one created by that session (@@Identity), or the last one created for that table (Ident_Current('table'))?

I have to admit to not being confident on this one. I would define it by saying it occurs when SQL uses an index that doe snot include all the columns requested, but has to then get the row id to return the other columns. I do know that the fix is to return only the columns you need and to, if possible, create a covering index. BTW-I just learned about the Include clause on the create index statement last week.