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.
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 muchVinodEven 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] |
|
|
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 getRahul Arora MCA 07 BatchNCCE Israna, PanipatHRY, INDIA |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2007-11-01 : 13:21:12
|
quote: Originally posted by khtanI wish i have the Sweden SQL tool to help me write my query
You do. Peso's from Sweden, isn't he? |
|
|
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 muchVinodEven you learn 1%, Learn it with 100% confidence.
What are you talking about?The optimizer picks the best method for what query you writeYou don't pick the way the optimizer choosesYou can use hints, but that differentquote: arorarahul.0688 Posted - 11/01/2007 : 06:13:32hi 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 Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
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 performanceVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-02 : 03:20:21
|
Posting code and errors is always helpful.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
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 performanceVinodEven 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 doingI'm guessing you are using nolock, and , oh, to your amazement, the row is not there for the updateShockingBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
|
|
|
|