Viewing 15 posts - 2,566 through 2,580 (of 3,060 total)
First check size and utilization of TempDB, lack of TempDB space or lack of free space on the drive TempDB is seating could cause this issue.
Second, you may have bumped...
_____________________________________
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.May 12, 2009 at 2:38 pm
Database looks fairly small, are you experiencing TempDB bottleneck?
The rule of thumbs for databases experiencing TempDB bottleneck is to allocate one tempdb datafile for each core, each datafile in 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.May 12, 2009 at 2:13 pm
Even if I'm not a big fan of surrogate keys I can understand they come handy from time to time.
_____________________________________
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.May 12, 2009 at 1:50 pm
Hans Lindgren (5/12/2009)Remember that for efficient FK use you must index correctly. You can introduce a big performance hit if you do this wrong. Remember inserting into a table makes...
_____________________________________
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.May 12, 2009 at 1:42 pm
ifila (5/12/2009)I have a situation where i know i am going to have duplicate primary keys ?
I want to allow duplicate records.
Your PK definition is wrong; you either allow...
_____________________________________
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.May 12, 2009 at 12:08 pm
Oracle Migration Workbench, check documentation here http://www.oracle.com/pls/db111/portal.all_books it's free!
By the way, this is the Oracle section of a SQL Server forum; since you are interested in a DB2->Oracle migration 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.May 12, 2009 at 7:33 am
Suresh B. (5/11/2009)
MDF and LDF files are on same physical disk. I think moving them (to different physical disks) may not improve the performance.
Your statement contradicts what Microsoft documentation, common...
_____________________________________
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.May 11, 2009 at 7:50 am
Firstly, your title is Software Engineer so you should be as away as possible from databases and ask a DBA for help when needed.
Secondly, if you are training yourself to...
_____________________________________
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.May 11, 2009 at 7:44 am
Please do not restore SS2K database on SS2K5 server; you have to upgrade it.
Also remember Logins, Jobs, etc. are not part of your "database" so you have to script them...
_____________________________________
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.May 11, 2009 at 7:31 am
Did you drop and re-create the offending stored procedure?
_____________________________________
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.May 10, 2009 at 5:01 pm
mmhhh... do you mean deferrable integrity constraints?
Yes, you can do that but a deferrable integrity constraint is nothing but a normal integrity constraint that will wait until you commit 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.May 10, 2009 at 4:54 pm
Barkingdog (5/9/2009)Found statement causing the issue.
Please consider asking the questions below to yourself:
1- Is this something that was working before and out of the blue started behaving this way?
2- Did...
_____________________________________
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.May 9, 2009 at 7:42 pm
mithun.gite (3/30/2009)Few of our clients have 4-5 years Data gethered on their dastabse.... Now the database has become very large so it is responding slow for any damn reports execution...
Let...
_____________________________________
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.May 9, 2009 at 4:24 pm
Let me start by saying that I personally love FKs.
Having said that FKs certainly add overhead to the database engine, that's a fact.
Looking at your comment below...
Sanjay (5/8/2009)...large database (maybe...
_____________________________________
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.May 8, 2009 at 1:04 pm
ifila (5/8/2009)Since space is cheap is it better to use nvarchar and forget about it
... depending of the scale that statement might not hold true; imagine you have a 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.May 8, 2009 at 8:14 am
Viewing 15 posts - 2,566 through 2,580 (of 3,060 total)