Integer or Numeric

Expand Post »

Hi,
I've imported a Visual FoxPro database to MS SQL Server 2008 and had a couple of queries;
The VFP tables used Numeric(5,0) for the Index fields, but I'm thinking of converting them to Integers in SQL Server. Is there any issues I should be aware of? A co-worker keeps telling me that Integers are "slower" to search on, which I find a bit hard to believe. I always thought that you would you use Numerics for data that requires precision, such as financial data and Integers for counters whole number id's and so on. Am I wrong or missing something?

Thanks

Similar Threads

run time error "13" type mismatch in Visual Basic 4 / 5 / 6
Running out of Memory in Windows Vista and Windows 7
Problem with Arrays in Java
sum the sequence in C++
Arrays in C++

Wenners

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Apr 2009

Permalink

Nov 3rd, 2009

Re: Integer or Numeric

>>A co-worker keeps telling me that Integers are "slower" to search on, which I find a bit hard to believe
He's an idiot.

Integers are fine. Just be sure to index your database properly -- and this is regardless of datatype (string, integer, decimal, etc).

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: SSRS delete blank rows

Next Thread in MS SQL Forum Timeline: Stored Procedure with Increments

DaniWeb Message

Cancel Changes

User Name
Password