Hi experts ,
My developer sent me a query to review which is looks like
ALTER PROCEDURE [dbo].[PDFDocumentCreate]
Is that something i can change datatypes like he is using DocumentData for CHAR(10 ) .
please help me out thanks
asked Apr 19 at 04:00 PM in Default
Choosing the right datatype is very important for performance. From what I can see there are some strange datatypes that I should investigate further. Like DocumentDate, DocumentTime, CreationDate, CreationTime. Personally I think they should be stored in date vs time columns as it will save some bytes, but You should investigate how the parameters are used. If they are used in where clauses or join clauses, You have to make sure that the columns have the same datatype and lenght as the parameter, otherwise you'll get an implicit conversion that will cause performance issues
answered Apr 24 at 05:54 PM