Here are a few handy tips I learned lately: 1. When using sp_configure, you don’t need to type the whole parameter string. You just need to type enough of it for Sql Server to be uniquely identify it. For example, sp_configure ‘show ad’ will resolve to sp_configure ‘show advanced’ 2. In Query Analyzer or Management…