Dear Gail Shaw Madam,

Thanks for your inputs.

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

Jayanth sir,

Thanks. Can you please suggest me a good book where i can gain knowledge of dba internals(mirroring internals,log shipping internals)

Dear Gail Shaw Sir,

As i am a junior dba, i want to learn advanced dba internals and would like to become expert. Could you please suggest a good book/material

Gail sir,

How to calculate value that cost threshold for parallelism needs to be set to?

Dear Gail Shaw Sir,

Thanks for the inputs. Can you please suggest an excellent comprehensive book/material that covers beginning to expert dba internals and concepts

Yes sir, i am the junior dba

Sir, dev team is saying that dba should be doing it.

I am not developer sir. There is Dev team and those developers/programmers have written the code. Please help sir

Chris Sir,thanks a lot. I have pasted a latest post. Could you please see that screenshot and advise.

The SPIDs are changing frequently and they are multi-threaded. Wait type is...

Gail Shaw Sir,

I have attached screenshot. The process ID are frequently changing and its LATCH_EX and ACCESS_METHODS_SCAN_GENERATOR. In this case, please advice on what to do to fix and prevent

Dear Gail Shaw,

Thanks a lot for sharing sir

You are right sir. However here in India, due to high number of job seekers, interviewers are asking such kind of questions. I was not selected for not being able...

Lowell Sir,

If these info are not found any books, how does the person who answers the question gets to know such things? Just curious to know. Please share the links,...

Dear Jacob Sir,

DO we need change back the isolation level to READ COMMITTED after running the query.Because, in our current production environment, its set to READ COMMITTED