Forum Replies Created

Viewing 15 posts - 24,091 through 24,105 (of 49,552 total)

  • RE: Real value of TSQL Batches?

    Stamey (8/18/2011)

    So, to take this a little further, Is there any advantage to example 2 over example 1, besides network communication

    Not in this case.

    Sometimes you have to do things...

    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 18, 2011 at 7:47 am

    #1370124

  • RE: DATABASE corrupt

    Make sure that the exclusions in the anti-virus are correct. It should exclude a,, mdf, ndf, ldf, bak and trn files.

    Also, download sysinternals process explorer and use that to see...

    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 18, 2011 at 7:11 am

    #1370098

  • RE: Real value of TSQL Batches?

    A batch is just how the commands are packaged to SQL. There has to be a boundary somewhere, a start and end of the communication. It's nothing fancier than that

    Execution...

    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 18, 2011 at 7:09 am

    #1370097

  • RE: What happens internally when we backups?

    Only video. 40 or so minute Master-level video.

    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 18, 2011 at 6:43 am

    #1370076

  • RE: Transaction

    @@error only checks the error of the last statement, not the entire batch. Rather use Try Catch

    http://sqlinthewild.co.za/index.php/2011/05/17/on-transactions-errors-and-rollbacks/

    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 18, 2011 at 6:08 am

    #1370058

  • RE: Are the posted questions getting worse?

    Jim Murphy (8/18/2011)

    I expect things to simmer down more in a few more weeks. I think I bit off a little too much. .... sitting on the board...

    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 18, 2011 at 5:41 am

    #1370047

  • RE: Reading SQL Logs

    BinaryDigit (8/18/2011)

    I often make my own version of things that already exists as a learning excercise and add to it all the time when I have time. By studying what...

    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 18, 2011 at 5:39 am

    #1370046

  • RE: Reading SQL Logs

    BinaryDigit (8/18/2011)

    I'm basically going to create my own db compare tool probably and hopefully learn a lot of things about SQL in the process.

    I hope you have a few months...

    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 18, 2011 at 4:44 am

    #1370021

  • RE: DATABASE corrupt

    Ok....

    Has this database has worked before on this server?

    Is there another instance of SQL on this server?

    Is there an anti-virus running?

    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 18, 2011 at 4:27 am

    #1370013

  • RE: log_reuse_wait_desc = REPLICATION but no replication on server

    No, repair would not have caused this.

    Is there snapshot replication?

    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 18, 2011 at 3:51 am

    #1370001

  • RE: Reading SQL Logs

    BinaryDigit (8/18/2011)

    The Developers don't always script all their changes and then after making a upgrade to a system we left without a script or 2 sometimes so if we were...

    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 18, 2011 at 3:49 am

    #1369999

  • RE: Reading SQL Logs

    BinaryDigit (8/18/2011)

    We have SVN running for our .net code. Is it possible to intergrate SVN into Management studio?

    Have a look at RedGate's SQLSourceControl

    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 18, 2011 at 3:47 am

    #1369998

  • RE: Reading SQL Logs

    Depends. What kind of changes are you making and why can't you just apply them to the production DB later?

    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 18, 2011 at 3:13 am

    #1369991

  • RE: Reading SQL Logs

    There are tools you can buy to do that. The cheapest is around $1000

    The log is not meant to be human-readable, it does not contain any T-SQL, just the effects...

    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 18, 2011 at 2:33 am

    #1369979

  • RE: DATABASE corrupt

    I didn't say set the DB online. I said read through the SQL error logs and find all the errors relating to that 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

    August 18, 2011 at 2:32 am

    #1369978

Viewing 15 posts - 24,091 through 24,105 (of 49,552 total)