Are you talking about the Master Data Management features of SQL Server 2008 R2?

Do you have an environment complex enough to make use of that (multiple databases with related information,...

Not specific on the AND/OR problem, but why reinvent the wheel?

http://www.codeplex.com/PAL

Yes. Say there's a single drive failure, or database corruption, or someone stops SQL and deletes one of the files belonging to a system DB. Restoring from backup is far...

It's a test.

Telling SQL to wait 20 sec is an easy way for an attacker to tell if the system is vulnerable to SQL injection. If it is, the...

If you use the code but don't get a ticket with your conference badge, speak to the ppl at registration. Stuff does sometimes get forgotten, but they're very good at...

Integrity check? SQL doesn't do an integrity check on startup. The checkDB messages in the log on startup just report the last time checkDB ran successfully.

If you're talking about slow...

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Restore from backup if you can.

A repair might cause problems with sharepoint because of the way it discards data. Not sure here, I have asked an expert on corruption and...

http://en.wikipedia.org/wiki/Argument_from_authority

Regardless of what he is, it's hard to argue with tests that prove what you're...

Write a stored proc that will do the purging, test that it doesn't kill the transaction log in the process, then go to whoever is responsible for scheduled jobs and...

That's not much of a prize.

During the main conference you can't swing a (metaphorical) cat without hitting a couple of...

That's a rather vague question.

Honestly a well-designed and well-tuned database won't slow down as rows are added. Consider partitioning if you can on the large tables, evaluate the partition columns...

The Wall (3/9/2010)

---

This person insists that re-indexing changes the Identity seed value on a row, so please any links to documentation about this subject would be much appreciated. I...

exec sp_spaceused

Called without parameters it gives details for the DB as a whole, when passed a table name gives details for that table.