sql deadlocks
 

Table-valued function is another way. But I read an article saying that in some situation, table-valued function could be very slow. Can someone give a performance comparison?

I suppose it would be better if you check it on the net.You'll get the right idea.