Forum Replies Created

Viewing 15 posts - 1,021 through 1,035 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Monday, July 31, 2017 5:01 AM

    I'm on a roll this morning. Just started a brand new to-do list of...

    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 31, 2017 at 5:36 am

    #1953349

  • RE: Are the posted questions getting worse?

    Crystal ball to aisle 7 please. Crystal ball to aisle 7.
    https://www.sqlservercentral.com/Forums/1889451/Should-I-Redesign-table

    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 31, 2017 at 5:33 am

    #1953347

  • RE: Should I Re-design table?

    A picture's not very useful. Save the deadlock graph as a .xdl file, and attach it.

    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 31, 2017 at 5:32 am

    #1953346

  • RE: Should I Re-design table?

    No way to answer that question without a lot more details.

    Start with the table design and the deadlock graphs

    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 31, 2017 at 4:13 am

    #1953336

  • RE: Backup DB as a bak file type?

    Make sure you only have one file name in that window, otherwise your backup is spread across the files and they are *all* necessary to restore the backup (they're slices,...

    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 30, 2017 at 4:10 pm

    #1953317

  • RE: Backup DB as a bak file type?

    When you give the backup file a name, give it the .bak extension. SSMS doesn't do it automatically (or you can change it after the backup, will have the same...

    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 30, 2017 at 3:53 pm

    #1953312

  • RE: Notification if any plan changes against any specific table/procedure

    SQL-DBA-01 - Sunday, July 30, 2017 2:22 PM

    Jeff Moden - Sunday, July 30, 2017 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

    July 30, 2017 at 3:36 pm

    #1953310

  • RE: Notification if any plan changes against any specific table/procedure

    Jeff Moden - Sunday, July 30, 2017 2:12 PM

    SQL-DBA-01 - Saturday, July 29, 2017 1:42 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

    July 30, 2017 at 3:32 pm

    #1953309

  • RE: Notification if any plan changes against any specific table/procedure

    You could have en extended event session that tracks the recompile and cache insert events, but then you'd still have to check what plans is in cache and have some...

    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 30, 2017 at 7:36 am

    #1953301

  • RE: Memory Issue - SQL Server 2008 R2

    Can you post any relevant logs, SQL error log, Windows event log?

    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 30, 2017 at 7:33 am

    #1953300

  • RE: DTA Stop in between will DTa not release the control

    Don't ever run DTA against your production DB. If you do want to use it, run it on a test server and evaluate its recommendations carefully before implementing any.

    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 28, 2017 at 4:19 pm

    #1953259

  • RE: Consistency Errors on System Tables

    joliveira 19841 - Friday, July 28, 2017 5:21 AM

    GilaMonster - Friday, July 28, 2017 2:32 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

    July 28, 2017 at 6:02 am

    #1953178

  • RE: Consistency Errors on System Tables

    Oh this is going to be a bloody pain to fix. 🙁

    How big is the DB?
    To be honest, it may be simpler to move everything over 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 28, 2017 at 2:32 am

    #1953159

  • RE: Index Usage Question

    http://www.sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/

    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 28, 2017 at 2:28 am

    #1953157

  • RE: Queries taking longer than usual time for a subset of inputs when reaching the end

    Can you post the code?

    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 28, 2017 at 2:26 am

    #1953154

Viewing 15 posts - 1,021 through 1,035 (of 49,552 total)