Viewing 15 posts - 226 through 240 (of 274 total)
Gail Madam,
It is production. Is it ok to drop the fill factor? Also, i should be doing it during non-business hours, correct?
August 18, 2015 at 1:23 am
Good morning Gail Madam,
I Rebuild the index again last night. percentage of fragmentation increased for the below index after 6-8 hours.
Here is the definition of the index:
CREATE NONCLUSTERED INDEX...
August 17, 2015 at 11:43 pm
Dear Gail Madam,
I really salute for your will to help newbies/juniors like me.
August 14, 2015 at 6:01 am
Gail Shaw Madam,
Thanks for your reply. No shrink operation was performed. Regarding inserts, how to know if any data load or insert operation happened?
August 14, 2015 at 4:53 am
Gail Madam,
I have attached screenshot of what i see in the activity monitor. . Is this some issue? What do i need to do? Please help
August 13, 2015 at 1:28 am
Alex,
What i meant was our environment is small and there is no pressure on me to fix the issue immediately. They have told me to take my time to look...
August 13, 2015 at 1:21 am
Dear Gail ShawMadam,
I am junior dba. I was told that this forum have great,SQL experts,kind hearted wonderful people with good virtues like all of you here and willing to...
August 12, 2015 at 11:27 pm
Madam, i am junior dba. I was told that this forum have great,SQL experts,kind hearted people with good virtues like all of you here and willing to help. Our environment...
August 11, 2015 at 11:46 am
Madam,
So,take a full/diff backup after the log chain got broken and ten restore it with norecovery on secondary? Do we need to re-configure log shipping again?
August 8, 2015 at 12:50 pm
Jason Sir,
So, in log shipping, suppose the .trn file got corrupted today at 7 AM, do i need to take full backup immediately and restore it on secondary with norecovery?...
August 8, 2015 at 10:48 am
Wayne Sir,
Thanks lot for reply.Actually,I did not understand. As i am junior level dba, could you please explain in simpler way.
August 8, 2015 at 3:30 am
I am a dba actually and hence my seniors told me to get knowledge on internals.
August 6, 2015 at 11:37 am
Dear Gail Shaw Madam,
Thanks for your inputs.
August 5, 2015 at 1:15 pm
Sir,
I am entry level.First, I want to gain knowledge on internals of log shipping and internals of mirroring. So,Please suggest good books to start with
August 5, 2015 at 12:38 pm
Jayanth sir,
Thanks. Can you please suggest me a good book where i can gain knowledge of dba internals(mirroring internals,log shipping internals)
August 5, 2015 at 9:46 am
Viewing 15 posts - 226 through 240 (of 274 total)