SQL Server Performance

SQL Rules Base

Discussion in 'The Lighter Side of Being a DBA' started by blockwood, Dec 5, 2006.

  1. blockwood New Member

  2. satya Moderator

    Brian<br />Is that you on that photo [<img src='/community/emoticons/emotion-1.gif' alt=':)' />], rules are good to frame and it is surprising how many of them are followed correctly. When the problems strikes the human nature is to take a shortcut to avoid such shambles.<br /><br />Anyway appreciate your post about this sensitive topic.<br /><br />(moving to relevant forums from General DBA section).<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>
  3. Madhivanan Moderator

    1 No more than 10 columns for each table

    Is this possible?


    Failing to plan is Planning to fail
  4. FrankKalis Moderator

    Well, everything is possible. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br />If it is appropriate has to be evaluated on a case by case basis. The point however is, I guess, that you don't put each and every probably possible attribute into one single large entity which only is sparsely populated thereafter.<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  5. Adriaan New Member

    Ah, the single large entity strikes again!
  6. FrankKalis Moderator

    Yes, and while we're at it. Why use SQL Server anyway? For that purpose Excel is brilliant. Who cares about some maybe occuring theoretical data manipulation anomalies? [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  7. Adriaan New Member

    The user always comes first.
    The system must fit the data, not the other way around.
    Users must be able to find any bit of information without knowing the general data structure.
    The programmer may not be involved in the early design stages of the user interface.

    Try and argue against that.[xx(]

Share This Page