Thanks for reply!

Earlier I was collecting data in some temporary table so that I can use it as input to query on main table. Now I have removed that part...

Hi,

may be this question is not related my original concern.

But I have added one non clustered index column in select list. Now performance in significantly increased.

is index helpful when we...

OK. One additional question. Suppose one non clustered index is already there on multiple columns and some of columns I am using in where clause.

Does that index help in...

Check constraint does work in way what I have mentioned in a problem.

May be logic what I have written in the function which is getting called from constraint is...

Thanks! 🙂

as I wanted to write that statement in single statement but I think I have to right multiple statements like

DECLARE @context varbinary(128)

SET @context = CAST('xyz' AS varbinary)

SET...