First that the login you're using has access to the C drive on the testserver. I'd then also check that xp_cmdshell was enabled.

dan-572483 (8/1/2012)

---

I've been reading about denying users direct access to data and using techniques such as views or procs with EXECUTE AS instead.

I'm not sure through why...

I'm suprised there aren't a lot of marketing positions that would let you leverage you knowledge of excel and databases. A marketing specialist with knowledge of how to get...

Have you run the queries on SQL Plus on the slow machine?

There is a large variety of ways to do this, but I imagine there are some constraints in your environment.

george sibbald (7/31/2012)

---

ALL transactions are logged, there is no way to prevent that. You will either have to size your transaction log so it can cope with the update or...

Are you using the native index maintenance task, or something custom?

You can use something like ola.hallengren for your index maintenence, or build your own custom job after identifying which of...

Best depends on your environment and requirements.

Log shipping does stay locked in read only, which has some pretty big dissadvantages among them is often getting good query execution plans....

Have you looked into the various types of replication? I don't know the structure of your database, but if possible I'd probably look to transactional replication first.

http://msdn.microsoft.com/en-us/library/ms152531.aspx

Yup, I think eventually most DBA's come to the same conclusion about needing one on their own. Though I imagine the structure and purpose varies wildly between implementation, ever...

Brian Brown-204626 (7/30/2012)

---

PREEMPTIVE: Simply put, this wait means non-cooperative. While SQL Server is executing a task, the Operating...

Same number of files, are they on their own spindles, same type of raid able to handle the same iops. Is you disk alignment the same on all drives...

What kind of wait types are you getting on both servers while the query is running?

Are all sql server, server wide settings and database settings the same?

Are both vm's on...

You should be able to pass a filename variable to a stored procedure that uses xp_cmdshell and a set of dos commands or powershell similar to this.

http://cmille19.wordpress.com/2009/04/05/executing-powershell-in-sql-server/

Are there any hardware or operating system differrences? Are both servers using the same driver to connect to Oracle? Are you using the same protocol? Are the...