Perfomance tunning of SQL query which has Inner joins

Question

Post reply

Perfomance tunning of SQL query which has Inner joins

anjan.ashok

SSCrazy

Points: 2783
More actions
June 11, 2008 at 10:17 am

#208290

Hi,

I want to do Perfomance tunning of SQL query which has Inner joins.

As this query is taking more time to run and is giving the error

: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

so pls help me how to tune this query which has joins.

Pls reply asap.

Thanks in advance.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 1

Lynn Pettis

SSC Guru

Points: 442447

June 11, 2008 at 10:26 am

#827388

Big request with no information to work with. For better help fast, read the following article:

http://qa.sqlservercentral.com/articles/Best+Practices/61537/

😎

noeld SSC Guru Points: 96590 More actions · Answer 2

noeld

SSC Guru

Points: 96590

June 11, 2008 at 10:52 am

#827406

Sample Query, Data and DDL are required to answer your question.

* Noel

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 3

... And the execution plan from your own environment.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

anjan.ashok SSCrazy Points: 2783 More actions · Answer 4

The query to be tunned is like this to

select * from test.samp_id,test.b_id,

case when (test.case_active='N' and sample.case_te_date is null)

then 'In Active' when (not tbl_test.case_te_date is null)

then 'Marked for Del' else 'Active'

End as caseactiveyn,a.case_fi_num,test1.comments,test.case_desc,

isnull(test.case_n_fname,'')+' '+isnull(test.case_n_miname,'')+' '

+isnull(teste.case_n_lname,'')

any suggesstion pls

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 5

Sorry to say this, but this doesn't even appear to be a proprerly written query.



select * from test.samp_id,test.b_id,

case when (test.case_active='N' and sample.case_te_date is null)

then 'In Active' when (not tbl_test.case_te_date is null)

then 'Marked for Del' else 'Active'

End as caseactiveyn,a.case_fi_num,test1.comments,test.case_desc,

isnull(test.case_n_fname,'')+' '+isnull(test.case_n_miname,'')+' '

+isnull(teste.case_n_lname,'')

anjan.ashok SSCrazy Points: 2783 More actions · Answer 6

anjan.ashok

SSCrazy

Points: 2783

June 11, 2008 at 2:08 pm

#827510

Its just an example thats it.

It looks like this...

John Rowan SSC Guru Points: 56440 More actions · Answer 7

So you're asking for help tuning a query containing joins and you post a sample query with only the SELECT clause? How in the world are we supposed to help you? Please read the link that Lynn has posted and help us help you.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden