Forum Replies Created

Viewing 15 posts - 391 through 405 (of 49,552 total)

  • RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

    .

    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

    January 26, 2018 at 6:13 am

    #1977510

  • RE: Snapshot Isolation

    And no, READ COMMITTED SNAPSHOT and ALLOW SNAPSHOT ISOLATION are not the same thing, they don not have the same effect in the database.

    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

    January 26, 2018 at 5:43 am

    #1977507

  • RE: Snapshot Isolation

    Keep in mind that enabling that has had only two effects.

    1)  All data modifications will now be writing their previous versions into the version store in TempDB

    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

    January 26, 2018 at 5:37 am

    #1977506

  • RE: sql server job has been modified by some DBA/user, I want to know which user modified/change job.

    Might be in the default trace, I can't remember if jobs are one of the things it tracks.
    Other than that, you'd need custom monitoring

    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

    January 26, 2018 at 5:35 am

    #1977505

  • RE: How to rollback Dacpac applied

    Unless the whole thing was run in a transaction and not committed (so connection still open), your 'rollback' option is going to be restore from a backup taken before the...

    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

    January 26, 2018 at 12:26 am

    #1977485

  • RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

    xsevensinzx - Thursday, January 25, 2018 8:18 PM

    Really comparing apples to oranges here.

    Not really. We're talking about consuming...

    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

    January 26, 2018 at 12:24 am

    #1977484

  • RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

    GroverVivek - Thursday, January 25, 2018 6:45 PM

    Is it really easy to learn SQL for 2-3 months and get a job...

    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

    January 26, 2018 at 12:13 am

    #1977483

  • RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

    Revenant - Thursday, January 25, 2018 3:12 PM

    GilaMonster - Thursday, January 25, 2018 2: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

    January 25, 2018 at 3:18 pm

    #1977446

  • RE: Find Affected Row Count from a Dynamic Query

    Please note: 3 year old thread

    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

    January 25, 2018 at 2:15 pm

    #1977435

  • RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

    Revenant - Thursday, January 25, 2018 1:44 PM

    GroverVivek - Thursday, January 25, 2018 11:04 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

    January 25, 2018 at 2:13 pm

    #1977434

  • RE: Error handling using tsql

    You can't do row-level redirection in T-SQL. Inserts as an operation fail entirely.

    What you will need to do is clean the data before you insert it into the...

    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

    January 25, 2018 at 12:32 pm

    #1977416

  • RE: Distributed Replay Issue.

    I've run it on more than 4GB of data. Could be one of the files is damaged and unreadable, Can't really tell from the error.

    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

    January 25, 2018 at 11:56 am

    #1977410

  • RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

    Jeff Moden - Thursday, January 25, 2018 7:48 AM

    jonathan.crawford - Thursday, January 25, 2018 6:56 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

    January 25, 2018 at 8:50 am

    #1977360

  • RE: get the last active data

    Row_number partition by name order by year and filter for that = 1 (you'll need a subquery or CTE)

    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

    January 25, 2018 at 7:28 am

    #1977332

  • RE: Get the most recent active value

    Please don't post the same question multiple times.
    No replies here please. replies to  https://www.sqlservercentral.com/Forums/1920025/get-the-last-active-data

    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

    January 25, 2018 at 7:27 am

    #1977330

Viewing 15 posts - 391 through 405 (of 49,552 total)