Viewing 15 posts - 2,671 through 2,685 (of 3,738 total)
shanghaigirl-1125377 (7/16/2011)
yes, I have checked the execution plan, statistics and fragmentation, but haven't recreated indexes yet. we have a weekly job taking care of indexes on weekends.
You may want...
July 16, 2011 at 7:30 pm
Have you examined the execution plan?
Have you tried considered updating the statistics, checking the fragmentation, recreating the indexes etc?
July 16, 2011 at 3:43 pm
The following link suggest using Red Gate's Backup Utility:
You might want to download the trial version and give it a shot.
Do you have open transactions? Is CDC enabled?
I hope...
July 16, 2011 at 10:28 am
Steve Fouracre (7/16/2011)
July 16, 2011 at 9:05 am
laddu4700 (7/16/2011)
here is sample data in ready to use in format- attached
Why do you insist on providing the data as an attachment?
July 16, 2011 at 8:56 am
LutzM (7/16/2011)
Another option would be to analyze the transaction log file. AFAIK there are tools available to do that but I've never tried one...
I used Lumigent Log Explorer briefly but...
July 16, 2011 at 8:52 am
opc.three (7/15/2011)
Welsh Corgi (7/15/2011)
You have to replace the NULL with a Zero...
July 15, 2011 at 4:34 pm
Correct me if I'm mistaken but if the subquery does not return a result the you code bombs out?
I hate to mention it but I took a hit on an...
July 15, 2011 at 2:52 pm
sqlfriends (7/15/2011)
What I mean, whenever I refresh a database from an older or newer version of it, I need to do a full backup right...
July 15, 2011 at 2:41 pm
How about using the DISTINCT Operator?
July 15, 2011 at 2:28 pm
sagar dhanawade (7/15/2011)
July 15, 2011 at 2:19 pm
opc.three (7/15/2011)
Welsh Corgi (7/15/2011)
...My experience in going from SQL Server to Oracle....Now why would anyone ever do that? :hehe:
Ya, I hear ya. 🙂
July 15, 2011 at 2:07 pm
adams.squared (7/15/2011)
But I would still like know if there is a way to see any major changes, other than what I did.
What about Change Data Capture?
July 15, 2011 at 1:27 pm
C.K.Shaiju (7/15/2011)
Yes, There should be some easier way. I am searching for something like below.
SELECT
SERVERPROPERTY('MachineName') as Host,
...
July 15, 2011 at 1:05 pm
venus.pvr (7/14/2011)
We have both Oracle32 and Oracle 64 bit clients(version 11.2.0) intsalled on the server. I tested the connection and previewd data sucessfully.
You need to have the correct version...
July 15, 2011 at 7:24 am
Viewing 15 posts - 2,671 through 2,685 (of 3,738 total)