This final chapter takes a look at some more interesting applications of Dynamic SQL. The goal is to leave you with a variety of practical scripts that can be brought into any database environment and tailored to unique uses. There are many real-world challenges for which Dynamic SQL is an efficient solution and where you can accomplish a great deal of work in compact, reusable code.
Database Maintenance
One of the most challenging areas for DBAs and database developers is in providing regular care and maintenance to their servers, databases, and related software. Common tasks such as defragmenting indexes, ...
