Viewing 13 posts - 1 through 13 (of 13 total)
I Have the same problem.
I made the following test:
- Created a Log Shipping into a database BILLING
- Inserted 4 rows in a table BILLING_REP
- The Log Shipping worked well
- Deleted...
March 26, 2012 at 1:28 pm
Sean Lange (6/16/2011)
Or you could just add distinct to your select.
select DISTINCT ct.name,cot.id
from tags ct,ct_tags cot,doc_details cds,cont_poperties ccp
where ct.tagid=cot.tag_id and cot.contentid=cds.contentid and cds.contentid=ccp.contentid
Using distinct just in case you are making...
June 16, 2011 at 8:46 am
andymay-496937 (11/24/2010)
June 16, 2011 at 7:39 am
The chances of the problem is the join you're doing is huge (135.32%).
Use the INNER join clause instead of doing everything in WHERE. This helps organize your code. Then, redo...
June 16, 2011 at 6:43 am
What I mean is I have 6 years experience in databases and never see anyone use the bitmap datatype. The performance analysis is sensational, but is only usable if you...
June 15, 2011 at 12:42 pm
You know how to use cursor? If only one run and nothing else, use a cursor. The arguments to be used for the deletion must be the result of a...
June 15, 2011 at 11:20 am
The analysis is interesting, however, can make life difficult for developers that use the database.
June 14, 2011 at 10:08 pm
Many errors of type conversion data can be manipulated using the command:
Set DateFormat DMY - (day, month, year).
But if it was working fine, then just check the user running the...
June 14, 2011 at 9:57 pm
The creation of an index has no problem. What is expected, as said before, is that it can never be used.
The advantage of using a bit instead, for example, char...
June 14, 2011 at 9:36 pm
About the topic title:
Sorry, wish I could fix this, but I have no idea how to edit the topic title.
Moreover, I have no doubt that juniors could help me with...
June 14, 2011 at 9:17 pm
Andy,
Is your problem solved?
September 10, 2010 at 2:14 pm
Did u had your issue solved?? I have the same problem. xD
July 21, 2010 at 7:00 am
Hello!
I have a similar problem and I want to know if u could solve the memory problem.
If u can send me an email to contact you I would be very...
October 29, 2009 at 1:52 pm
Viewing 13 posts - 1 through 13 (of 13 total)