Forum Replies Created

Viewing 15 posts - 35,746 through 35,760 (of 49,552 total)

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    Cliff Jones (11/18/2009)

    The Tuning Adviser often recommends that a column which is also a part of the Clustered index be added as an included column. I do not do...

    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

    November 19, 2009 at 3:10 am

    #1081421

  • RE: Are the posted questions getting worse?

    john.arnott (11/18/2009)

    Again, as Emily Letitia would have said, "Never mind."

    Indeed. Who creates a database without checking to see if the drive they want to create it on really exists?

    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

    November 19, 2009 at 3:06 am

    #1081418

  • RE: Count(*)

    1) Probably.

    2) Still don't understand what you're asking. When a transaction occurs, all necessary changes are made in memory. When the transaction is completed, the changes are hardened into 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

    November 19, 2009 at 3:05 am

    #1081417

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    sjsubscribe (11/18/2009)

    Say I have a non-unique, non-clustered index with some included columns. It covers a bunch of frequently used queries. I could make it an unique index if I add...

    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

    November 19, 2009 at 3:03 am

    #1081415

  • RE: Reasonable performance?

    CGSJohnson (11/18/2009)

    I am running a query against that table and, from my testing, it takes anywhere from 28 to 73 seconds to return results.

    How many rows returned? What's...

    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

    November 18, 2009 at 12:47 pm

    #1081156

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    Charles Kincaid (11/18/2009)

    When talking about included columns one would guess that the order is no more or less important than the column order in the table itself.

    Indeed. Order for included...

    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

    November 18, 2009 at 12:37 pm

    #1081139

  • RE: Performance issues

    Yes, but would still like table definitions, index definitions and the query that we're trying to help you with.

    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

    November 18, 2009 at 12:36 pm

    #1081138

  • RE: Transaction chopping

    The problem is, without seeing the cursor definition and how the inserts and deletes relate to the cursor, it's hard to say anything useful. A simple insert and delete in...

    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

    November 18, 2009 at 9:28 am

    #1080992

  • RE: SQL Bits - Newport - 19th to 21st November 2009

    Nope. Bit far to travel and I've already done Seattle this year. Enough travelling for a few months.

    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

    November 18, 2009 at 9:03 am

    #1080974

  • RE: Performance problem issue...............

    The first thing you need to ask is whether the poor performance is normal or abnormal. Is the system always slow or is it usually fast, but has been slow...

    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

    November 18, 2009 at 9:02 am

    #1080973

  • RE: Transaction chopping

    Is there a question here?

    Can you give the cursor definition, the full FETCH INTO and the full insert and delete?

    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

    November 18, 2009 at 8:04 am

    #1080923

  • RE: DROP INDEX ERROR

    Drop the foreign key first, then drop the index. I suspect you won't be able to recreate the foreign key unless the index is recreated.

    Why do you need to...

    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

    November 18, 2009 at 7:59 am

    #1080918

  • RE: Microsoft gold partner

    Then call Microsoft and ask them. Contact numbers for the various regions are given on the partner site: https://partner.microsoft.com/global/40032423

    As I said, the fees differ per region, so only someone at...

    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

    November 18, 2009 at 7:55 am

    #1080915

  • RE: Constraints and indexes

    Please post new questions in a new thread and give some detail a to what you're trying to do and exactly what error you're getting.

    Thanks.

    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

    November 18, 2009 at 7:35 am

    #1080901

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    jcrawf02 (11/18/2009)

    ok, so if I have a system generated UID from a different table, but the values are not entirely unique, only a few duplicates in my heap, I could/should...

    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

    November 18, 2009 at 7:33 am

    #1080900

Viewing 15 posts - 35,746 through 35,760 (of 49,552 total)