Arguably not the best question or answer. Hints are an area that I think SQL is a little immature in how to describe/explain them. Please feel free to post suggestions...

Not sure when it was removed, but it's not in 2005 for sure.

I've always had trouble with maintenance plans once I edited them in BIDS. After that point, I've managed them as normal SSIS packages, not plans anymore.

If you do the stats before detaching, you shouldn't have to do it again.

What do you mean stats for the entire db? Where else is there data other than in...

Are we sure it takes longer for new applications? I know we're in a mode of enhancing applications in small ways on a regular basis, but it seems that we...

Your account must not have a login in SQL Server. What does the SSMS registered server settings say?

Good idea on the delay.

Even without it, I've seen better performance and some queries still slipping into the system as each transaction completes, but you're right, it does still slam...

Yikes!

Thanks for the update. My guess is there was some flakiness somewhere or you weren't querying what you thought you were, but glad it's working for you.

When you connect, you'll also need to drop the server and then add it back as the new server name.

And you restarted SQL?

Did you change the name in sysservers?

For a clustered index, the row count should be stored in a system table, so that should be quick.

For the first, if you had an index on the GROUP BY...

And do you just have one instance?

We do not condone or allow dumps for the exams. It is a violation of the NDA.

You must get the requirements from Microsoft and study the material. Asking someone give...

Please, please do not set a blank password. What requirement could you have to ensure that you have a security vulnerability like that?

And please don't use sa for development or...