Thanks Mr. Gianluca,

It does give me some insight. What I was looking for through this question was as to "How the SSIS tasks work at the backend during parallel execution?"

I...

Thanks Gila Monster for the clarification.

I think in the given scenario Jeff's solution with CTE is best possible.

But in case you want to dwell in subqueries. Can you please post the result that you...

There is no requirement as such. I just wanted to know how can I execute the 2 queries together

( Insert into xyz values (1,2,3)

GO

Insert into uvw values (1,2,3)

GO

)

and not...

Hi All,

Thanks a lot for your thought. As, I can't change the schema. I think the most suitable suggestion that worked for me is the Update and then indexing the...

I thought of another thing while table creation

Ex.

Thanks a lot opc.three for your help and the link.

Cheers,

Ankit

Hi SS

Thanks for the suggestion.migration_db is a staging database and in the existing framework the script with isnull has been wrapped in a view, and further processed as a join...

does this mean there is no other option to enhance this query ?

can you elaborate on what does flushing of the isnull mean?

HI,

I am struck in the following query and want to know how to improve its performance for 2 mn records.

SELECT [1].areabuilding,

[10].yearvalue,

[2].bldgscheme as bldgscheme_dvt,[2].bldgclass as bldgclass_dvt,[2].bldgclasstier1 as bldgclass_dvttier1,[2].bldgdesc as bldgdescdvt,

[3].bldgscheme,[3].bldgclass,[3].bldgclasstier1,[3].bldgdesc,

[4].cflag,[4].cflagcode,[4].bldgclassflag,[4].numstoriesflag,[4].yearvalueflag,[4].occtypeflag

,[4].areabuildingflag,[4].bldgclasstier1flag,[4].occgrpflag,[4].isEligibleAcrossSource,[4].isEligibleInSource,

[5].flagname as...