SQL Server is a huge product and there are few products which I personally use to improve my productivity.
Red Gate Software is a software company based in Cambridge, UK. It primarily provides tools for database developers and administrators.
SSMS Tools Pack is a Microsoft SQL Server Management Studio (SSMS) add-in.
Sql Power Tools Server Bottleneck Monitor performs agentless monitoring of wait types, wait times, disk bottlenecks, TempDb bottlenecks, SQL performance, SQL plan mining, top N SQL, performance counters, blocking, deadlocks, procedure cache, buffer cache, database space, disk drive space, SQL jobs, performance baselines, VMware and Hyper-V. With one-click graphing of SQL plans.
SQL Space Map is a tool that lets you quickly and easily view the relative size of database objects on a map, so you can compare them visually. It helps identify large objects, objects with a high index/data ratio, and tables which may be growing more quickly than expected.