17 Administrative Transact-SQL
Thinking is the hardest work there is, which is probably the reason so few engage in it.—Henry Ford
While database administration itself is beyond the scope of this book, we can still delve into administrative Transact-SQL in some depth. In many shops, the line between database programmer and database administrator is a gray one indeed, so, regardless of whether you’re a DBA, it’s handy to have a working knowledge of administrative Transact-SQL commands and syntax.
It’s common for shops to author custom stored procedures and Transact-SQL batches to perform administrative functions. Backups, index statistic refreshes, and data warehouse updates are examples of the types of tasks these routines usually perform. ...