Forum Replies Created

Viewing 15 posts - 121 through 135 (of 49,552 total)

  • RE: decrypting data returns invalid data or wrong character set

    Then


    OPEN SYMMETRIC KEY MyKey
    DECRYPTION BY CERTIFICATE MyCert;
    GO
    SELECT
    PlainTextData
    ,TextData_encrypted AS EncryptedTextData
    ,CONVERT(VARCHAR(15), DECRYPTBYKEY(TextData_encrypted)) AS...

    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

    July 31, 2018 at 1:18 pm

    #1999759

  • RE: decrypting data returns invalid data or wrong character set

    What was the data type of the data you encrypted?

    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

    July 31, 2018 at 12:32 pm

    #1999745

  • RE: What does your backup process look like?

    Mike Scalise - Tuesday, July 31, 2018 9:48 AM

    - Daily: run checkdb (physical_only) on NODE1, restore weekly full backup + t-log backups...

    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

    July 31, 2018 at 11:03 am

    #1999726

  • RE: Are the posted questions getting worse?

    WayneS - Tuesday, July 31, 2018 8:18 AM

    Ed Wagner - Monday, July 30, 2018 11:32 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

    July 31, 2018 at 8:19 am

    #1999683

  • RE: What does your backup process look like?

    Grant Fritchey - Tuesday, July 31, 2018 7:44 AM

     Then, for the logical checks, you can offload those to a secondary box...

    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

    July 31, 2018 at 7:47 am

    #1999677

  • RE: What does your backup process look like?

    Mike Scalise - Tuesday, July 31, 2018 7:10 AM

    So, are you saying that I would run DBCC with physical_only on my...

    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

    July 31, 2018 at 7:45 am

    #1999676

  • RE: how to restore an encrypted database

    If the correct certificates are installed into master, then the restore is identical to a non-encrypted backup afaik.

    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

    July 31, 2018 at 5:57 am

    #1999655

  • RE: Index - Whether or not my table should have one

    If the staging tables are a decent size (over a million rows), consider creating them with a clustered columnstore index.

    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

    July 31, 2018 at 5:38 am

    #1999649

  • RE: Scripts runs on 2017, but not on my 2016??

    quinn.jay - Monday, July 30, 2018 2:58 PM

    heb1014 - Monday, July 30, 2018 2:49 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

    July 31, 2018 at 5:36 am

    #1999648

  • RE: How to set the primary key for each table

    There's no 'for each table' construct

    You can write some complicated dynamic SQL to generate the ALTER  TABLE  statements automatically, check them all to make sure they're correct and...

    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

    July 31, 2018 at 5:33 am

    #1999647

  • RE: Joining large tables to small tables.

    andycadley - Thursday, July 26, 2018 12:18 PM

    sgmunson - Thursday, July 26, 2018 11:26 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

    July 26, 2018 at 4:14 pm

    #1999174

  • RE: Difference in performance restore database

    The second SQL has to go and create the files, which takes time.

    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

    July 26, 2018 at 8:16 am

    #1999110

  • RE: Odd memory stats

    From the numbers, I'm going to guess you have external memory pressure. Something outside of SQL is consuming memory, and so SQL cannot increase its memory usage. That would be...

    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

    July 26, 2018 at 8:15 am

    #1999109

  • RE: RPC:Completed event in sql trace

    RPC is remote procedure call. It's the call from the application.
    So, if app calls proc 1, which calls proc 2, proc 3 and proc 4, you would have got...

    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

    July 26, 2018 at 8:10 am

    #1999106

  • RE: How to implement the threading in storeprocedures without duplicate

    There's no way to 'thread' within a stored procedure. You can have multiple procedures that each work on a subset of the data, run them from jobs or different connections.

    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

    July 26, 2018 at 7:14 am

    #1999082

Viewing 15 posts - 121 through 135 (of 49,552 total)