2. Want quick information on a column’s data type and nullability? Enable the Quick Info feature by selecting Edit > IntelliSense > Quick Info (or Ctrl+K, Ctrl+I). After this, simply mouse over a column in a query for pop-up information, including its nullability and data type.
3. Have you ever accidentally dropped a production table when you thought you were connected to a test server? When connecting to a new server, click Options and under the Connection Properties tab, select a custom color. Whenever a query window is opened against this server, the status bar at the bottom will display the chosen color (for example, bright red for production!).
4. Right-clicking a process within the new Activity Monitor allows the process to be tracked in Profiler with an automatic filter applied for the SPID. Further, you can automatically open Activity Monitor on startup of Management Studio by choosing Open Object Explorer and Activity Monitor in the General page of the Tools > Options menu in SQL Server Management Studio.
5. The missing index DMV information is displayed in the graphical execution plan output. Right-click it and choose Missing Index Details to display the T-SQL to create the index.