SQL Server Performance Forum – Threads Archive
naming objects
Quick question: How important is to have short names for tables, fields or other objects in general? Does it have an impact on performance?For example is it OK to name an Order table [ThisIsMyTableContainingOrders]?
It doesn’t affect performance.
Only thing which can affect is having procedure names start with sp_ and table names by reserved words.
Also refer this
http://vyaskn.tripod.com/object_naming.htm Madhivanan Failing to plan is Planning to fail
If you are using dynamic sql you can came over limit (NVARCHAR max size is 4000) easily. Maksim Maksim
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by maksimmm</i><br /><br />If you are using dynamic sql you can came over limit (NVARCHAR max size is 4000) easily.<br /><br />Maksim<br /><br />Maksim<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Is this reply related to this topic? [<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
quote:Originally posted by bolo
Quick question:
How important is to have short names for tables, fields or other objects in general?
Not? Maksim
You missed to note the questioner’s example<br /><br />For example is it OK to name an Order table [ThisIsMyTableContainingOrders]?<br /><br />The question is about the length of the object names and not the size of the columns? [<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
Its best to refer the Vyas’s link about best practices on naming. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
This question is about the length of the name of an object and if that length affects performance. Bolo: The quick answer as given already is NO.. Anything else should be a matter of preference and/or defined standards within your own work environment. Nathan H. Omukwenyi
You should try to follow the standards at your workplace and also make names as explanatory as possible. cheers
Pali
Everything happens for your own good.
]]>