Viewing 15 posts - 1,426 through 1,440 (of 3,060 total)
qaz123 90964 (10/9/2010)
For example
select * from linkserver..dbname.my_table
in SQL 2000 reportedly caused locking...
_____________________________________
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.October 11, 2010 at 8:52 am
Lowell (10/11/2010)
One of the wierd things in Oracle is that an empty string ('') is considered NULL, which...
_____________________________________
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.October 11, 2010 at 8:30 am
dwmllr (10/10/2010)
Your suggestion is an option. I was hoping to find a way to get around the SQL Server issue without cluttering the integration code. ...
_____________________________________
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.October 11, 2010 at 7:53 am
Raghavender (10/11/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.October 11, 2010 at 5:31 am
Jeff Moden (10/10/2010)
PaulB-TheOneAndOnly (10/8/2010)
grahamc (10/8/2010)
So if its a memory, CPU issue, it will scale.... Cool!!! Thank you makes a little more sense now
The focus of Oracle RAC is high availability...
_____________________________________
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.October 10, 2010 at 7:25 pm
mail4sha (10/9/2010)
In Oracle, we can set the public variable/constant/types/curosors in the Package specification, Could you please tell me that how to achieve the same functionality in the SQL server.
There is...
_____________________________________
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.October 10, 2010 at 6:47 pm
Michael Valentine Jones (10/8/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.October 8, 2010 at 3:15 pm
grahamc (10/8/2010)
So if its a memory, CPU issue, it will scale.... Cool!!! Thank you makes a little more sense now
The focus of Oracle RAC is high availability 🙂
You can...
_____________________________________
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.October 8, 2010 at 12:21 pm
LAG() is actually a PL/SQL analytic function.
I agree IS_VALID_DATE() is a custom function usually coded like:
create or replace FUNCTION IS_VALID_DATE(pStr VARCHAR2, pFmt VARCHAR2) RETURN NUMBER
IS
vRet NUMBER := 0;
vDate DATE :=...
_____________________________________
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.October 8, 2010 at 11:45 am
LadyRuna (10/8/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.October 8, 2010 at 11:34 am
grahamc (10/8/2010)
since you have it running... does that mean if you have a RAC environment running, that if you are hitting performance problems that a shiny new server can...
_____________________________________
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.October 8, 2010 at 7:31 am
grahamc (10/8/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.October 8, 2010 at 7:01 am
Gianluca Sartori (10/8/2010)
PaulB-TheOneAndOnly (10/8/2010)
saurabh.deshpande (10/8/2010)
So, what they are giving new with Oracle 10g/11g.So, what's new?
Now it works 😉
Really, does it? 😛
It does indeed - surprised? 😀
_____________________________________
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.October 8, 2010 at 6:47 am
Jeff Moden (10/8/2010)
GilaMonster (10/8/2010)
Jeff Moden (10/8/2010)
Why wouldn't "Federated Servers" in SQL Server do the same thing?
That's when you split a database across multiple servers so that each holds a piece.
RAC...
_____________________________________
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.October 8, 2010 at 6:46 am
dwmllr (10/8/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.October 8, 2010 at 6:42 am
Viewing 15 posts - 1,426 through 1,440 (of 3,060 total)