Forum Replies Created

Viewing 15 posts - 23,206 through 23,220 (of 49,552 total)

  • RE: Create Index based on execution plan

    gregory.anderson (9/28/2011)

    My Cust_Ident_Type table is only 15 rows, could that be the reason why it's not using the nonclustered index?

    Yes. With 15 rows it's likely that all the data will...

    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 28, 2011 at 10:38 am

    #1387939

  • RE: One index, or three?

    One index. Because SQL is not going to use three different structures and then have to patch them together unless it really has no other choice. It can do index...

    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 28, 2011 at 10:35 am

    #1387935

  • RE: One index, or three?

    Do you have 3 queries that each filter/join on one column, or do you have one query that filters/joins on three columns?

    For the former, three indexes, for the latter, one...

    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 28, 2011 at 10:26 am

    #1387923

  • RE: Create Index based on execution plan

    gregory.anderson (9/28/2011)

    I'm doing a sp_recompile on my table after each addition/deletion of these indexes to make sure that it rebuilds the execution plan, is there something else that I need...

    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 28, 2011 at 10:24 am

    #1387921

  • RE: Create Index based on execution plan

    Indexes support filters first and foremost. So you want the columns that are part of the filter first (to cut the number of rows in consideration first). So you want...

    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 28, 2011 at 10:23 am

    #1387919

  • RE: Massive Negative performance change for a delete

    Jack Corbett (9/28/2011)

    GilaMonster (9/28/2011)

    What waits is the query incurring?

    I should be ashamed that I posted in the 2008 forums when the query is running against 2005. My excuse is...

    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 28, 2011 at 8:55 am

    #1387830

  • RE: Writing to the Passive Node

    No. In a cluster, the inactive node is not running, that's why it's inactive.

    How are you doing a cluster with local storage? If it's not a SAN, there can't be...

    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 28, 2011 at 8:45 am

    #1387818

  • RE: Massive Negative performance change for a delete

    What waits is the query incurring?

    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 28, 2011 at 8:11 am

    #1387791

  • RE: how to convert the data type

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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 28, 2011 at 7:47 am

    #1387777

  • RE: Are the posted questions getting worse?

    WayneS (9/28/2011)

    Grant Fritchey (9/28/2011)

    Jack Corbett (9/28/2011)

    Hey can an execution plan expert (Grant?) take a look at this thread, http://www.sqlservercentral.com/Forums/Topic1181619-338-1.aspx. Interesting behavior noted in execution plan properties with SET ANSI...

    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 28, 2011 at 7:45 am

    #1387775

  • RE: XML EXPLICIT ISSUE IN SP

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1182356-391-1.aspx

    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 28, 2011 at 5:46 am

    #1387677

  • RE: About XML Explicit

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1182356-391-1.aspx

    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 28, 2011 at 5:46 am

    #1387676

  • RE: how actually this query executes?

    ...

    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 28, 2011 at 5:30 am

    #1387670

  • RE: Hello

    You're going to have to give us a lot, lot more information than that. There's no way to even begin to diagnose a problem with that information.

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

    #1387668

  • RE: DBCC check db error

    The table you defined has the column Error defined as a smallest, however error numbers can go above 32767. Change that column to an integer.

    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 28, 2011 at 5:25 am

    #1387666

Viewing 15 posts - 23,206 through 23,220 (of 49,552 total)