Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Types of joins in version wide

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-11-01 : 02:05:44
Dear All,
what are different types of joins avialable with sql server6.0, 7.0, 2000 and 2005 and now 2008...

the reason behind the question is :

i've used the swiss Sql tool to boost the performance of my join queries. and the tool has given some best options. those are working fine with database but failing at application level.

i found the reason is because of Loop join, Hash Join, Merge join.


your valubel suggsions are needed.


thank you veru much

Vinod
Even you learn 1%, Learn it with 100% confidence.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-11-01 : 02:11:18
quote:
swiss Sql tool

I wish i have the Sweden SQL tool to help me write my query


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

arorarahul.0688
Posting Yak Master

125 Posts

Posted - 2007-11-01 : 06:13:32
hi thanks for awaking me abt this issue by sql forum
i will try for this and certainly put the result i will get
its a request put your result also what ever u get


Rahul Arora
MCA 07 Batch
NCCE Israna, Panipat
HRY, INDIA
Go to Top of Page

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2007-11-01 : 13:21:12
quote:
Originally posted by khtan
I wish i have the Sweden SQL tool to help me write my query



You do. Peso's from Sweden, isn't he?
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2007-11-01 : 13:56:57
quote:
Originally posted by sunsanvin

Dear All,
what are different types of joins avialable with sql server6.0, 7.0, 2000 and 2005 and now 2008...

the reason behind the question is :

i've used the swiss Sql tool to boost the performance of my join queries. and the tool has given some best options. those are working fine with database but failing at application level.

i found the reason is because of Loop join, Hash Join, Merge join.


your valubel suggsions are needed.


thank you veru much

Vinod
Even you learn 1%, Learn it with 100% confidence.



What are you talking about?

The optimizer picks the best method for what query you write

You don't pick the way the optimizer chooses

You can use hints, but that different

quote:

arorarahul.0688 Posted - 11/01/2007 : 06:13:32

hi thanks for awaking me abt this issue by sql forum
i will try for this and certainly put the result i will get
its a request put your result also what ever u get




Go back to sleep





Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-11-02 : 02:59:17
the hints are giving errors at application level...
in database those are giving a good performance

Vinod
Even you learn 1%, Learn it with 100% confidence.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-02 : 03:20:21
Posting code and errors is always helpful.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2007-11-02 : 08:57:05
quote:
Originally posted by sunsanvin

the hints are giving errors at application level...
in database those are giving a good performance

Vinod
Even you learn 1%, Learn it with 100% confidence.



And why would that be?

First off, you should not use hints unless you are sure of what you are doing

I'm guessing you are using nolock, and , oh, to your amazement, the row is not there for the update

Shocking



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -