SQL Server : Handy Scripts

ReIndexing Database Tables and Update Statistics on Tables

Report — All Blocking Transaction

Identifying Unused Indexes

Get size of all tables in database