O my God There is no more Ctrl+N in SQL 2008

Ctrl+N is not working in SSMS (2008). We can easily fix it by changing the KeyBoard to SQL 2000 from Standard. To Change it

Tools --> Options --> Environment --> Keyboard --> Keyboard Schema Change it to SQL Server 2000.

Now you find that Ctrl+N is working ........

An awesome short cut to format SQL Code lines.

When you opened a stored procedure and pasted it on Query Editor it look likes a bulky element and obviously difficult to understand. Just select the entire code and Press

Shift + K+ \