February 11, 2011 at 10:14 am
Hi All,
I have few stored procedures in my server which were developed long back .I found few stored procedure parameters whose data type(Size ) is not equal to the data type size in the column.
Will this have any performance issues?
Example: per say my Table1 (Name varchar(32),Address(64))
But the stored procedure: create procedure @name varchar (16), @Address varchar(32)
Does using less data type size have any effect on the performance issues (Hash Collisions?)
Thanks in Advance.
February 11, 2011 at 10:33 am
If it's the other way around, you can run into truncation problems when a parameter is larger than its target column. This way, with the parameter smaller, it won't matter.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply