Have you run consistency checks on the databases? I'd be quite concerned about that. Also, you could try DBCC UPDATEUSAGE. I don't think it'll help, but it's the first thing...

On a side note, foreign keys are for data integrity. They have little effect on performance. It's indexes that you need to look at to really alter performance.

I can't tell you specifically why truncate is allowed and not delete when you give the alter permission, but you're wrong about rollbacks. Truncate can be rolled back.

Applying hints is absolutely the last step in any tuning process. All you're doing is forcing the processor to only use that index for access, but because of the rest...

The buffer pool is basically all remaining memory. You can't really manage it at all beyond setting the min & max values. Other than that, you manage how data is...

I don't entirely understand the issue. Are you saying that you're running perfmon across the network to collect data? Generally, this is not an approach I use. Instead, I'll run...

Yes, but...

NOLOCK hints can cause you to get erroneous data. Not only will you see columns that have been changed but not yet committed within a transaction, but you can...

People here may not have, or may not want, StackOverflow logins to answer your question. If you want an answer here, ask the question here. Otherwise, wait patiently over there.

Is this a new server install?

This error is generic. It means a service failed to start, but it doesn't specify anything. You need to check the logs for the specific...

Cross posting just confuses things. Please reply here: http://www.sqlservercentral.com/Forums/Topic911607-145-1.aspx

You asked this same question over at ask.sqlservercentral.com.

Over there several people asked you to specify some details. The same questions still apply:

You'll need to provide more information to get a...

Please don't cross-post. It just diffuses the conversation and duplicates efforts.

Reply to this question here: http://www.sqlservercentral.com/Forums/Topic911607-145-1.aspx

ALTER USER UserName

WITH DEFAULT_SCHEMA = 'dbo'

I think that ought to do it.

What's the error on the SQL Server side? Is there one?

As long as the backup was taken after the index reorg was completed, yes, everything is there. A backup is a complete copy of the database, as it currently exists,...