Professional Web Applications Themes

Table design - Microsoft SQL / MS SQL Server

SQL 2K I am creating a table for holding data used for data wear-housing project. This table will eventually going to have millions of records. Planned to have a primary key and proper indexing in this table. This table will be queried against various columns and will be refreshed (fill data) on a weekly basis. Is there any other approach I should think about like - Partitioned views or ?? Any thoughts/Ideas will be highly appreciated. Thanks Sh...

  1. #1

    Default Table design

    SQL 2K

    I am creating a table for holding data used for data wear-housing project.
    This table will eventually going to have millions of records.
    Planned to have a primary key and proper indexing in this table.
    This table will be queried against various columns and will be refreshed
    (fill data) on a weekly basis.

    Is there any other approach I should think about like - Partitioned views or
    ??

    Any thoughts/Ideas will be highly appreciated.

    Thanks
    Sh


    Shamim Guest

  2. #2

    Default Re: Table design

    First of all, consider using ysis Services for querying. Check the "Data
    Warehousing and OLAP" module in Books OnLine
    (mk:MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\ol
    apdmad.chm::/agaboutolap_9i5s.htm).

    --
    Dejan Sarka, SQL Server MVP
    FAQ from Neil & others at: [url]http://www.sqlserverfaq.com[/url]
    Please reply only to the newsgroups.
    PASS - the definitive, global community
    for SQL Server professionals - [url]http://www.sqlpass.org[/url]

    "Shamim" <shamim.abdulrailamerica.com> wrote in message
    news:eml2mZLQDHA.2316TK2MSFTNGP11.phx.gbl...
    > SQL 2K
    >
    > I am creating a table for holding data used for data wear-housing project.
    > This table will eventually going to have millions of records.
    > Planned to have a primary key and proper indexing in this table.
    > This table will be queried against various columns and will be refreshed
    > (fill data) on a weekly basis.
    >
    > Is there any other approach I should think about like - Partitioned views
    or
    > ??
    >
    > Any thoughts/Ideas will be highly appreciated.
    >
    > Thanks
    > Sh
    >
    >

    Dejan Sarka Guest

Similar Threads

  1. Efficient Table Design
    By capik79 in forum Coldfusion Database Access
    Replies: 2
    Last Post: June 12th, 01:46 PM
  2. Making table cells available at design time
    By Christophe Peillet in forum ASP.NET Building Controls
    Replies: 4
    Last Post: April 15th, 01:31 AM
  3. I cant see most of the table in Dreamweaver Design View
    By cosmicbeach in forum Macromedia Dynamic HTML
    Replies: 1
    Last Post: October 22nd, 12:14 PM
  4. interior design - coffee table book ?
    By dillontdaniel webforumsuser@macromedia.com in forum Macromedia Fireworks
    Replies: 3
    Last Post: September 23rd, 12:51 PM
  5. coffee table book - interior design ?
    By dillontdaniel webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 1
    Last Post: September 22nd, 12:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139