Forum Replies Created

Viewing 15 posts - 6,511 through 6,525 (of 49,552 total)

  • RE: LATCH_EX and CXPACKET waitstates are too high

    Maxdop sets the limit for how many threads may be *running* at one time, not how many threads in total there are. So of those 17, at most 8 will...

    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

    February 25, 2015 at 5:03 am

    #1779844

  • RE: How to Update multiple column with Multiple condition

    I suspect that you will need to do this as three updates.

    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

    February 25, 2015 at 3:24 am

    #1779831

  • RE: After which period autoshrink event triggers

    Autoshrink is one of the very few settings that should only every have a single value, no matter what the DB or system. False.

    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

    February 25, 2015 at 2:37 am

    #1779826

  • RE: Data movement on TDE enabled database!!!

    Why do you need to export/import to do a version upgrade?

    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

    February 25, 2015 at 1:53 am

    #1779817

  • RE: What is the impact of running 'sys.dm_os_wait_stats', CLEAR on production server

    No impact, though if you have monitoring tools looking at the wait stats they may get confused.

    Personally I prefer not to clear it when doing analysis and just take diffs...

    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

    February 25, 2015 at 1:52 am

    #1779815

  • RE: performance table insert Urgent

    Is the performance problem blocking-related? If so, have you considered using one of the optimistic concurrency isolation levels? That's read-committed-snapshot isolation or snapshot isolation levels?

    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

    February 24, 2015 at 6:48 am

    #1779568

  • RE: compatability level question

    kevaburg (2/24/2015)

    So I migrate a 2008R2 database to 2014 and do not alter the compatibility mode. I have in end effect a database running on a 2014 Server 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

    February 24, 2015 at 5:36 am

    #1779551

  • RE: SQL apparently not realising it should ditch a cached execution plan and make a new one

    julian.fletcher (2/19/2015)

    So perhaps it's an initial call with @Mode = 1 (say) which was OK, followed by @Mode = 7 was was NG. If that's the case, we presumably just...

    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

    February 24, 2015 at 5:26 am

    #1779549

  • RE: Shrink Log in Synchronized DB's

    First, why do you need to shrink the log at all?

    Second, no you absolutely do not have to change recovery model and you shouldn't. If you've got HA set up...

    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

    February 24, 2015 at 3:09 am

    #1779520

  • RE: Correct SQL version? Developer vs. Standard 2014

    Other than better performance, the new features of SQL 2014 and a version which is under support and will get service packs and updates?

    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

    February 24, 2015 at 1:46 am

    #1779501

  • RE: select query works but delete query throws error

    passiondba (2/23/2015)

    I can write a query like below

    insert into audittable ......(condition goes here)

    delete from DupeChecktable......(Condition goes here)

    But there is no guarantee that first insert happens and 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

    February 24, 2015 at 1:44 am

    #1779500

  • RE: Restart Windows Server with SQL after updates

    Perfectly. To be honest, it's fairly safe (at least from SQL's side) to just power off without any form of clean shutdown (my home server will attest to that, having...

    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

    February 23, 2015 at 7:12 am

    #1779250

  • RE: SQL Server 2012 - Transaction log growth

    Kutang Pan (2/23/2015)

    Bouke Bruinsma (2/23/2015)

    I wouldn't dare questioning your or Gails remarks. But I could give many examples where a database is in full recovery mode without any backup strategy...

    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

    February 23, 2015 at 6:56 am

    #1779245

  • RE: Correct SQL version? Developer vs. Standard 2014

    I can't answer that (not willing to be a lawsuit target)

    Standard can be, iirc, licensed with server and CAL. Do the maths, CAL may be cheaper if you only have...

    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

    February 23, 2015 at 6:23 am

    #1779236

  • RE: SQL Server 2012 - Transaction log growth

    Bouke Bruinsma (2/23/2015)

    I wouldn't dare questioning your or Gails remarks. But I could give many examples where a database is in full recovery mode without any backup strategy in place.

    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

    February 23, 2015 at 5:30 am

    #1779229

Viewing 15 posts - 6,511 through 6,525 (of 49,552 total)