nice question

Avoiding uage of prefix sp_ improves the performance.

Index on identity column improves performance

very simple question....

question can be framed with smoe more complexity

Try this

select * from @table where [name] like 'Jo_'

Any one pls state how round off takes place......:-D