What causes the query to recompile? Is it a good sign or bad sign for performance? How frequently should I recompile the stored procedures? Does a reindex cause SP to recompile when it is executed next time? These are quick questions raised in the recent...