Viewing 15 posts - 2,071 through 2,085 (of 3,060 total)
chris.stuart (4/3/2009)
_____________________________________
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 14, 2010 at 7:54 am
Ratheesh.K.Nair (4/14/2010)
one more doubt will creating index on tables improves performance??
During INSERT, the more indexes you have on target table the more overhead you are adding to the process a.k.a....
_____________________________________
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 14, 2010 at 7:48 am
Sasidhar is correct.
FKs are there to enforce referential integrity rules. No referential integrity rules takes into consideration one child row with two alternative parents.
If this is a business spec 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 13, 2010 at 11:15 am
As pointed by Jason an Oracle person wrote the question.
In the Oracle world a explicit cursor is a cursor you define in the "declare" section - this is pl/sql stuff...
_____________________________________
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 13, 2010 at 10:48 am
bladerunner148 (4/13/2010)Edition - Standard Edition
Standard Edition is expected to support Import/Export - I would open a ticket with Microsoft.
_____________________________________
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 13, 2010 at 10:27 am
gady.male (4/13/2010)...I just gave the book scenario as an example in order to make my question a bit clearer
it didn't work as expected, huh? 😀
Answering your question it all depends...
_____________________________________
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 13, 2010 at 10:16 am
I do not see any need for table partitioning... a 500 pages book with 25 sentences per page will be stored in 12,500 rows - ten thousand books will be...
_____________________________________
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 13, 2010 at 9:52 am
One datamart per FACTual table, no FACTual table duplicates.
_____________________________________
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 13, 2010 at 9:01 am
bryan van ritter (4/13/2010)
Not by clicking here and there, but with a function probably?
Sure!
Look at the link I posted, customize the code so to write your own function and you...
_____________________________________
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 13, 2010 at 8:44 am
bryan van ritter (4/13/2010)
Isn't there a way to do this directly in the database?
Do you mean... by clicking here and there? don't think so.
You can always convert data already...
_____________________________________
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 13, 2010 at 8:20 am
Mostly everything is possible, check this http://www.codeguru.com/columns/dotnettips/article.php/c7529/ 😉
_____________________________________
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 13, 2010 at 7:30 am
Mushana (4/12/2010)
How do i access this site, it has some solutions i wantReplication - PBworks: PBworks Online Collaboration
Just bing "Replication - PBworks: PBworks Online Collaboration" ... first return on 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 13, 2010 at 7:26 am
You can start with BOL - comes with SQL Server for free.
On the other hand, if you do not have database background may be a good idea to read some...
_____________________________________
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 5:58 pm
ask your DBA to run query as either "sa" or "dbo" on target database.
_____________________________________
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:52 pm
vidya_pande (4/10/2010)
for example -employee and skill many to many relation-
employee
empId [pk]
empName
Skills
skillId [Pk]
SkillName
EmployeeSkills
EmpId[Pk]
SkillId[Pk]
Exactly!
_____________________________________
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:23 pm
Viewing 15 posts - 2,071 through 2,085 (of 3,060 total)