SQL Server Performance

Search Results

Search Again
  1. johnslg

    Surrogate keys

    Thread by: johnslg, Aug 2, 2007, 9 replies, in forum: SQL Server 2005 Analysis Services
    Nearly everything I read tells me to use integer surrogate keys for the dimension tables, combine all surrogate keys as the composite primary key in...
  2. johnslg

    Beginner's dim loading question.

    Thread by: johnslg, Aug 1, 2007, 7 replies, in forum: SQL Server 2005 Integration Services
    I have a factSales table and a dimCustomer table (among others); all my data is coming from a single OLTP SQL Server db. When loading data do I parse...
  3. johnslg

    Foreign keys/many to many tables

    Thread by: johnslg, Aug 1, 2007, 6 replies, in forum: SQL Server 2005 General DBA Questions
    I have three tables that I want to link for a many to many relationship: sales: Type, int, PK Cust, int, PK Order, int, PK .... Order: Order, int,...
Showing results 1 to 3 of 3
Search Again