I have moved recently to a project, which is running fine in production for last 3 yrs.
now when i am handling the performance issues, i have observed that there are lot code in vb.net files and lot code in script i.e. in stored procedures. most of the columns are defined as allow nulls, due to lack of proper requirement/coding, now there is lot of data with NULLs
to handle these nulls in the script(sp), written case statements.
So could any one help me out now, what is the better way to tune this issues, from the vb.net code and script of the stored procedures.