the fact that it is complicated, keeps us working. SQL Server is too simplistic and gui driven already. I see enough of people with next to nothing of experiences, posting...

You have the times in the log, I would check to see what jobs are running at thart time. I would also check to see what else you have running,...

maybe if you can explain what Lakh is, that might help.

Calculating fill factor can depend on many things, it is not just number of rows that you take into account

Something makes me think the last post, is somehow not related to this topic, and possibly not even this forum perhaps 😀

Jobs run based on the server locale, so how long a job takes shouldnt matter.

debahuti_k (11/2/2009)

---

Hi ,

Can anyone guide me on SSRS manual, scenario,unit testing?

How is it done?

what can be the probable questions for SSRS testing interview?

Is there any website where I can...

BOL...

Not sure what you mean, if the update has...

in SSMS, look at server properties then look at permissions, it will be listed there, as you have allocated it at server level. what you have run, allows viewing in...

the other thing is, what is your recovery model set to.

If it is set to simple, after every transaction/batch, the log will truncate/checkpoint and keep the log size down. if...

I have fixed the link that was provided to you.

http://www.rikertothebridge.com/2009/03/deleting-data-in-sql-server-without-exploding-your-transaction-log/

neo_pom (10/29/2009)

---

I'd like to compare between

TABLE A in Testing SERVER

and TABLE A in Production SERVER by each column.

In order to update value of...

ok if you want it to be from branch 1, then change it to say branch_num = 1

Can you give more details?

Can you post what Gail has requested and if you have already tried to recreate the index, was it a non-clustered index.