Forum Replies Created

Viewing 15 posts - 7,786 through 7,800 (of 49,552 total)

  • RE: Pages in Buffer Cache

    Lonely Rogue (9/16/2014)

    and what happens with INSERT & DELETE?

    The same.

    further, isn't it an unnecessary effort to write back the unmodified rows too.. I wonder.

    Hmm... What's more effort...

    Write 8kb 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

    September 16, 2014 at 12:50 pm

    #1745881

  • RE: How do I handle transactional replication when moving the Subscriber (shutdown for a day and bring online)

    dagnea (9/16/2014)

    his reasoning, he insisted that the log file on the publishing database will not get truncated and will grow until the stopped subscription is started and the subscriber synched.

    Does...

    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 16, 2014 at 12:43 pm

    #1745876

  • RE: Training Question

    Sarah Wagner (9/16/2014)

    I have not taken the course, but have wanted to take the IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 and Part 2 classes by...

    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 16, 2014 at 12:25 pm

    #1745872

  • RE: Reindex - does it make data contiguous, space permitting

    ShrinkFile with EMPTYFile the files you want to remove. Then, once those are gone, shrinkfile on the remaining file to get it to the size you want, then rebuild all...

    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 16, 2014 at 11:20 am

    #1745847

  • RE: Replace CASE WHEN expression by boolean logic?

    in-line table-valued functions don't have their own execution plan. They're in-lined into the queries that call them, the combined query has an execution plan which is cached normally. You may...

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

    #1745812

  • RE: Removing database owner

    zedtec (9/16/2014)

    I know access for users will become limited to that particular database object.

    No. If the database's owner is not a valid AD account, most things will work fine. 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

    September 16, 2014 at 8:07 am

    #1745785

  • RE: trigger on insert to insert

    That code looks syntatically correct. Can't tell any more without more details. What's the problem with that trigger?

    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 16, 2014 at 5:41 am

    #1745742

  • RE: Replace CASE WHEN expression by boolean logic?

    Neither. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    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 16, 2014 at 5:39 am

    #1745738

  • RE: DBCC CHECKDB

    Then we (well you) have a problem...

    You can choose to repair and lose those ~50 rows

    You can choose to restore to the last known good backup (one before the corruption...

    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 16, 2014 at 5:28 am

    #1745734

  • RE: DBCC CHECKDB

    Can you afford to lose a pile of data from the table T_DABIR_NamehFiles? Probably around 50 odd rows.

    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 16, 2014 at 4:32 am

    #1745722

  • RE: DBCC CHECKDB

    Before you go hunting a repair command, please answer my question.

    GilaMonster (9/15/2014)

    Do you have a clean backup from before the corruption occurred as well as an unbroken chain of 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

    September 16, 2014 at 3:10 am

    #1745706

  • RE: Unexpected Increasing ram memory when using query in SQL 2014

    Yes, as I have said multiple times in this thread, that is how SQL server behaves.

    If this is a server dedicated to SQL (nothing else installed), why are you...

    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 16, 2014 at 3:04 am

    #1745703

  • RE: Getting Last inserted row in a table

    Without some column that indicates the order of rows inserted (identity, datetime default getdate()), 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

    September 16, 2014 at 2:44 am

    #1745698

  • RE: Unexpected Increasing ram memory when using query in SQL 2014

    Because it's not designed to.

    SQL Server is a service. The assumption is that it's serving multiple users, lots and lots of connections. Hence spending time and resources repeatedly releasing 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

    September 16, 2014 at 2:43 am

    #1745697

  • RE: Unexpected Increasing ram memory when using query in SQL 2014

    If you've set max server memory to 20GB, then SQL will increase it's memory usage up to 20GB and it will stay there. It will not deallocate memory unless 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

    September 16, 2014 at 1:35 am

    #1745683

Viewing 15 posts - 7,786 through 7,800 (of 49,552 total)