Table design - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Table design

Author

Topic

abc123
Starting Member

47 Posts

Posted - 2009-02-17 : 23:37:15

I have following design requriement

col_name values values values
col1 abc opo ghi
col2 xyz lmn pqr
col3 Delta Delta1 Delta3

here Delta,Delta1,Delta3 have following values
Delta Delta1 Delta3
0.01 0.03 0.10
0.02 0.09 0.08
0.07 0.99 0.98

Plz tell me how i can design the table for the above Scenario for better performance?

abc123
Starting Member

47 Posts

Posted - 2009-02-18 : 01:45:07

Any suggestion on the same

Jai Krishna
Constraint Violating Yak Guru

333 Posts

Posted - 2009-02-18 : 03:27:57

for this type of values abc opo ghi varchar(n) field is best
and for 0.02 0.09 0.08 use numeric(p,s) datatype

Jai Krishna

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources