Configure SQL Server 2012 editor settings

SQL Server 2012 - Changing Font Size :

On the Tools menu, choose Options to open the Options window in SSMS and change the font size  for the text editor.

SQL Server 2012 - Copying TSQL Results with Column headers :

Enable the option to include column headers when copying the result from the grid.
Look under Query Results , SQL Server , Results to Grid for the check box Include column headers when copying or saving the results.



How to Enable Intellisense :

Open a new Query window and select the required database.
Right Click and Select Intellisense to enable or disable.

SQL Server 2012 - Auto popup database objects like SQL Tables,Views,Procedure while writing queries using IntelliSense

SQL Server 2012 has a good feature called intellisense which helps the developers to auto fill the database Objects like  table name or View name or procedure name whiling writing queries.

Steps:

•          Open a new Query window and select the required database.
•          On writing Queries whenever you want to specify a table name or View or Procedure or function type  <dbo> or  <User Defined Schema Name> followed by  < . > (dot) to list down the database object and select the required database object.