Forum Replies Created

Viewing 15 posts - 796 through 810 (of 1,315 total)

  • RE: work around for inserting into table with unique constraint.

    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"...

  • RE: check SQL performance

    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,...

  • RE: Char v''''s Varchar

    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...

  • RE: Find identity columns near the max value

    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

  • RE: Is having multiple data files better?

    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...

  • RE: Managing a Very Large Database!Questions !

    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...

  • RE: Ragged dest file doesn''''t like truncating values

    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...

  • RE: how do I present my DTS package to end user.

    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...

  • RE: update multiple columns using subquery

    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...

  • RE: Visual SourceSafe opinions wanted

    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...

  • RE: Permission on table doesn''''t work

    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...

  • RE: Linked Server to VFoxPro Data Files

    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...

  • RE: AWE on 64-bit machine

    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...

  • RE: AWE on 64-bit machine

    No, you need to install 64-bit SQL Server

  • RE: AWE on 64-bit machine

    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...

Viewing 15 posts - 796 through 810 (of 1,315 total)