Forum Replies Created

Viewing 15 posts - 23,341 through 23,355 (of 49,552 total)

  • RE: Try catch in a transaction block or transaction in try catch block???

    krishna.vanne (9/22/2011)

    My question is which one is apt or works better.

    It really doesn't make a difference.

    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

    September 23, 2011 at 2:57 am

    #1385581

  • RE: what's the best column for clustered indexes

    Have a read through this: http://www.sqlservercentral.com/articles/Indexing/68563/

    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

    September 23, 2011 at 2:26 am

    #1385570

  • RE: sql server memory leak.

    dm_tapas (9/23/2011)

    So, I don't want to restrict the Memory. I want to restrict Lock Avg. wait. ..

    Lock average wait time has absolutely nothing whatsoever to do with memory usage.

    If...

    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

    September 23, 2011 at 2:18 am

    #1385566

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/22/2011)

    GilaMonster (9/22/2011)

    EXEC TotalChangeOfSubject

    SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/

    Chapter 8: "The how and why of Page...

    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

    September 22, 2011 at 3:20 pm

    #1385471

  • RE: SSIS Vs sql import export performance

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1179722-364-1.aspx

    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

    September 22, 2011 at 2:24 pm

    #1385444

  • RE: How to troubleshoot error 3041? "BACKUP failed to complete the command BACKUP DATABASE XXXXX. Check the backup application log for detailed messages."

    Job history?

    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

    September 22, 2011 at 2:23 pm

    #1385442

  • RE: Are the posted questions getting worse?

    EXEC TotalChangeOfSubject

    SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/

    Chapter 8: "The how and why of Page Restores", Grant also...

    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

    September 22, 2011 at 2:21 pm

    #1385440

  • RE: What is the difference between 2008 R2 Express and 2008 R2 RTM?

    One is an edition, one is a version.

    SQL 2008 R2 RTM means 'release to manufacturing', it means SQL 2008 R2 (any edition) with no service packs.

    SQL 2008 R2 Express...

    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

    September 22, 2011 at 12:17 pm

    #1385370

  • RE: How to Encrypt column data and decrypt the same encrypted data

    trivedi.nikesh (9/22/2011)

    But please can you correct my code where which need to be changed as per your view, because I am not understanding your view completely.

    It's not a case...

    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

    September 22, 2011 at 11:49 am

    #1385357

  • RE: how to run a store proceedure in another user's context

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1179576-359-1.aspx

    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

    September 22, 2011 at 10:45 am

    #1385315

  • RE: unable to start new sql server 2008 instance

    Check the SQL error log, it should have the reasons why the service didn't start completely.

    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

    September 22, 2011 at 10:44 am

    #1385311

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (9/22/2011)

    Ugh, webinar done on DR this am. I hate these online things. No feedback from the audience makes me slightly insane.

    I know the feeling. Speaking...

    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

    September 22, 2011 at 10:35 am

    #1385303

  • RE: Can't restore .trn database please help

    No. Databases can never be downgraded.

    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

    September 22, 2011 at 9:46 am

    #1385268

  • RE: Can't restore .trn database please help

    The backup is damaged and unusable. Get a fresh backup and try again.

    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

    September 22, 2011 at 9:08 am

    #1385230

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (9/22/2011)

    jcrawf02 (9/22/2011)

    L' Eomot Inversé (9/21/2011)

    And from that, if anything over 5% actually understand french.

    I suspect less than 5% in USA, but much more than 5% in Europe, the Middle...

    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

    September 22, 2011 at 8:10 am

    #1385179

Viewing 15 posts - 23,341 through 23,355 (of 49,552 total)