Viewing 15 posts - 421 through 435 (of 3,060 total)
Glad to help.
It can be done, full process is described here http://www.sandhill.co.uk/erwin/ERwinIndexNameRule.asp?dm_i=6J9,CSSW,RPMQO,10I86,1
_____________________________________
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 23, 2012 at 8:10 am
gyoung 93471 (3/21/2012)
Therefore, two tables work nicely and cleanly.
1) create a table for rooms (room_id,...
_____________________________________
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 23, 2012 at 7:11 am
Welsh Corgi (3/20/2012)
can't you set up a rule to name the Primary Key?
Yes you can... check here http://erwin.com/uploads/tips_techniques/Using_Naming_Standards.pdf
_____________________________________
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 23, 2012 at 7:05 am
winston Smith (3/21/2012)
And although you will have a very well normalized...
_____________________________________
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 23, 2012 at 6:58 am
Two questions:
1- How big is your SQL Server database?
2- Do you need near-real-time extracts to DB2 or a daily snapshot would suffice?
Depending on answers I would consider either restoring 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.March 23, 2012 at 6:52 am
shanish (3/19/2012)
thanks Pablo (Paul) Berzukov, for ur responseof course am doing, I need some idea, how to do that,thats wat askin here
Okay... for starters, please show us how 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.March 19, 2012 at 5:41 am
shanish (3/19/2012)
I have a table contains the columns StudentId,SubjectId,ComponentId,Marks,PartNo
I have a record for a student,
1,1,1,40,1 // here he scored 40 in part...
_____________________________________
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 19, 2012 at 5:26 am
weston_086 (3/17/2012)
_____________________________________
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 17, 2012 at 4:14 pm
Anamika (3/15/2012)
i expect this to be done using for each loop and inside 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 16, 2012 at 6:09 am
dgossdba (3/15/2012)
_____________________________________
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, 2012 at 7:56 am
One solution would be to load: Database_name, Table_name and Column_name into a cursor then loop the cursor and process each table as needed.
_____________________________________
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, 2012 at 7:00 am
If SAP is running on SS2K8 then you may be able to rely on the SS2K8 native CDC feature.
_____________________________________
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, 2012 at 6:55 am
dgossdba (3/14/2012)
We can see what query is passed to the server when looking at the session that is created by MSSQL. If we run the query with the 4...
_____________________________________
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, 2012 at 6:42 am
Koen Verbeeck (3/15/2012)
It seems there are 2 correct answers :w00t:
Finally! I knew quantum mechanics would sooner or later apply to our trade 😀
_____________________________________
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, 2012 at 6:35 am
Jayanth_Kurup (3/12/2012)
...the current setup leads to too many joins can cause issues if th data in these table are highly transactional
Not necessarily. It all depends on having a proper indexing...
_____________________________________
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 13, 2012 at 5:52 am
Viewing 15 posts - 421 through 435 (of 3,060 total)