Today I need to set up a new database for a new web site I'm working on.  Last week, I saw Rick's post about the ''mousercise'' that defines the typical table set up in SQL Server 2000 and 2005's table designer.  I have to admit that I completely relate to his feelings, and what made his post better still was that in addition to raising ...

I have a very large table in a SQL database that I need to clean up some old data on.  I've already copied all of the data to another table in another database with a different schema.  I have a legacy application that still uses the old data, but the data goes back for years, and now that it's in the new system, I'm willing to remove at ...