Forum Replies Created

Viewing 15 posts - 136 through 150 (of 340 total)

  • 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

  • RE: Fill Factor

    John Mitchell-245523 - Friday, November 10, 2017 7:12 AM

    If the table has a clustered index, that index will have its own fill...

    November 10, 2017 at 7:56 am

    #1967527

  • RE: What is use of pre-defined Schemas in SQL SERVER ?

    In other words...Roles are named set of privileges that can be assigned to other entities like users, schemas , logins..
    They go in combination as well ..  I suppose...

    November 9, 2017 at 7:36 am

    #1967371

  • RE: Does Resource Monitor report SQL Server memory usage correctly

    coolchaitu - Wednesday, November 8, 2017 9:36 AM

    Good Morning Experts,

    Does Resource Monitor report SQL Server memory usage correctly? If no, then which...

    November 9, 2017 at 6:49 am

    #1967355

  • RE: Is it a duplicate Index?

    anthony.green - Thursday, November 9, 2017 1:36 AM

    No they are not duplicates as the key order is different.

    Key order is important as its...

    November 9, 2017 at 6:43 am

    #1967353

  • RE: Column Length declaration

    Thanks John , Thom A and Bill .
    Thom, your approach seems suitable especially for systems with not-so-high memory if we look from the memory-grant perspective. Since SQL estimates the...

    November 9, 2017 at 12:40 am

    #1967303

  • RE: Changing NVARCHAR to VARCHAR...

    Jeff Moden - Tuesday, November 7, 2017 6:20 AM

    Arsh - Tuesday, November 7, 2017 3:24 AM

    November 8, 2017 at 12:46 am

    #1967085

  • RE: Changing NVARCHAR to VARCHAR...

    Sergiy - Tuesday, November 7, 2017 5:11 AM

    Arsh - Friday, November 3, 2017 10:44 AM

    November 8, 2017 at 12:36 am

    #1967084

  • RE: Changing NVARCHAR to VARCHAR...

    Hi,
    Also , would it be a huge overhead to SQL server if the " N' "  notation for passing the parameters is removed , as the NVARCHAR...

    November 7, 2017 at 3:49 am

    #1966953

  • RE: Changing NVARCHAR to VARCHAR...

    GilaMonster - Friday, November 3, 2017 9:09 AM

    Arsh - Thursday, November 2, 2017 7:43 PM

    November 7, 2017 at 3:24 am

    #1966947

  • RE: Changing NVARCHAR to VARCHAR...

    Thank u Gail. Then what about varchar(4000)? wouldn't it be a better design to use varchar(n) instead of of nvarchar(n) as it'll need half of the pages loaded into...

    November 3, 2017 at 10:44 am

    #1966588

  • RE: Changing NVARCHAR to VARCHAR...

    Thank you Gail. No .. I mean I am a DBA and there seems to be ambiguity about the role of a DBA in many organizations as to what a...

    November 2, 2017 at 7:43 pm

    #1966521

Viewing 15 posts - 136 through 150 (of 340 total)