Viewing 15 posts - 2,086 through 2,100 (of 3,060 total)
Why not natural keys?
RefAtbl <===>> RefBtbl
Columns in RefAtbl... ID; Key = ID
Columns in RefBtbl... ID,OtherNumber; key = (ID+OtherNumber)
_____________________________________
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.April 10, 2010 at 1:19 pm
gratefuldba (4/10/2010)
Does anyone have an opinion as to the merits and disadvantages of using SQL Server maintenance plans to implement our SQL Server database / transaction log backup strategy ?
Easiest...
_____________________________________
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.April 10, 2010 at 1:11 pm
last() returns the last row of a result set - doesn't it?
A brute force solution would be to select top 1 blah-blah-blah order by blah-blah DESC
_____________________________________
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.April 10, 2010 at 1:00 pm
For SQL Server varchar() not larger than 4000 bytes Oracle's varchar2() would do the trick.
For SQL Server varchar() larger than 4000 bytes receiving Oracle column should be a CLOB.
Since CLOB...
_____________________________________
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.April 10, 2010 at 12:55 pm
info-849042 (4/10/2010)
how do I implement a many-to-many relationship in SQL Server
This shold be done at modeling phase independent of the technology of choice therefore you do it as you do...
_____________________________________
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.April 10, 2010 at 6:41 am
datepart() function would do 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.April 9, 2010 at 4:49 pm
You are looking for latence then forget the app layer... just ping 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.April 9, 2010 at 4:34 pm
I would schedule a blackout window on SQL Server side so to accomodate Oracle side maintenance window.
_____________________________________
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.April 9, 2010 at 12:05 pm
PaulB - Is there an easy way to describe or point me to something (a name, a website) that would talk about the infrastructure that would support this? Would...
_____________________________________
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.April 9, 2010 at 11:57 am
1- Yes. Depends on infrastructure and design.
2- No. Yes.
3- Sure you can do it. Dozens of choices.
4- Depends on the features you want to have available.
_____________________________________
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.April 8, 2010 at 3:38 pm
I agree with NJ-DBA that transactional replication may be the right solution for this scenario.
The Production-Reporting tandem of databases is a valid strategy - usually a first step in the...
_____________________________________
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.April 8, 2010 at 1:57 pm
Once you got everything in place do the 1-2 punch test...
1- ping whatever dns or ip-address you provided for the host in tnsnames entry
2- after #1 works, tnsping the tnsnames...
_____________________________________
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.April 8, 2010 at 12:47 pm
Just out of curiosity ... does the business requirements really ask to drop a column that is part of a PK? really? :blink:
On the same line of thinking... why if...
_____________________________________
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.April 8, 2010 at 12:42 pm
would you mind in formatting your query properly? pretty please?
_____________________________________
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.April 8, 2010 at 12:38 pm
chandrasekaran.ganapathy (4/8/2010)Here What is the use of creating Index?
Allow me to answer you with a question... What is the use of having an index in a book? perhaps...
_____________________________________
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.April 8, 2010 at 12:35 pm
Viewing 15 posts - 2,086 through 2,100 (of 3,060 total)