Viewing 15 posts - 2,761 through 2,775 (of 3,061 total)
I would rely in distributed transactions, here is how.
On the SQL Server side initiate a distributed transaction by issuing BEGIN DISTRIBUTED TRAN
Do something commitable to a SQL Server table -even...
January 29, 2009 at 11:13 am
Vijaya Kadiyala (1/8/2009)
There are no big difference between 9.2 and 9i.
Well... there is a reason for it, Oracle 9.2.* is nothing but Oracle 9i ... so you may expect them...
January 25, 2009 at 12:52 pm
First thing for you to do is to understand what is management asking you to do.
My wild guess is that you have several SQL Server boxes in your shop and...
January 25, 2009 at 12:43 pm
Some people has fixed the issue by unchecking the "Allow inprocess" option
On SQL Server Management Studio
Server Objects --> Linked Servers --> Providers --> MSDAORA, right click select properties
It wouldn't...
January 17, 2009 at 7:42 am
You are more than welcome David.
I would suggest to go back to management with a report showing a honest estimate of effort and even proposing to do a pilot by...
January 17, 2009 at 7:33 am
Your two primary sources of info for SQL Server are: 1) Books Online -which comes on sQL Server media and, 2) Microsoft Knowledge base -which is free at http://support.microsoft.com/ph/2855
Your post...
January 16, 2009 at 11:41 am
thinknight (1/5/2009)I try to shrink log file to 10 GB
How big was your Log at creation time?
January 5, 2009 at 5:41 am
You have to ensure your databases are available, reliable, and recoverable and their performance meets SLA.
Always remember this: DBA owns the structure but never ever the data.
January 5, 2009 at 5:38 am
Paresh Prajapati (1/5/2009)select t1.A,t1.B,t1.C,t2.D
from table1 t1 inner join table2 t2 on (t1.A=t2.A)
You may want to test your code, unfortunatelly it doesn't work.
I think it will be better to wait...
January 5, 2009 at 3:40 am
iqtedar (1/4/2009)
ok ..i will ask him to do...so then what would be the default size of the log file...thanks..
:w00t: It looks to me that you are planning to fix the...
January 5, 2009 at 12:26 am
DBADave (1/4/2009)What else can be done to spped things up?
I would work in fine tunning the application focusing on the most used queries.
January 4, 2009 at 8:52 am
iqtedar (1/3/2009)...one of the developers told me that he created a db with 270Gb assisgned to log file.
Firstly, the root cause of the issue is having allowed a developer to...
January 4, 2009 at 8:48 am
Paresh Prajapati (1/1/2009)5. Monitor TempDB size. If it growth more , then move tempdb to individual disk.
Could you please elaborate on the rationale of the above recommendation?
January 4, 2009 at 1:40 am
What's the Fill Factor for these offending indexes?
Either way, you may want to check the next note about how to defrag SharePoint indexes, here http://support.microsoft.com/kb/943345
January 3, 2009 at 12:09 pm
Viewing 15 posts - 2,761 through 2,775 (of 3,061 total)