SQL Server Performance

Search Results

Search Again
  1. Newbie

    Relational data warehouse fact table index

    Post by: Newbie, Dec 2, 2004 in forum: Analysis Services/Data Warehousing
    Thanks. Still a little bit confused though. "If you decide to create clustered index it is better to be unique, otherwise mssql server will add...
  2. Newbie

    Relational data warehouse fact table index

    Post by: Newbie, Dec 1, 2004 in forum: Analysis Services/Data Warehousing
    The surrogate key option was based on an article published on the Microsoft site -...
  3. Newbie

    Relational data warehouse fact table index

    Post by: Newbie, Nov 30, 2004 in forum: Analysis Services/Data Warehousing
    Thank you Raulie. Can you please clarify what "(4) or (<img src='/community/emoticons/emotion-11.gif' alt='8)' />" are?<br />For indexing, I thought...
  4. Newbie

    Relational data warehouse fact table index

    Thread by: Newbie, Nov 29, 2004, 1 replies, in forum: Performance Tuning for DBAs
    I have a fact table with 17 dimension foreign keys (all ints) and 1 degenerate dimension (bigint). 8 of the dimension foreign keys make the fact...
  5. Newbie

    Relational data warehouse fact table index

    Thread by: Newbie, Nov 29, 2004, 17 replies, in forum: Analysis Services/Data Warehousing
    I have a fact table with 17 dimension foreign keys (all ints) and 1 degenerate dimension (bigint). 8 of the dimension foreign keys make the fact...
Showing results 1 to 5 of 5
Search Again