Forum Replies Created

Viewing 15 posts - 991 through 1,005 (of 49,552 total)

  • RE: Are these both same? Begin Tran & Begin Try

    curious_sqldba - Thursday, August 3, 2017 8:52 AM

    Joe Torre - Tuesday, August 1, 2017 6:12 PM

    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

    August 3, 2017 at 9:02 am

    #1953988

  • RE: AlwaysOn Backups on Secondaries

    SQLSACT - Thursday, August 3, 2017 7:42 AM

    GilaMonster - Thursday, August 3, 2017 7:38 AM

    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

    August 3, 2017 at 8:05 am

    #1953974

  • RE: How to access another server temp table without any Linked server

    How can you not have permission to create a temp table?

    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

    August 3, 2017 at 7:40 am

    #1953967

  • RE: AlwaysOn Backups on Secondaries

    Why are you currently doing weekly fulls and daily diffs?

    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

    August 3, 2017 at 7:38 am

    #1953966

  • RE: AlwaysOn Backups on Secondaries

    Short answer: Yes.

    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

    August 3, 2017 at 7:10 am

    #1953960

  • RE: Best way to encrypt credit card information?

    WebTechie - Thursday, August 3, 2017 6:10 AM

    Thanks Gail.

    But the column is varchar and the manager doesn't want to change that. 

    He...

    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

    August 3, 2017 at 7:10 am

    #1953959

  • RE: Best way to encrypt credit card information?

    The stored procedure does the insert, taking parameters, meaning that you can change the data type to varbinary, and have the procedure directly insert the encrypted value. A trigger, since...

    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

    August 3, 2017 at 6:01 am

    #1953932

  • RE: Best way to encrypt credit card information?

    WebTechie - Thursday, August 3, 2017 5:21 AM

    Ok, that was my thought and I actually got it to work well.  Management didn't...

    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

    August 3, 2017 at 5:39 am

    #1953922

  • RE: Are the posted questions getting worse?

    Thom A - Thursday, August 3, 2017 2:10 AM

    This one is clearly a homework questions: https://www.sqlservercentral.com/Forums/FindPost1890108.aspx

    What is truly "amusing" though, is...

    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

    August 3, 2017 at 2:34 am

    #1953902

  • RE: Forum Etiquette: How to post data/code on a forum to get the best help

    Thom A - Thursday, August 3, 2017 2:03 AM

    ricomk007 - Thursday, August 3, 2017 1:54 AM

    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

    August 3, 2017 at 2:34 am

    #1953901

  • RE: Are these both same? Begin Tran & Begin Try

    curious_sqldba - Wednesday, August 2, 2017 3:39 PM

    I guess if try/catch is taking care of error handling and rollback why do...

    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

    August 3, 2017 at 2:31 am

    #1953900

  • RE: stored procedure to copy a record

    Table definitions please. There's no way to debug a data type conversion error without knowing what the data types are.

    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

    August 2, 2017 at 3:18 pm

    #1953857

  • RE: Started to see "Version store is full. New version(s) could not be added." in the Event Log. How can I resolve this?

    Either TempDB is tiny and can't grow, or you have some *really* long running transactions that's preventing the version store from being cleaned up.
    Check which please.

    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

    August 2, 2017 at 3:17 pm

    #1953856

  • RE: Are these both same? Begin Tran & Begin Try

    There's no point in setting the isolation level. You have no select queries, so there's nothing for it to affect. Data modifications always take exclusive locks.

    You don't need...

    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

    August 2, 2017 at 3:16 pm

    #1953855

  • RE: Are the posted questions getting worse?

    Ed Wagner - Wednesday, August 2, 2017 7:03 AM

    GilaMonster - Wednesday, August 2, 2017 6:38 AM

    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

    August 2, 2017 at 7:08 am

    #1953763

Viewing 15 posts - 991 through 1,005 (of 49,552 total)