Loading ...
Sorry, an error occurred while loading the content.

6448Re: Design a table for Lookup in sql server 2008

Expand Messages
  • vijaya_krishna_birju
    Jun 1, 2009
      Hi Vemuri,
      what is the access pattern of that table? i.e When you query this table what kind of queries you are going to use?
      Thanks -- Vijaya Kadiyala
      www.DotNetVJ.com

      --- In sqlcon@yahoogroups.com, "sree" <vemuri_sree@...> wrote:
      >
      > Hi Team,
      > I am facing some problems on designing the look up table.
      >
      > We are going to move data by using lookup table and for that I have designed few columns based on the data like this..
      >
      > ID,tablename,S_char, S_int, T_int, T_char, T_bit
      >
      > When I insert my data to corresponding fields with 4K rows, rest of the columns are having NULL values. Is there any issue with performance wise or any otherÂ…
      >
      > Instead of that can I go with 2 columns one is source and 2nd one is target value with "nvarchar" data types.
      >
      > Which approach is good and how best I can go with that. Is it required any check constraint for the 2nd approach?
      >
      > Please help me in that and one more we don't have any relationship with this table, it's an independent table.
      >
      > Thanks in advance.
      >
      > Vemuri
      >
    • Show all 4 messages in this topic