Forum Replies Created

Viewing 15 posts - 466 through 480 (of 758 total)

  • RE: Index Range_scans

    GilaMonster (8/15/2012)

    If you are creating an index on a column that you know is unique, make the index unique. If you're creating an index on a column that's not unique,...

    August 15, 2012 at 10:52 am

    #1526108

  • RE: Index Range_scans

    GilaMonster (8/15/2012)

    SQLSACT (8/15/2012)

    Would fragmentation affect this process negatively?

    If the range scan is large enough and is from disk, yes probably.

    If we had a query like this: select Col1 from Indexing2...

    August 15, 2012 at 4:34 am

    #1525936

  • RE: Index Range_scans

    opc.three (8/14/2012)

    SQLSACT (8/10/2012)

    HowardW (8/10/2012)

    It's not relevant how many rows were actually returned, it still has to access a range in the index if it's not marked as UNIQUE as it...

    August 15, 2012 at 12:09 am

    #1525883

  • RE: SQL Distributed Transactions - DTC

    Perry Whittle (8/14/2012)

    the DTC is used by many applications including sql server. In SQL Server a dtc is used for remote transactions such as lnked servers and openrowset queries.

    A clustered...

    August 14, 2012 at 11:01 am

    #1525669

  • RE: SQLIO Disk Testing

    Perry Whittle (8/14/2012)

    SQLSACT (8/14/2012)

    Perry Whittle (8/14/2012)

    If <mask> is absent or 0, then no affinity

    will be enforced.

    :Whistling: 😉

    Thanks

    What does that mean?

    OK, now i'm worried 🙂

    if you...

    August 14, 2012 at 7:29 am

    #1525500

  • RE: SQLIO Disk Testing

    Perry Whittle (8/14/2012)

    If <mask> is absent or 0, then no affinity

    will be enforced.

    :Whistling: 😉

    Thanks

    What does that mean?

    August 14, 2012 at 6:53 am

    #1525481

  • RE: SQLIO Disk Testing

    Perry Whittle (8/14/2012)

    well firstly, each of the runs really needs to run for longer than 5 seconds to get any real metrics 😉

    What are the results that are produced from...

    August 14, 2012 at 6:07 am

    #1525446

  • RE: SQLIO Disk Testing

    Perry Whittle (8/14/2012)

    can you supply details of the config file you are using

    August 14, 2012 at 2:49 am

    #1525398

  • RE: Index Fragmentation and Performance

    GilaMonster (8/12/2012)

    SQLSACT (8/12/2012)

    GilaMonster (8/10/2012)

    No. That's literally the number of pages that were allocated, middle or end. Tracking mid-index page splits (which are the harmful ones) is near-impossible until SQL 2012.

    So...

    August 12, 2012 at 12:43 pm

    #1524868

  • RE: Index Fragmentation and Performance

    GilaMonster (8/10/2012)

    No. That's literally the number of pages that were allocated, middle or end. Tracking mid-index page splits (which are the harmful ones) is near-impossible until SQL 2012.

    Thanks

    So the only...

    August 12, 2012 at 11:19 am

    #1524864

  • RE: Index Fragmentation and Performance

    GilaMonster (8/10/2012)

    pooyan_pdm (8/8/2012)

    And about the update I don't know what you think of a index key update but it' effects on page splits and fragmentation is the same as...

    August 10, 2012 at 1:36 pm

    #1524643

  • RE: Index Fragmentation and Performance

    Thanks Guys!!

    August 10, 2012 at 4:45 am

    #1524319

  • RE: SQL Wait Stats

    pooyan_pdm (8/8/2012)

    the signal wait indicates the time the thread has been waiting just for CPU but the wait_time_ms is the time the process has been waiting for CPU ...

    August 10, 2012 at 4:44 am

    #1524317

  • RE: Index Range_scans

    HowardW (8/10/2012)

    It's not relevant how many rows were actually returned, it still has to access a range in the index if it's not marked as UNIQUE as it doesn't know...

    August 10, 2012 at 4:40 am

    #1524314

  • RE: Security - Owned Schemas

    Evil Kraig F (8/8/2012)

    SQLSACT (8/7/2012)

    Hi All

    I'm trying to understand something regarding SQL Server security

    If I have a SQL Login and that Login is also a user on a database. What...

    August 10, 2012 at 4:36 am

    #1524310

Viewing 15 posts - 466 through 480 (of 758 total)