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

Just as a note. The projected pace for SPs is one a year. There is supposed to be SP1 at 6 months post RTM (slightly late for 2008), but then...

Relations are logical structures based on RI constraints. If you have set those constraints, you can auto-build a diagram. If you haven't set them up, then there's no way for...

SQL Server just takes memory as it's needed for queries, caching, etc. On 64-bit, I would see it trying to cache everything it could, and perhaps running up to 10GB....

I'd agree with Jeff. This information doesn't make sense.

A database is a logical unit of data. While you might need to query across databases, you would never really use the...