Add SQL Server index but how to recompile only affected stored procedures?

You can exceute sp_recompile and supply the table name you've just indexed. All procs that depend on that table will be flushed from the stored proc cache, and be "compiled" the next time they are executed.

They are generally recompiled automatically. I guess I don't know if this is guaranteed, but it has been what I have observed - if you change (e.g. Add an index) the objects referenced by the sproc then it recompiles.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.