Hi Dana,

Configure all those at once once and reboot the server. No multiple reboots required.

...

Hi Sudhakara,

Each application (i.e SQL Server ) as a...

Hi Pam,

Set Min Memory = Max Memory = 3 GB.

...

Hi Sudhakara,

From what I remember ..

...

Hi Sudhakara,

32-Bit windows can access only upto 4 GB of memory. If you need to make...

Hi Shanila,

AWE is not required on 64 bit systems.

...

Hi Phil,

Welcome to the world of SQL Server.

...

They will run fine.

Best Regards,

SQLBuddy

Hi Terry,

You can configure an email notification within the Maintenance Plan(MP) itself.

...

Hi Tara

SQL Server does a good job managing the Max Degree of Parallelism (MDOP=0). MDOP is not a good option to enable in OLTP systems....

Check whether the SQL Server account has access to C:\teste1.txt.

...

Check this from the below MS link

http://technet.microsoft.com/en-us/library/ms189493.aspx

Emptying a file

The following example demonstrates the procedure for emptying a file so that it can be removed from the database. For the purposes...

Also……If the application uses hardcoded IPAddress to connect to the server then you have no other option than choosing 3.

...

1 is the best method. If 1 is not possible go for 2. Don't use 3.

Best Regards,

SQL Buddy

Hi

When you running the job, with what account are you logged on? What are your privileges?

Does the job runs fine if it left to run as per the schedule?

...