Forum Replies Created

Viewing 15 posts - 121 through 135 (of 335 total)

  • RE: Log file R drive- What is consuming it

    If transactional log backups have not been taken for a long time after full backup , the log keeps growing. Can be another reason apart from what experts have...

    November 20, 2017 at 8:58 am

    #1968794

  • RE: SQL server restart

    Eirikur Eiriksson - Monday, November 20, 2017 7:22 AM

    Arsh - Monday, November 20, 2017 6:13 AM

    November 20, 2017 at 8:53 am

    #1968791

  • RE: SQL server restart

    GilaMonster - Monday, November 20, 2017 6:15 AM

    It doesn't. Anything in memory is lost on a restart.

    Database recovery information comes from the...

    November 20, 2017 at 8:51 am

    #1968790

  • RE: Index Key Re-Ordering

    GilaMonster - Friday, November 17, 2017 1:49 PM

    An index rebuild *is* a physical reordering. It creates a new index and drops the...

    November 20, 2017 at 5:27 am

    #1968737

  • RE: Index Key Re-Ordering

    Thanks Scott and Gail. I think I got it .So It's not the actual data but the pointers to the data (cluster key contents ) that are in sequence in...

    November 17, 2017 at 12:09 pm

    #1968590

  • RE: Index Key Re-Ordering

    GilaMonster - Friday, November 17, 2017 5:31 AM

    Never.
    If a row has to move within an index, the update is split into...

    November 17, 2017 at 7:44 am

    #1968524

  • RE: "Cannot open user default database. Login failed"

    coolchaitu - Wednesday, November 15, 2017 3:17 AM

    Good Morning Experts,

    User received the below error while trying to connect to an instance

    "Cannot open...

    November 15, 2017 at 10:25 am

    #1968231

  • RE: Move user database

    rchantler - Monday, November 13, 2017 11:22 AM

    Why is detach/attach not recommended for moving a user database?

    There won't be an easy way...

    November 14, 2017 at 6:01 am

    #1967937

  • RE: CPU spike when executing a query in SQL

    Can also check if the Parallelism settings have been changed.

    November 13, 2017 at 8:06 am

    #1967789

  • RE: Sorting of Alphanumeric data

    drew.allen - Friday, November 10, 2017 7:49 AM

    It's pretty simple, really. ...

    November 13, 2017 at 3:19 am

    #1967729

  • RE: Fill Factor

    Thanks Jeff , John, Jason , Grant and Gail for the useful insights.

    November 13, 2017 at 3:16 am

    #1967728

  • RE: Fill Factor

    GilaMonster - Saturday, November 11, 2017 10:52 AM

    The clustered index is the table. Once you have a clustered index you don't...

    November 13, 2017 at 3:15 am

    #1967727

  • RE: Fill Factor

    For more clarity on this point , when a new row is inserted , why does it have to be inserted in the 'Index Page' ? The Index page...

    November 11, 2017 at 5:23 am

    #1967635

  • RE: Fill Factor

    Jeff Moden - Friday, November 10, 2017 7:30 PM

    Grant Fritchey - Friday, November 10, 2017 12:26 PM

    November 11, 2017 at 1:44 am

    #1967630

  • RE: Fill Factor

    John Mitchell-245523 - Friday, November 10, 2017 8:00 AM

    In a heap, new rows are inserted at the end.  Is that what you...

    November 10, 2017 at 8:29 am

    #1967533

Viewing 15 posts - 121 through 135 (of 335 total)