ok.Thank you.

Thank you.It is working fine.

ok.Thank you.

Thank you.I disabled the index and testing the performance,but i want to know whether any order or sequence to recreate the dropped indexes.

• This reply was modified 5 years, 8 months ago by  jkramprakash.

yes.i checked the actual execution plan,it is not  showing the particular index in the plan and i am using the query in my stored procedure.Instead of dropping the index i...

As per the suggestion of previous post,now i am testing by removing the replace functions in the
TP.F_PRODUCT_NAME column(REPLACE(REPLACE(REPLACE(REPLACE(TP.F_PRODUCT_NAME, '™', '|TM'), '®', '|TS'), '©', '|CP'), '°', '|DEG'))in this procedure.I am...

The Product_Name column in the table  contains lots of special characters like '®' ,'©',so i have to replace with TM,TS and CP characters.So now  i am going to try with Computed columns...

1 yes the index on Product_Name wee a bit of problem in future if it exceeds the 900 bytes.But index was created for
Product_Name with warnings.whether sqlserver will use...

Thank you for the valuable suggestion.

Thank you.I will suggest this idea to my management.

Good Idea.U are telling backup and restore the data base from one server into target server and then execute the above command.i think it is easy and copy the records...

u have any sample program?