As long as you have control of the members of your sysadmin server role there is no security concern because the procedure sp_procoption which is used to set a stored...

I am curious as to why you would like a standby version of a databases on the same server?

Assuming you are filtering on the column that you are partitioning against, partition elimination will ignore any partitions that do not contain the value that you are looking for. So...

Log shipping is the real thing here that is killing your idea as others have mentioned you will not be able to report against the databases while the transactions logs...

How many sql jobs/schedules on your instance? If not many, check the start dates on the schedules for all of them.

Actually, setting the max degree of parallelism to 1 is the optimal setting in some cases. You need to determine the best setting for your sql workload. Ideally you have...

This does sound like a combination of clearing the procedure cache with the restart and also poorly optimized sql for the actual process itself. You said that you have 128...

This is normally just a connection issue. When I have seen this in the past it was because I was connected to the instance in SSMS and that instance was...

What version and so of SQL Server are you running. I have seen this error happen on sql 2000 and 2005 and it was related to the start date that...