SQL Server Performance

Common Name Restrictions

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by makapangyarihan, Nov 21, 2006.

  1. makapangyarihan New Member

    On tables and columns, what are common name restrictions?

    Jonathan Casuncad
    http://www.sqltraceanalyzer.com - SQL Server Performance Reporting Tool. Free 30-day trial download
  2. jezemine New Member

    there are no real restrictions if you enclose the name in square brackets. however it's very confusing to use reserved words in object names. code like the below should be avoided:<br /><br />select [select] from [from] where [where]='do not do this'<br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><hr noshade size="1">SqlSpec - a fast, cheap, and comprehensive data dictionary generator <br />for SQL Server 2000 and 2005 and Analysis Server 2005 - www.elsasoft.org <br />
  3. Roji. P. Thomas New Member

  4. Madhivanan Moderator

  5. satya Moderator

    I would like to know what kind of naming convention you would like to adopt [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]. <br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by makapangyarihan</i><br /><br />On tables and columns, what are common name restrictions?<br /><br />Jonathan Casuncad<br /<a target="_blank" href=http://www.sqltraceanalyzer.com>http://www.sqltraceanalyzer.com</a> - SQL Server Performance Reporting Tool. Free 30-day trial download<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>

Share This Page