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...

I'm not sure what you mean. Objects are owned by a user, so in that sense they are dependent.

In 2005 you have Execute As, which I think introduces a dependency.

Andre,

No worries about the English. I pointed that out only as it seemed to be causing confusion. I couldn't even order food in German (I tried in Austria), so you're...

They've stopped the practice, and no one's sued them (yet), but it is amazing sometimes how people view the world. I still stunned that anyone thinks this was ever OK.

Nice, Paul.

First, you'll have to hold off on this for a day or so. We've disabled a few things because of server issues.

The points update pretty often, but there is some...