Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 49,552 total)

  • RE: tempdb curiosity

    It's a manual process to change the starting sizes for the files. SQL won't do it.

    TempDB data files should all have the same initial size and same autogrow...

    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

    April 18, 2017 at 5:04 pm

    #1938695

  • RE: Table size and indexes

    SQLRNNR - Tuesday, April 18, 2017 2:30 PM

     The rest of the story is there was always a duplicate index for the...

    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

    April 18, 2017 at 2:36 pm

    #1938681

  • RE: creating new partition files on table

    Leave it to run please. We need an idea of how many rows are going to have to move in order to decide on a strategy

    And I didn't...

    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

    April 18, 2017 at 2:14 pm

    #1938676

  • RE: Table size and indexes

    SQLRNNR - Tuesday, April 18, 2017 1:36 PM

    Jeff Moden - Monday, April 17, 2017 3:47 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

    April 18, 2017 at 1:50 pm

    #1938667

  • RE: creating new partition files on table

    If the split takes time then there's data that needs to be moved to the new partition. It's generally recommended to split so that the new partition is empty. 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

    April 18, 2017 at 1:45 pm

    #1938666

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Tuesday, April 18, 2017 12:08 PM

    How do you respond to his latest response that an experienced person is...

    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

    April 18, 2017 at 12:30 pm

    #1938642

  • RE: Are the posted questions getting worse?

    drew.allen - Tuesday, April 18, 2017 11:14 AM

    Luis Cazares - Tuesday, April 18, 2017 10:53 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

    April 18, 2017 at 12:29 pm

    #1938641

  • RE: A little tale and a seven questions about SQL partition

    Grant Fritchey - Tuesday, April 18, 2017 10:40 AM

     Validate that you're seeing partition elimination and not just good performance because of 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

    April 18, 2017 at 10:50 am

    #1938616

  • RE: Deadlocks on Clustered Index

    Then I'm afraid you'll have to live with the deadlocks.

    For anyone curious, what's happening is the following:
    Session 1 (the update) takes a U lock on a key....

    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

    April 18, 2017 at 10:12 am

    #1938592

  • RE: A little tale and a seven questions about SQL partition

    bmg002 - Tuesday, April 18, 2017 9:47 AM

    plus he is a VERY smart SQL guy based on the forum posts I've read

    Errr......

    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

    April 18, 2017 at 9:54 am

    #1938571

  • RE: set xact_abort on required if entire proc in explicit transaction?

    Name on the BEGIN TRANSACTION - fine. Name on the COMMIT TRANSACTION - fine. Name on the ROLLBACK TRANSACTION - potential error that can leave orphaned transactions.

    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

    April 18, 2017 at 9:49 am

    #1938567

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Tuesday, April 18, 2017 8:56 AM

    JustMarie - Tuesday, April 18, 2017 8:14 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

    April 18, 2017 at 9:32 am

    #1938556

  • RE: A little tale and a seven questions about SQL partition

    Ok, bit of a short reply because I need to leave work 10 minutes ago to miss the traffic...

    Partitioning is NOT for performance. It's for data management, for...

    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

    April 18, 2017 at 8:38 am

    #1938539

  • RE: SQL Server | Architecture design -

    ranitb - Tuesday, April 18, 2017 6:23 AM

    Ex. User "RB" logs into database and lands on schema "Sales", as configured by DBA....

    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

    April 18, 2017 at 7:47 am

    #1938520

  • RE: SQL Server | Architecture design -

    GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON schema::Sales TO <database role>

    That's the basic principal of it. Don't grant permissions to the database, don't use the db_owner fixed role...

    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

    April 18, 2017 at 6:00 am

    #1938483

Viewing 15 posts - 1,546 through 1,560 (of 49,552 total)