Viewing 15 posts - 796 through 810 (of 1,315 total)
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"...
July 14, 2006 at 7:31 am
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,...
July 7, 2006 at 8:55 am
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...
July 7, 2006 at 7:55 am
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
July 5, 2006 at 1:17 pm
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...
July 5, 2006 at 10:08 am
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...
July 3, 2006 at 10:27 am
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...
July 3, 2006 at 9:45 am
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...
July 3, 2006 at 8:58 am
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...
June 29, 2006 at 8:59 am
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...
June 15, 2006 at 5:10 pm
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...
June 14, 2006 at 8:55 am
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...
June 13, 2006 at 6:52 am
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...
June 8, 2006 at 7:50 pm
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...
June 7, 2006 at 6:56 am
Viewing 15 posts - 796 through 810 (of 1,315 total)