Viewing 15 posts - 2,476 through 2,490 (of 3,061 total)
The fine art of troubleshooting deadlocks, huh?
You may want to start here http://www.mssqltips.com/tip.asp?tip=1036
July 10, 2009 at 12:40 pm
:w00t: wow! Thank you for sharing. Very good catch, congrats.
July 10, 2009 at 11:36 am
sqlbuddy123 (7/10/2009)
your detailed reply
And the credit goes to... Oracle's oerr utility 😉
July 10, 2009 at 11:33 am
Yes you can.
All you need is Oracle's Transparent Gateway for Microsoft SQL Server and some time to read and test. 🙂
July 9, 2009 at 3:38 pm
12154, 00000, "TNS:could not resolve the connect identifier specified"
// *Cause: A connection to a database or other service was requested using
// a connect identifier, and the connect identifier specified...
July 9, 2009 at 3:24 pm
May it's better not to use such index
What's the size of the offending table?
What kind of process against the offending table? e.g. scan or lookup?
July 9, 2009 at 10:38 am
mahesh.vsp (7/7/2009)In a similar way what i tried was, created a database "testdb" inserted 100 rows and stop my sql server , deleted the .ldf of "testdb" and restarted my...
July 7, 2009 at 4:31 pm
Michael Meierruth (7/7/2009)
There is also a charge to sign up to MetaLink via an Oracle support identifier. This is starting to get expensive.
:pinch: If you have a licensed Oracle...
July 7, 2009 at 7:30 am
May I ask why are you using surrogate keys instead of natural keys?
Having the opportunity of seeing the original data wouldn't hurt either.
July 6, 2009 at 3:41 pm
molson (7/6/2009)
I'm shocked and appalled some people have a total disregard for Referential Integrity.
Sometimes a DBA's gotta do what a DBA's gotta do...
:blink: do you mean... trash referential integrity? 😀
July 6, 2009 at 1:42 pm
Most of the answer depends of the kind of reporting business is asking for.
A broad answer for the posted -broad - question would be: a table with indexes designed to...
July 6, 2009 at 9:48 am
suresh0123456789 (7/1/2009)Is there any way to delete records without dropping FKs
Yes, doing it the right way -please refer to Gail's post.
I'm shocked and appalled some people have a total disregard...
July 3, 2009 at 6:37 am
s007reddy (7/2/2009)
When you move Dev database to PROD server ....
Lovely 😀
Post pretty much rubber stamps a big approval on this; that's wrong -it might lead inexperienced people to believe this...
July 3, 2009 at 6:28 am
Can you afford a down time?
1- Pre create all databases in new location.
2- Take a final full backup and put it on an external disk drive
3- Ship the external disk...
July 2, 2009 at 1:13 pm
ramyours2003 (7/2/2009)
what precautions to be taken while restoring the database from development to production?
:w00t: A signed job offer letter from other employer would easy the pain. 😀
Is the plan...
July 2, 2009 at 12:17 pm
Viewing 15 posts - 2,476 through 2,490 (of 3,061 total)