First, I'm not sure what your report means. You haven't defined what the various items would be.

Second, this almost sounds like homework. You should attempt to do something, generate some...

Maybe we should get a Zune and test 😉

I'll have someone look into it. The links should go directly to the MP3 files.

Congrats, Gail!

Baseball knowledge probably does help with the levels. I picked these over the summer, so my apologies for outside influences 🙂

As an FYI,

Willy Mays - 660 Home runs

Babe...

If you use Enterprise Manager to assign the account, it will assign the correct local permissions.

The network permissions will be in Active Directory for the old account.

You can read mail (http://msdn2.microsoft.com/en-gb/library/ms179879.aspx), however this can be a security risk and it will be removed in future versions.

Agree with the advice above.

You can search the Microsoft site and you'll see SP2 available. It was released last summer. There were some bugs and I'd apply cumulative update 3 post SP2. Not sure...

I don't think there's a performance impact, it's more a security issue. There is additional checking of rights when you cross databases, but that's minor. Unless this is a very...

detach the databases, copy the mdf/ldf files over, and reattach the database.

Right click in SSMS will give you the detach/attach options.

You should be running regular log backups, this will remove the active portions of the log, and it should alleviate the need to shrink it.

Don't shrink the database unless you...

I'd agree with your actions. You don't want to mess with the hardware that your database depends on and if you're not an expert, get someone who is.

To move the data, move the clustered index to the new filegroup. To move the indexes, rebuild them on the new filegroup.

You can use Gail's suggestion, but building queries like this is inefficient and can cause you performance issues with large data sets.

Please do not post in all caps and please describe your problem in the post.

Send an email to the webmaster with your blog name and ssc registration.