SQL Server Performance


Discussion in 'ALL SQL SERVER QUESTIONS' started by Antonio Benildus Muerling, Jun 20, 2012.

  1. Hi Guys and Geeks,

    Hope you will read and comment to me on this, I have been asked to create a Database, with a minimun of 5 tables, and it may grow as the days go by.

    These 5 tables are to be created now with primary and foriegn key relationships.

    Indexing will be done later.

    Need the kickstart, I know to do it, but the efficient way for the primary and foreign key relationships.


  2. FrankKalis Moderator

    Welcome to the forum!
    Could you please be a bit more specific about what you're after?`
  3. Shehap MVP, MCTS, MCITP SQL Server

    The efficient way for electing PK /FK columns refer basically to business wisdom, But technically we have a basic criterion for a good PK columns (Clustered Index by default) is to create PK withe Numeric values columns not string values and much better if to be identity columns which may boost significantly OLTP performance in particular more if stress workload + huge data entity are there

Share This Page