Here, I'll give you a head start: http://technet.microsoft.com/en-us/library/bb522534.aspx

I don't want high performance children. Heck, I need something to hold over them! They can be high performing adults, when I will need them to take care of me...

In terms of cost, you would have to research your situation. 2008 was the same cost as 2005, but 2008 R2 has a price increase.

Why do you want to upgrade?...

If the issue is finding space, then separate filegroups will definitely help. Just didn't want you to think that you could easily piecemeal restore. You can do some filegroup restores,...

It mentions permissions. Your linked server is working, but perhaps that package/module is not one you have rights to call.

I believe that autogrow does require a lock on the files, but it should be part of SQL Server. I'm not sure what you mean by file in use here...

Lowell is correct. You are converting this to a number in this table, and by convention, numbers do not include leading, or trailing zeros after the decimal.

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

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

You can partition out tables to gain some performance, but if this is just a management issue, I would say that you might want to move some tables (moving their...

Please do not post homework/exam/interview questions with the expectation that someone will do them for you. You are responsible for doing your own work. Or your friend is.

We are happy...

I'll add another note to say if you aren't using the BI features, I'm not sure there's value in upgrading to R2

Good for you, Roy, and glad you had a good time. Good to see you back online.

Sore

Michael,

That's a good idea. I might built such a DDL script that people can use to do their own counts and analysis.

Excellent article, and definitely I learned a few things from this one.