Viewing 15 posts - 1,186 through 1,200 (of 3,060 total)
YSLGuru (2/7/2011)
OK Paul I will read it through in it entirety this time.
Please do. Every decent rdbms has this feature nowadays, SQL Server calls it "Plan Guides", Oracle calls it...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 7, 2011 at 2:01 pm
Oracle documentation is free so, when in doubt RTFM 😉
Here http://www.oracle.com/pls/db102/portal.all_books
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 7, 2011 at 10:54 am
dndaughtery (2/7/2011)
Does anyone know where to apply for SQL Server positions in Austrailia and/or the bahamas, virgin Islands etc?
Just bing: sql server job offers xxxxxx
where: xxxxx = australia, bahamas, virgin...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 7, 2011 at 10:50 am
sqlgreg (2/7/2011)
I was just about the post the answer when I saw your reply! Thanks!I didn't know what to search for in the Oracle documentation.
That's why God created forums ...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 7, 2011 at 10:43 am
YSLGuru (2/7/2011)
PaulB-TheOneAndOnly (2/5/2011)
YSLGuru (2/5/2011)
Well that would certainly be one way to do it....and the other way is Plan Guides; check link on my previous post 😉
Paul - I...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 7, 2011 at 10:03 am
sqlgreg (2/7/2011)
Unfortunately, there is not a test...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 7, 2011 at 9:56 am
Yash Ganthe (2/5/2011)
ADD PK USING INDEX is not supported in SQL Server.This is an Oracle feature.
You are absolutely correct - I shouldn't be posting on Friday afternoon 🙂
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 6, 2011 at 9:39 am
YSLGuru (2/5/2011)
Well that would certainly be one way to do it.
...and the other way is Plan Guides; check link on my previous post 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 5, 2011 at 4:56 pm
Let me translate, compatibility level will affect query behavior in the sense that query optimizer will be limited to the "compatibility level" you have set, it will not use any...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 5, 2011 at 4:47 pm
brucecphillips (2/5/2011)
I am moving data from a large warehouse (hundreds of billions of rows) that I will be using for later analysis.
I...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 5, 2011 at 4:36 pm
AND 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 5, 2011 at 4:30 pm
YSLGuru (2/5/2011)
After some testing over time I've narrowed done the problem with...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 5, 2011 at 4:25 pm
David McKinney (2/4/2011)
Thanks, captain. Exactly the link I was looking for.I'm not thrilled by this behaviour but at least it's documented and 'by design'.
Behaviour is there to deal with...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 4, 2011 at 8:23 am
Yash Ganthe (2/4/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 4, 2011 at 8:11 am
ironoverload (2/2/2011)
4 Tables t1-t4, t1-t3 each have unique records that when entered into 3 fields in t4 produce a combined unique record.
t1
Field1(PK)
t2
Field1(PK)
t3
Field1(PK)
t4
t4.Field1=t1.Field1
t4.Field2=t2.Field1
t4.Field3=t3.Field1
The result of...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 4, 2011 at 8:07 am
Viewing 15 posts - 1,186 through 1,200 (of 3,060 total)