Have you checked to see if the VIEW ANY DATABASE permision has been denied or if any other permissions you may take for granted have been denied to the particular...

Enterprise Edition SQL Server is not supported on non-server class O/S. You should be able to install the Developer Edition however, but I mention this only for a test...

I am leaning towards the fact that you simply do not need more memory to complete the workload. However to determine this you need to look at your perfmon...

Did you configure your memory in the server properties for SQL to use the full amount of RAM? You mentioned this is clustered? How many nodes and how...

A couple things to ask yourself and to check:

If you're on the 64-bit OS platform why did you not install SQL as 64-bit?

Did you grant the service account for SQL...

By simply altering the files in tempdb, the changes will not take effect until the services are restarted. Therefore if you deleted the invalid file via the SSMS GUI...

Believe it or not, it's actually needs to be parsed out. For example a value of 1442 translates to MM:SS.

The core table for this is msdb.dbo.sysjobhistory. You can add a great deal of information by joining to other metadata tables in msdb, but this will get you started:

SELECT...

We have never experienced issues in backing up over the network. If you have a reliable infrastructure the issues and risk is minimal. If risks are minimal it...

I suggest backing up directly to the location you plan on copying the files to. Is that not an option? You should be able to backup to a...

Your assumptions appear to be correct. If you're being forced to use that form of naming convention suggest an underscore (_).

--This should do the trick if I understand what you're asking for:

SELECT PRIN.[name]

FROM sys.[server_permissions] PER

INNER JOIN sys.[server_principals] PRIN

ON PER.[grantee_principal_id] = PRIN.[principal_id]

WHERE PER.[permission_name] = 'CONNECT SQL'

AND (PER.[state] = 'G' OR...

Paul, you'll want to increase the frequency of your log backups if you see growth that is abnormally large. Depending upon how many inserts, updates, and deletes you perform...

Is it possible you have a scheduled task on the server at the o/s level that is backing up databases. It would not show as a scheduled SQL Agent...

If you are using the Maintenance Plans in SQL Server I also would recommend scheduling the Integrity Checks to occur before a full database backup. This aids in ensuring...