Hi GSquared,

Yeah, your query helped me. And now i have to update the same to the same table and need to delete the second row.

Thanks.

ChrisM,

Here is my code.

SELECT DISTINCT prof_sec.profile_skeyAS profile_skey,

acct_sec.account_skey

INTOdbo.profile_assoc_security

FROMdim_account_secureacct_sec, dim_profile_secureprof_sec

--INNER JOINdim_profile_secureprof_sec

--ONacct_sec.account_key > 0

--ANDprof_sec.profile_key > 0

INNER JOIN #TempAssociateObjectstemp_assoc_obj

ONtemp_assoc_obj.assoc_object_skey = prof_sec.profile_skey

WHERE EXISTS (SELECT 'X' FROM project_securityproj_security

WHERE proj_security.account_skey = acct_sec.account_skey

ANDtemp_assoc_obj.object_skey= proj_security.project_skey

)

AND NOT EXISTS (SELECT...

ChrisM,

Suresh, your statement is syntactically correct but almost certainly won't give the results you are expecting.

This...

FROM dim_account_secure acct_sec

INNER JOIN dim_profile_secure prof_sec

ON acct_sec.account_key...

Hi Grant Fritchey,

Yes, I want all these 8000 rows.

For example, you're getting a scan on dim_project_secure's clustered index....

Hi Grant Fritchey,

"Are you sure you have the right indexes in place and you're using them appropriately or is it just because you're moving so much data that the indexes...

Please find attachment of execution plan.

Hi,

Performance is big problem in my sproc. Thats why I just wanted to avoid dynamic sql and now adding 2 INSERT statements.

This looks like 2 INSERT statements, one with a...

Hi ALZDBA,

I added

set statistics IO on

set statistics time on.

Also I removed all the commented lines in dynamic sql.

And i got this output.

SQL Server parse and compile time:...

I attached few execution plans.

check these and give me any suggestion.

KB

Thanks guys.

I will have a play around with that today.

KB

Nice article. Really good one.