Viewing 15 posts - 2,161 through 2,175 (of 3,060 total)
rojen83 (1/23/2010)
Handle Transaction (Rollback/Commit) when applicable. Regards, ... If that's the case, temporary tables will not work. I have tried it for a couple cases
:blink: either this is spam or...
_____________________________________
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.March 31, 2010 at 6:08 am
AndrewSQLDBA (3/30/2010)
_____________________________________
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.March 30, 2010 at 3:01 pm
Don't think the Oracle section of the forum is the right place for this question.
I would consider opening a ticket with FairCom.
_____________________________________
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.March 30, 2010 at 2:50 pm
endo64 (3/26/2010)
for ex.
table A (a_id, b_id)
table B (b_id, value)
select * from A left (inner) join B...
_____________________________________
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.March 30, 2010 at 2:21 pm
repent_kog_is_near (3/24/2010)
Paul,Do you have a link for Kimball's star-schema that you refer to, for OLAPs?
My pleasure... try this one http://www.consolidata.co.uk/Data-Warehousing/What-is-DWH/Star-Schema/default.aspx
_____________________________________
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.March 25, 2010 at 1:28 pm
repent_kog_is_near (3/24/2010)
3NF+ for OLTP and 0 NF for OLAP?
I wouldn't go that far.
I'm in agreement about 3NF+ for OLTP - actually I do believe there is nothing you can't solve...
_____________________________________
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.March 24, 2010 at 1:26 pm
I would start with SQL Server Upgrade Advisor ... check this http://msdn.microsoft.com/en-us/library/ms144256(SQL.90).aspx
_____________________________________
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.March 24, 2010 at 11:51 am
repent_kog_is_near (3/23/2010)
I am sure the good logical design (Normalization) is very critical.
Even when normalization to -at least- the 3NF is critical for an OLTP system allow me to point that...
_____________________________________
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.March 24, 2010 at 11:43 am
Annoying, huh? Doesn't happens to me.
_____________________________________
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.March 24, 2010 at 11:35 am
ronaldkrex (3/24/2010)
What do you mean by Upper?
I mean... use upper() function on both ends of the condition as shows in 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.March 24, 2010 at 11:29 am
upper(Name) LIKE upper(@Name) or @Name IS NULL
also remember to add "%" ... like in: upper(name) like upper('Jerem%')
_____________________________________
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.March 24, 2010 at 11:21 am
Yes.
Check here... http://msdn.microsoft.com/en-us/library/ms151188.aspx
_____________________________________
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.March 24, 2010 at 6:17 am
Two troubleshooting suggestions...
1- What happens if you run view's underlying query from SQL Server?
2- Would you mind in showing the result of "select instance_name from v$instance;" from both the Oracle...
_____________________________________
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.March 21, 2010 at 4:24 pm
looks like a text-book case for a pivot query ... bing "sql server pivot"
_____________________________________
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.March 15, 2010 at 9:25 am
George Murphy (3/11/2010)Can you recommend a good script which can auto generate a soultion like yours?
Problem would probably be compatibility ... I'm pretty sure GSquared's solution generator only runs on...
_____________________________________
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.March 11, 2010 at 2:48 pm
Viewing 15 posts - 2,161 through 2,175 (of 3,060 total)