Viewing 15 posts - 2,566 through 2,580 (of 3,061 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...
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...
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.
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...
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...
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...
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...
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...
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...
May 11, 2009 at 7:31 am
Did you drop and re-create the offending stored procedure?
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...
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...
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...
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...
May 8, 2009 at 1:04 pm
Viewing 15 posts - 2,566 through 2,580 (of 3,061 total)