It might be just the expected load on that hardware with that number of users. Or it could be something you can reduce.

60-80% is less than 100%, which is where...

Besides the missing WHERE clause? On both updates and deletes?

Of course, I'm a production DBA. And I've had some good ones, fortunately with small databases.

- Restore QA over production by...

Everytime you execute an insert, update, or delete, MORE infromation is written to the log. That's what it is, a log of activity. When you take a log backup, these...

Login failed is a different message than the name resolution. It means the context of the package execution is running under a local or non-network account.

I suspect that you resetting...

If it thinks it more efficient, and perhaps 10 is the threshold, locks will be escalated.

I'd be interested in why you cannot manage the updates in one statement. Perhaps stating...

Neither identity or max(n)+1 will prevent gaps. They both assume the highest value in the table is also the number of values in the table.

Instead if you want to "issue"...

There's also a NO_LOG option. Look them up in BOL to see which might be more appropriate.

1. A reinstall wasn't necessary. You missed something.

2. Yes, use the server network utility. Set it to another port. If you have a good firewall router, you may be able...

Pedro, you need to learn the restore db syntax. Enterprise Manager requires more than one connection to run, so as soon as you start it, you can't restore master.

You need...

Be sure tempdb is not growing under the load. While it grows, writes and work stop in that db, which can lead to non-response on the other dbs that use...

How are you addressing the server? If the server is ServerA at IP 10.10.10.10, do you specify IP, ServerA, or ServerA.MyCompany.Com at the client?

Can you connect by IP as specified...

Alexander, you bring up some good points, but that's a rather naive view of the world.

Let's say you are Oracle selling your ERP system, or attempting to sell it, to...

I think you'r need to set this as a job and start the job.

There are a couple articles on the site dealing with this subject

http://www.databasejournal.com/features/mssql/article.php/3521101

http://sqljunkies.com/HowTo/705F07C3-69FE-4CAF-8CF8-CADBF145F372.scuk

http://sqljunkies.com/HowTo/705F07C3-69FE-4CAF-8CF8-CADBF145F372.scuk

There might be orphaned users with the restore. sp_change_users_login will fix that.

Check and see if any of your users in the db are not mapped to logins and then use...