Please refer to the following links:
http://stackoverflow.com/questions/5260650/max-length-of-sql-server-instance-name"> http://stackoverflow.com/questions/5260650/max-length-of-sql-server-instance-name
http://msdn.microsoft.com/en-us/library/ms143531.aspx"> http://msdn.microsoft.com/en-us/library/ms143531.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/