Any logic for leaving 4GB for the OS? Does it need it in 64bit?

Or would you be OK running to 30GB for SQL?

grumble, don't get me started, Jack. I've wanted that (with FB/LI) for some time

I've used full, but that's worked well for me. I typically haven't had bulk loading occurring, so there's no savings.

with mirroring, I'm not sure you save anything. The same data...

http://blogs.conchango.com/jamiethomson/archive/2007/02/09/SQL-Server-2005_3A00_-View-all-permissions.aspx

Well, it's an interesting debate. I can understand why dbforums might think it is worth closing it, but I think it goes against my grain to do so.

My feeling in...

I don't see the administrative value of instances. It might make security separation easier, but anything else gets more complex. I guess you get administrative skills beefed up, but it's...

I don't think location matters. I'm not familiar with anyone wanting to know if you got your certification training from a university v some training center.

The issue will be experience....

The default trace is always on. That's why it's named that.

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

Server side tracing, it's in books online. It's not too hard to set up, but a little tedious. I believe...

I believe that you will need to restart.

If you limit memory, SQL Server will have less to work with. That can affect performance, but there's no way to know how...

They each have an owner. this is separate from the schema.

As far as who owns an object, this doesn't come into play unless you try to delete a user....

Does the data in the two tables change often? If so, I don't think this works.

You've be better off restoring a copy of the database, then truncating those two tables.

I think that if you can execute the query you can view the plan.

You haven't really explained it in detail.

If you have data to export, you can use the BCP command to pull it out into files. However that will be in limited...

It's a balancing act, and this is where it becomes an art. The heads are very good at moving around, but to reduce contention, you have to try and separate...

Very strange. You could look through the default trace for some clues, and then see if you can execute the various items that are captured. If you can narrow things...