Forum Replies Created

Viewing 15 posts - 76 through 90 (of 49,552 total)

  • RE: Table level constraints vs. column level constraints

    You were trying to add a check constraint, therefore I mentioned check constraint in my reply, not because only check constraints are invalid.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 17, 2018 at 2:11 am

    #2009994

  • RE: General audit / monitor question

    And you'd create the AuditImport procedure in the database where you want the data to be imported to, not where the tables being audited are (shouldn't be the same place,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 11:36 am

    #2009927

  • RE: Unable to start the trace

    SELECT * FROM sys.traces (fn_trace_getinfo has been deprecated for years)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 11:31 am

    #2009924

  • RE: Casting one datetime as date converts other datetime fields

    Then consider the possibility that the problem is not in SSIS, but in Toad's display of the data that SSIS has loaded.
    Double-check in SSMS before you go digging...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 10:45 am

    #2009915

  • RE: Casting one datetime as date converts other datetime fields

    If it's happening in SSIS, then that's a problem. I can see a client tool weirdness, but SSIS is another matter.

    Assuming SSIS is inserting into some table with...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 10:03 am

    #2009911

  • RE: Casting one datetime as date converts other datetime fields

    What client is that?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 9:50 am

    #2009906

  • RE: Casting one datetime as date converts other datetime fields

    Screenshot please? And where are you running this from?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 9:37 am

    #2009901

  • RE: Unable to start the trace

    Again, you don't have to run the setstatus separately (and you probably shouldn't), the script already contains the line to start the trace.

    So leave...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 9:15 am

    #2009898

  • RE: Unable to start the trace

    What error are you getting?

    Note that you don't have to run sp_trace_setstatus separately. It's part of the script already,

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 9:08 am

    #2009892

  • RE: Two constraints under column definition?

    The first is the syntax for a default constraint (enforce a default value for a column). The second is referencing another block of syntax for creating check, unique and foreign...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 6:31 am

    #2009849

  • RE: Table level constraints vs. column level constraints

    https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-2017

    You will note that ALTER TABLE ... ALTER COLUMN don't allow for the addition of a check constraint. You want ALTER TABLE ... ADD CONSTRAINT,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 5:22 am

    #2009835

  • RE: Troubleshooting Deadlock, Victim holding on to shared lock

    Probably because it's in the process of reading the table and needs locks on both pages as it's locating the data. The ad-hoc SELECT, which is the one that has...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 5:15 am

    #2009834

  • RE: @@TRANCOUNT (variable or function)

    Nothing. It has no special meaning by itself.

    This works fine, but has no meaning difference to any other variable
    DECLARE @@i INT
    SET @@i = 1;

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 16, 2018 at 5:08 am

    #2009832

  • RE: Recovery of database

    Depends on how that snapshot is taken. Is it a block-by-block copy it's fine to checkDB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 15, 2018 at 10:20 am

    #2009654

  • RE: Recovery of database

    You don't. Run CheckDB.

    NorthernSoul - Thursday, October 11, 2018 6:43 AM

    You could try and restore it and see if it fails.

    Nah, I've...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 15, 2018 at 1:25 am

    #2009540

Viewing 15 posts - 76 through 90 (of 49,552 total)