SQL Profiler
Database Engine Tuning Advisor
Display Estimated Execution Plan
Include Actual Execution Plan
Include Client Statistics
Results to --> Text, Grid and File
Query options
Design Query in Designer
Template Explorer
Maintenance Plans
SQL Server Agent (Jobs)
Logins
Backup/Restore
Attach/Detach Database
Take offline
Import/Export Data
Reports--> (Standard and Custom)
Generate Script (with and Without data)
Database Options
Design Database
Table
Stored Procedure
Function
Trigger
View
Joins
Indexes
Queries (Sub query, corelated and dynamic SQL)
Temp tables
Table type Variables
Tuning Stored Procedure
Queries
