We have to search string from NVARCHAR COLUMN,it is has a lakhs of records and taking long time, in this situation how to improve fast performance
Use collate Latin1_General_100_Bin2 type for fast performance. But values Must Change into either Lower or Upper case in Both sides.
Example:select * from table where description like '%sql server%'
select * from table where UPPER(description) like '%SQL SERVER%' collate Latin1_General_100_Bin2
select * from table where LOWER(description) like '%sql server%' collate Latin1_General_100_Bin2