ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,821 through 8,835 (of 10,143 total)

RE: Display query results as a treeview

What have you tried so far?
Please post table structures and sample data. You may find it helpful to read the article in the link below.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 6, 2009 at 5:59 am

#939407
RE: Query needed

Nikhil (2/6/2009)
i tried with joins but it didnt work as price column was ambiguous as i was willing to populate prices for all
Please read the link below. People will be...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 6, 2009 at 5:11 am

#939394
RE: Query needed

What have you tried so far?
Please read the link below, it will show you how to create sample data.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 6, 2009 at 4:54 am

#939389
RE: Need help Performance issue: Taking 34 minutes to execute query

KSB (2/5/2009)
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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 5, 2009 at 12:54 pm

#939135
RE: Using: CASE, ISNULL(), NULLIF(), COALESCE()

Thanks for the feedback eddy. Please be advised that this type of construction can cause performance problems if the cached plan is a poor match for the parameters received when...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 5, 2009 at 6:53 am

#938796
RE: Using: CASE, ISNULL(), NULLIF(), COALESCE()

SELECT * FROM [BASISREL] AS b
WHERE PAR_ID_FIRMA = @FirmaId
AND [PAR_ID_TYPE] = CASE WHEN @var < 20 THEN @var ELSE [PAR_ID_TYPE] END
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 5, 2009 at 6:06 am

#938757
RE: Need help Performance issue: Taking 34 minutes to execute query

Thanks for the feedback Suresh. Participants in this thread, including myself, would be interested to see exactly how you implemented the changes which solved your problem - can you post...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 5, 2009 at 4:10 am

#938707
RE: POOR QUERY PERFORMANCE

nikhil.verma (2/5/2009)
Hi Chris
With this i am not getting correct results for qty_tested , dty_failed. Counts are different.
Without seeing the code you are using now and the code you were using...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 5, 2009 at 4:08 am

#938705
RE: Need help Performance issue: Taking 34 minutes to execute query

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 > 0
AND prof_sec.profile_key > 0
isn't an INNER...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 5, 2009 at 1:13 am

#938631
RE: not both

Hi
Put it in brackets, like this:
AND NOT (Server = 'SQL005' and Drive = 'G')
Cheers
ChrisM
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 4, 2009 at 10:25 am

#938172
RE: Slow Stored Procedure run time

Lowell (2/4/2009)
yep same issue as the post here:http://www.sqlservercentral.com/Forums/Topic649831-8-1.aspx
i put a decent explanation and fixes there.
Top work Trinny, I was just about to post this one in.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 4, 2009 at 8:48 am

#938031
RE: Slow Stored Procedure run time

Chuck, run a search (on this forum) on parameter sniffing. If this is the problem, which seems likely, then the solution can be pretty straightforward.
Cheers
ChrisM
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 4, 2009 at 8:39 am

#938015
RE: Changed to a StarWars Avatar...am I part of the Club now?

Lowell (2/3/2009)
Noted a strong theme among the high posters that everyones shifted to a Star Wars Avatar...
It even affects How people post, what with the Yoda grammer.
i broke down and...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 4, 2009 at 6:36 am

#937894
RE: How can you supress the dash line in the output

david.kelly (2/3/2009)
Thanks. Life is just too short to be irritated all the time. 😛
Commendable philosophy, David. Not only that, it's now beertime! 😀
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 3, 2009 at 9:59 am

#937289
RE: How can you supress the dash line in the output

david.kelly (2/3/2009)
:angry:I can feel the pain and I also suffer with it.
I believe what we are trying to discover is how do we turn off the dashed line in query...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 3, 2009 at 9:43 am

#937267

Viewing 15 posts - 8,821 through 8,835 (of 10,143 total)