Viewing 15 posts - 16 through 30 (of 65 total)
How critical your setup is? What application are you using?
AFAIK logshipping is not a good solution here. Go for mirroring where application would connect to the new principal server if...
July 9, 2009 at 2:04 am
So the status is sleeping when the process is waiting for resources for long... Is there any time period which switch this from running to sleeping status, David.
July 8, 2009 at 10:37 am
Many thanks to Phil Melling and David. Great learning for me...
Ciao
July 8, 2009 at 10:33 am
True SA. My straight question to everyone here. Does defrag also affect index defrag. This is not an an easy question and this depends on how defrag affects data pages....
July 8, 2009 at 9:26 am
Do we really require rebuilding of indexes after defrag. Yes we should shut the m\c down if possible.
July 8, 2009 at 8:52 am
Oh Abhijit.
I am sure that you would be using sp_creatediagram sp in your application. can you revoke execute permission on this from those users? This would help.
REVOKE EXECUTE ON OBJECT::DatabaseName.SPName
FROM...
July 8, 2009 at 8:46 am
One great confusion guys. Take a scenario where we have 8 GB memory. My OS is 32 bit and sql server application is also 32 bit.
Sql server application will...
July 8, 2009 at 5:51 am
Good. Read my post again pls. 32 bit => 4 GB. This can't address more than 4 GB.
Yes 64 GB can address 4 GB. Did you get my point. This...
July 7, 2009 at 8:45 am
David,
The catch is that 32 bit sql server would be able to address 4 GB at the max irrespective of whatever 13 or 14 GB we allot to this. Then...
July 7, 2009 at 8:24 am
David,
The catch is that 32 bit sql server would be able to address 4 GB at the max irrespective of whatever 13 or 14 GB we allot to this. Then...
July 7, 2009 at 8:21 am
SA is correct. Backups should be maintained at some disaster recovery site.
Anyway you can click on add then on radio tab click on file name and then browse to...
July 7, 2009 at 8:15 am
Hello David,
Is my understanding correct for the first para?
July 7, 2009 at 7:50 am
David,
Do you mean irrespective of how much RAM we have available, if we turn /3GB on then only 1 GB would be available for OS?
I have two questions in my...
July 7, 2009 at 7:29 am
Viewing 15 posts - 16 through 30 (of 65 total)