Tip # 1

Problem:  You have too many connections stored in your management studio using IP address. Sometime it is hard to remember the IP address vs server mapping. Or you have scripts to run on various servers in same management studio instance.

Solution: Use SQL Server Connection Registration feature as shown in diagram below and you can organize all your connections in amazing ways. To get this window just go to View -> Registered Servers.

Tip # 2

Problem: You are trying to get the things done using SQL Server designer because you don’t remember the query syntax. E.g. Adding a new column, insert script etc

Solution: SQL Server Studio has a feature called Template Explorer(Hit CTRl+Alt+T) and you can see readymade queries available for most of the day to day operation. You can even create your own templates. See the diagram below

Hope this will help you in someway.

There is a very interesting question asked at stackoverflow.com with the subject same as title of this entry '

You can visit the original question here 

I would certainly like to post the live result from stackoverflow here

interesting isn't it?

Here are links to a very good articles on how to compress session so that memory on computer may be saved.

Scott Hanselman posted original entry here

A modified useful version was posted by Al Pascual here

Hope this helps!

Few days back I came across a very nice & useful website http://stackoverflow.com. As said in about us page 'The only unusual thing we do is synthesize aspects of Wikis, Blogs, Forums, and Digg/Reddit in a way that is somewhat original. Or at least we think so.';

You can ask any questions and I am sure within a few minutes you will get answers. User interface is also very nice and user friendly. You need not register to ask questions but it's good to register. They only support openid authentication. In case you have not got yet you can find lot's of website offering this service. For more info you can visit http://openid.net

A beautiful poem