O'Reilly logo

Dynamic SQL: Applications, Performance, and Security by Edward Pollack

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Ed Pollack 2016

Edward Pollack, Dynamic SQL, 10.1007/978-1-4842-1811-2_11

11. Additional Applications

Edward Pollack

(1)Albany, New York, USA

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required