As a...

Generally you'd use a composite key if there is no single column that uniquely identifies the row.

Depends. What does the proc do?

Could be a parameter sniffing issue, could be a few other things. Best thing to do here is run...

Restore the database from a backup taken before you deleted from the system tables. There's no other way to put the row back.

By modifying the system tables you have severely...

sp_helpindex for indexes on a table, or use sys.indexes and sys.index_columns to get all of the indexes in the DB

One thng to bear in mind. In SQL Server triggers are not fired for each row that's inserted/updated. They fire once for an insert/update/delete operation and the inserted and/or deleted...

Wouldn't know. As I said, you'll have to ask someone who knows sharepoint well, and that someone is not me.

No need to disable any distribution agents.

SQL with or without replication can handle expected or unexpected shutdowns without data loss.

With replication, the data to be replicated is copied from...

Depends on where I am and what I'm doing. If I'm away on business and working with a client, I can often do 9 or more hours of work a...

It could be that for some reason SQL couldn't identify the locked resource. I have seen that from time to time. If you get an answer, please let us know.

GermanDBA (11/14/2008)

I'm not sure If I read the details incorrectly, but the new policy manager for SQL 2008 should supply just this. You setup the policies it should check...

Please post the full output of the checkDB command that I gave above

I...

Depends how fast the indexes fragment. If you have an index where the fragmentation increases about 2% a month, then reindexing weekly is too often. If you have an index...

Not offhand.

Do you need to see it? I know it's interesting from an academic point, but from what I can see of this one and the previous graph, there's more...