If you just want to ignore the duplicates and don't need them copied to an exception file, you can also use "CREATE UNIQUE INDEX ... ON ... (..) WITH IGNORE_DUP_KEY"...

When you say you want to "check the box" I think you have to look beyond index tuning.  There are some free utilities that can analyze server and database settings,...

There are 2 bytes of overhead for recording the varchar length, not 1, but otherwise you are correct.  If you copied a table with varchar(20) fields to a table where...

One minor quibble is that tinyints are unsigned and have a max value of 255, not 127.  Also, IDENTITY fields may be decimal.  You could start with this:

SELECT

Multiple files and filegroups are primarily the DBA's concern, they should be transparent to the user.  Filegroups only appear in DDL statements (CREATE TABLE, CREATE INDEX), and BACKUP/RESTORE statements.  There is...

When you say you need to shrink the database before you can create filegroups, you imply that you don't have enough disk space and adding disk space is out of...

The SSIS flat file destination should allow you to ignore errors on specific columns so the package doesn't abort.  Go through the property pages of your data flow components and...

Look up DTEXEC and DTEXECUI utilities in BOL to find out how users can run SSIS packages.  Packages won't run anywhere, users must have .NET framework and several other components...

Why are you updating COL1?  Since it is your join condition, it is the same in both tables.

Is COL1 a unique value, at least in TBL2?  If COL1 is not...

I have never had an issue with VSS, but I've always used it with relatively small single-location programming teams.  When you say you want "enterprise" source control, you may have...

Dynamic SQL requires compiling the command, as though you had typed it in QA.  So it will only do things the user has the right to do.

If a user has...

Do you know the files were created by FoxPro, or are you just assuming?  DBF files could also be dBASE format files created by some other application.

You don't say what...

My answer was meant to be a jest, maybe I didn't use enough smileys.  Yes, you need to enable AWE in any 32-bit edition of SQL Server to use memory...

No, you need to install 64-bit SQL Server

If you are running 32-bit SQL Server with a 32-bit Windows operating system, the 64-bit capability of the hardware isn't doing you any good and you need to enable AWE...