Thanks very much for discussing on the article regarding performance issues. I have just shown a new approach to split strings with the help of XML and a very good...

There is nothing much in that. Just take the XML source in data flow and then it will ask you that whether you are providing XSD or it will...

Are you generating the XSD or it is automatically generated while selecting the XML source in Data Flow.

Try generating it automatically through the XML source task in Data flow.

Then you...

Yes, triggers will always be fired if you have return it on an insert statement. It is independent on whether you are using cursors or using any other alternative to...

Carla's comparison was really very nice.

Thanks I have learnt a lot many new things by writing this article

select personid, version, dedate,

row_number() over (partition by personid order by version) as VersionOrder,

row_number() over (partition by personid order by dedate) as DeOrder,

case when row_number() over (partition by personid order by...

Reply to :Why use the cross join?

Yes it could be done in a way you have shown but then the whole personid should be marked as improper if any DEDATE...

Performing task with two tables??

Could you please clarify your query??

Thanks

Yes it will optimize the performance of the query