By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,787 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

How to decide optimum type

P: 9
Hi,
I use sql server 2005. I want to store values into a field. The values are floating point numbers. A value in the field can only be in the format of #####.### like 12345,678.

So i want to learn which type i should use for this field to provide better performans and memory improvement. Should i use decimal(5,3), float, number or anything else?
Aug 20 '09 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
Depending to a number of factors, including max and min value of your content, the number of records of your table, to assess your table size, etc...

You can start from here

Good luck!!

-- CK
Aug 22 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.