When we heard “Kill” then first impression of this word is very bad. We always scare with this word. In real world we never want this action from anyone but in SQL Server case it is very helpful and help us many times. This feature we can use but very carefully. It is something like …