Forum Replies Created

Viewing 15 posts - 29,311 through 29,325 (of 49,552 total)

  • RE: Index Question

    Would one of mine do?

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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, 2010 at 10:15 am

    #1252633

  • RE: Index Question

    Ellen-477471 (11/18/2010)

    I've never been certain if the optimizer added it twice. Or if the order changes.

    SQL doesn't add it twice (and it's not done by the optimiser)

    If the clustering...

    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, 2010 at 9:55 am

    #1252622

  • RE: Index Question

    nigelrivett (11/18/2010)

    The clustered index columns will be added as included rather than indexed.

    For a unique nonclustered index, the clustering key is present only at the leaf level (like an include...

    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, 2010 at 9:46 am

    #1252617

  • RE: Index Question

    Ellen-477471 (11/18/2010)

    so, would if be most efficient and work correctly if I just create the index with the column 'invtypeid' only?

    leaving the 'itemnumber' implied?

    Work correctly, yes. Most efficient, no. If...

    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, 2010 at 9:09 am

    #1252597

  • RE: Are the posted questions getting worse?

    I use option 3, but them Microsoft's the sole sponsor at the moment.

    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, 2010 at 6:59 am

    #1252484

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/17/2010)

    I love finding out that a project has a dependency on a task assigned to you - when everything else is done and ready to be deployed. Communication,...

    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, 2010 at 6:11 am

    #1252442

  • RE: Are the posted questions getting worse?

    Someone out for free consulting again?

    http://www.sqlservercentral.com/Forums/Topic1022788-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

    November 18, 2010 at 6:05 am

    #1252440

  • RE: DB mirroring

    Don't understand what you're asking. If you copy the data to another server you've just copied the data. The mirrored status of the one server is totally irrelevant to 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 18, 2010 at 6:00 am

    #1252435

  • RE: DTA Recommendations

    nigelrivett (11/18/2010)

    I think the tuning advisor is of little real value.

    Agreed. Test any recommendations carefully

    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, 2010 at 5:59 am

    #1252434

  • RE: dbcc in log shipping

    None.

    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, 2010 at 5:55 am

    #1252432

  • RE: Why does Select fails with Transaction Deadlock Error?

    DataDog (11/18/2010)

    two connections issuing "select [field] from where [otherfield] = blah"

    connection 1 - get lock on index A

    connection 2 - get lock on index B

    connection 1 - waits for...

    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, 2010 at 5:55 am

    #1252431

  • RE: Database model for villa renting systems?

    If you want some help building it, please show us what you have so far.

    If you want to hire someone to do it for you, what's your budget?

    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, 2010 at 5:52 am

    #1252429

  • RE: Use of temp table

    There's less logging for a temp table compared to a user table. Proof on my blog if you're interested.

    The data caching's much the same, but even if it were more,...

    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, 2010 at 4:23 am

    #1252382

  • RE: Why does Select fails with Transaction Deadlock Error?

    Profiler (deadlock graph event) or turn traceflag 1222 on and it will be written to the error log. Neither is historical. Hence why I asked if it was reproducible.

    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, 2010 at 4:13 am

    #1252376

  • RE: Why does Select fails with Transaction Deadlock Error?

    matsinopoulos (11/18/2010)

    However, what is your opinion about a Select failing with transaction deadlock error? What might be the possible roots of error?

    No idea. Would need to see the deadlock graph....

    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, 2010 at 3:54 am

    #1252371

Viewing 15 posts - 29,311 through 29,325 (of 49,552 total)