Good question. 🙂

+1

Thanks Ankush. If I ever get such chance again, wil test this option. 🙂

It's beautiful becuase it is working as expected. Definitely i'll try to see if it can be made more healthy. I still have to check how it works with the...

Thanks a ton Eugene. 🙂 It's beautiful.

I'll take care of the point you made about posting code.

I have some enhanced requirement now and it seems little more tricky than previous one. Half of the work is done but i'm stuck at one place. So i have...

Thanks Chris. it works like charm. Though I'll check the performance of both on big data sets and will post here as well. 🙂

I was able to get the much needed solution. Here are the queries to generate the data:

create table #t11

(col1 varchar(10), col2 int, col3 varchar(10))

insert into #t11

select 'XYZ', 12, 'RXM' union...

Nice question. 🙂

Thanks Jeff. I compared the two execution plans and saw that with where clause it was considering clustered index scan for one of the table while without where clause OR...

I tried refreshing view as well. One more thing i noticed now that it's working fine when running without where clause but issue remains when run with where condition....

+1...

The heading almost got the better of me. But faith on yourself has biggest power. 🙂

Really a day to day usage part... 🙂

Dedicate my points to Google. Never worked on DQS so had to take help. Good to learn new thing atleast. 🙂