Developers and database administrators (DBAs) use SQL in application development and the subsequent problem solving and fine tuning. This work covers the common issues DBAs face day to day. It provides DBAs with solutions actually used by the authors in enterprise environments to resolve common and specialized problems to optimization issues.