SQL Server Performance

Search Results

Search Again
  1. shahdeepan

    History Table

    Thread by: shahdeepan, Aug 1, 2006, 7 replies, in forum: General Developer Questions
    Hi Friends, I have a Fact Table(Daily Truncated and re-loaded) for which i need to create a History Table. As a First Step the Empty History Table...
  2. shahdeepan

    Indexing on Fact Table

    Thread by: shahdeepan, Jul 16, 2006, 3 replies, in forum: Performance Tuning for DBAs
    Hi Friends, We have a Transaction Fact Table which contains 21 Columns and 4998000 Records (Almost 5 Million). The Uniqueness of a Record can be...
  3. shahdeepan

    Reporting in DW

    Thread by: shahdeepan, Jul 5, 2006, 3 replies, in forum: Analysis Services/Data Warehousing
    Hello Friends, We have created a Datawarehouse System, on SQL Server 2000. Our DW Design is very much based on Snowflake Design (Bill Inmon). Apart...
  4. shahdeepan

    Datetime Problem

    Thread by: shahdeepan, Jun 30, 2006, 5 replies, in forum: General Developer Questions
    Hello Gurus,<br /><br />I have a table where i have a few columns and one Column(UPDATE_DATE) where the date is stored in String Format eg...
  5. shahdeepan

    Indexing Strategy

    Thread by: shahdeepan, Jun 27, 2006, 4 replies, in forum: Performance Tuning for DBAs
    Hello Friends, I have a Table which gets loaded daily and it is a Truncate and Full Load (i.e Daily the Table gets Truncated and a Full Load using...
Showing results 1 to 5 of 5
Search Again