Viewing 10 posts - 91 through 101 (of 101 total)
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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
February 5, 2009 at 5:25 am
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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
February 5, 2009 at 4:03 am
Hi Grant Fritchey,
The first question I would ask is, do you really need 8000+ rows?
Yes, I want all these 8000 rows.
For example, you're getting a scan on dim_project_secure's clustered index....
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
February 4, 2009 at 10:46 pm
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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
February 4, 2009 at 8:06 am
Please find attachment of execution plan.
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
February 4, 2009 at 7:10 am
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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
January 9, 2009 at 6:27 am
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:...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
January 9, 2009 at 4:00 am
I attached few execution plans.
check these and give me any suggestion.
KB
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
January 9, 2009 at 12:15 am
Thanks guys.
I will have a play around with that today.
KB
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
January 7, 2009 at 11:25 pm
Nice article. Really good one.
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
November 18, 2008 at 12:53 am
Viewing 10 posts - 91 through 101 (of 101 total)