Click to See Complete Forum and Search --> : SQL Date types performance


menny_ed
March 13th, 2005, 08:08 AM
Hi.
I want to change a column in a table from BIGINT to DECIMAL or NUMERIC.
But i wonder, what is the performance loss when doing sorts,filters, arithmetic operations (like multiply and adds) on these data types (dec and numerics)

thanks

aquafin
March 17th, 2005, 04:49 AM
hi
check this :

http://www.sql-server-performance.com/datatypes.asp



Best Regards