Forum Replies Created

Viewing 15 posts - 8,521 through 8,535 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    EVE Online

    That's one of his more comprehensible posts.

    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 7, 2014 at 2:51 pm

    #1727581

  • RE: Parallelism, cxpacket, working threads....

    CXPacket is not a problem. CXPacket is a sign that you have queries running in parallel, nothing more. Since as soon as a query goes parallel there's a controller 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

    July 7, 2014 at 2:45 pm

    #1727578

  • RE: msdb marked suspect error 3313

    Restore from backup. then check your IO subsystem for problems.

    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 7, 2014 at 2:40 pm

    #1727576

  • RE: Are the posted questions getting worse?

    For anyone that gets frustrated with our posters here, here's a quote from a poster over on a gaming forum...

    I was thinking about reactivating my bomber but it occurred to...

    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 7, 2014 at 2:35 pm

    #1727573

  • RE: SQLServer2012 Locking

    TheSQLGuru (7/7/2014)

    TSQLLearner2014 (7/7/2014)

    Given the situation where we had to put a hot fix asap... This worked brilliantly. We have now time to fine tune the code.

    I will now try using...

    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 7, 2014 at 2:32 pm

    #1727572

  • RE: Server Max Memory Setting

    It's several caches including plan cache and data cache.

    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 7, 2014 at 2:30 pm

    #1727570

  • RE: Server Max Memory Setting

    Max server memory sets the size of the buffer pool. SQL can and does use a small amount of non-buffer memory in addition to that.

    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 7, 2014 at 10:08 am

    #1727474

  • RE: Are the posted questions getting worse?

    I love it when someone asks for the differences between two completely disparate 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

    July 7, 2014 at 9:33 am

    #1727454

  • RE: What are the difference between update statistics and execution plan in sql server

    Errrr.... Asking for the similarities would result in a much shorter list, an empty one.

    Update statistics is a command which you can run to update the statistics which record 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

    July 7, 2014 at 9:32 am

    #1727453

  • RE: Questions on backup/restore strategies

    Worst case, you go to restore a diff and SQL tells you that it's the wrong one, so you get the correct one and restore that.

    Practice with scripts, the GUI...

    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 7, 2014 at 9:17 am

    #1727437

  • RE: Default INT Parameter in SP

    Sean Lange (7/7/2014)

    info 58414 (7/7/2014)

    Hi,

    in a StoredProc I want depending on whether a parameter is passed formulate the Where clause accordingly.

    If parameter IS NOT NULL

    ...

    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 7, 2014 at 9:05 am

    #1727426

  • RE: very slow performance

    Grant Fritchey (7/7/2014)

    After you restructure it as was suggested already, this needs to be addressed:

    (RTRIM(pc.CODE))

    That will lead to scans which will seriously hurt performance. You shouldn't have functions on...

    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 7, 2014 at 9:03 am

    #1727425

  • RE: Questions on backup/restore strategies

    It doesn't matter if they run simultaneously.

    If you really don't want the full & diff to run at the same time (only one that makes sense to worry about), then...

    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 7, 2014 at 9:01 am

    #1727421

  • RE: Partitioned Table Practices

    Then don't waste your time looking at partitioning. Indexing along with tuning the queries should be your approach there.

    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 7, 2014 at 8:52 am

    #1727416

  • RE: Running Frequently Transaction logbackup during Integrity check DB

    No.

    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 7, 2014 at 2:08 am

    #1727286

Viewing 15 posts - 8,521 through 8,535 (of 49,552 total)