You should not need to disable AV software during installation of SQL Server.

Once installed however, for performance reasons you will want to ensure that your AV software does not scan...

Hi,

The reason you are unable to determine the root cause of your error is because an incomplete error message is being returned from the job history i.e. it is truncated.

In...

I have found that for platforms that support global customers, just before Europe comes online seems to be the most suitable time as this is when the lowest volume of...

What is your SSIS package doing?

Perhaps ther is scope for improvement here?

OK, great.

What version of Windows are you using?

What Edition of SQL Server are you using?

Can you also review the Windows Performance Monitor Counters for SQL...

Hi,

What is your SQL Server Max Memory setting?

Regards,

Hi,

Have you reviewed the Windows Event Logs?

For example, do you have automatic Windows updates enabled and if so perhaps this caused a server reboot.

Reviewing your Windows Event Logs may provide...

Hi,

As previous posters have mentioned, this is a warning about the performance of your Disk I/O subsystem and REBUILDING indexes is a very expensive operation.

Can you:

1. Tell us more...

Hi Sharul,

SQL Server does not offer a complete load balancing solution out of the the box per say.

A common implementation is to use SQL Server Replication technology in order to...

I would suggest that you strongly consider using Log Shipping as a possible solution for your business case.

It will adhere nicely to the requirements you have listed and will be...

Thanks!

You can find Part 2 here:

http://www.sqlservercentral.com/articles/SQL+Server+Administration/67902/[/url]

Can you provide a little more detail about your CPU please?

What is the CPU model that you intend to use?

Are you referring to a single "Physical" CPU or a core?...

Festeron (9/21/2009)

---

I cannot agree with...

bas de zwart (9/23/2009)

---

I almost can't believe that *any* recovery model is presented like this as a 'best practice'; and certainly not as WHY you SHOULD be using this or...

Nicole Garris (9/21/2009)

---

I agree that the default recovery model should be Full. However there are cases where the simple model is more appropriate. For example, if its mostly large "batch"...