Overview

  • Row Counts - A script that runs fast and provides a count of the number of rows of every table in your database.

  • Rebuild Indexes - A script that rebuilds every index on every table in a database.

  • Refresh Views - A script that refreshes the metadata for every view in the database.

  • Search Code - Narayana Vyas Kondreddi’s script that searches all objects (Views, stored procs, functions, etc.) for a string to help you find where your database objects are used.

  • Update Stats - A script that updates the index statistics for every index on every table.