I'm not sure that I completely understand you, given what you've written. Did you say that you added a data file to the database on an external drive and then...

You'll need to stop SQL 2000 or you can see some slowdowns. You'll also want to internally defrag the tables once the disk is done as things will have moved...

Quite fitting with today's editorial.

Is this soccer stuff over today?

Human's definitely need training as well, but despite the failings we have at times with them, I still think they they need to be involved in decisions more. Things like...

Do you mean that the virtual drive is fragmented on the physical one or that inside the virtual drive it appears to be fragmented?

We usually don't defragment drives often when...

Check if you are synchronous or asynchronous with mirroring. If the connection is slow, synch mirroring can slow down the primary a little.

The transactions that are sent to your local...

Here's what I'd do. Create a new local account. Then us the Configuration Manager to set this as the account for SQL Agent. You don't want to use Control Panel...

http://msdn.microsoft.com/en-US/library/ms143760%28v=SQL.90%29.aspx

Are you an administrator?

Did you check the Event Logs for Windows, especially the security log?

I'd argue against Craig saying that often the business doesn't know what the best use of this data is. Or how it will be used with an extremely high degree...

Sorry, Gail, looks like SA is not moving on in the World Cup.

🙁

I'm not sure Adam's post was much worse than I've seen for a few others. However I do appreciate a few of you taking over my role and trying to...

Anyone?

http://www.sqlservercentral.com/Forums/Topic940088-61-1.aspx

I posted before, but I'd take a look at this book: Drive

and check out this short video: http://www.youtube.com/watch?v=u6XAPnuFjJc&feature=player_embedded

It has been shown that incentives for creative people, like IT, results in...