Forum Replies Created

Viewing 15 posts - 28,261 through 28,275 (of 49,552 total)

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

    OceanDeep (1/21/2011)

    I agree that in this situation the optimzer is wrong on put the low selectvity in the key field of index.

    Maybe. Maybe not. There's nothing wrong with a low...

    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

    January 21, 2011 at 11:13 am

    #1276709

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

    Charles Kincaid (1/21/2011)

    It's the GUI tools (SSMS or Enterprise Manager) making the PK clustered is what has lead folks down the garden path.

    Not just the GUI tools, it's the default...

    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

    January 21, 2011 at 11:08 am

    #1276704

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

    Doug Bishop (1/21/2011)

    Obviously, a join on PK is the best solution. Unfortunately these tables are all heaps, with no PK.

    A table can be a heap and have a pk. It...

    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

    January 21, 2011 at 10:15 am

    #1276669

  • RE: SOP on transactional log, rollup, commit for SQL Server 2005 or 2008

    Rollup?

    Please read through this - Managing Transaction Logs[/url]

    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

    January 21, 2011 at 10:05 am

    #1276663

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

    http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

    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

    January 21, 2011 at 9:32 am

    #1276634

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

    OceanDeep (1/21/2011)

    The opinion is that in a query that consists of join and where clause. We should put the SGR in the where clause as the key field 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

    January 21, 2011 at 9:22 am

    #1276627

  • RE: Execution Plans - How long will they stay?

    I still don't understand why you're interested in that. An execution plan takes up the same amount of space whether it's used once or 10000 times.

    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

    January 21, 2011 at 9:11 am

    #1276622

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/21/2011)

    To be fair, it's possible that the BU or PM doesn't have any free time Monday morning.

    True. Possible. It just means that Monday morning will be a complete...

    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

    January 21, 2011 at 9:08 am

    #1276618

  • RE: Are the posted questions getting worse?

    WayneS (1/21/2011)

    So... did you decline the meeting request (that you initially requested, albeit for a different date/time) and reiterate Monday morning as the meeting date/time that would be acceptable, as...

    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

    January 21, 2011 at 6:45 am

    #1276513

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

    the sqlist (1/21/2011)

    "Include columns are useful in that they are columns available in the index but not contributing to the size of the index key"

    ...

    Included columns do affect the 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

    January 21, 2011 at 5:32 am

    #1276487

  • RE: Conecting to a 3rd table

    Is there something wrong with all the answers I gave you on the other thread you had on this problem? http://www.sqlservercentral.com/Forums/Topic1050944-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

    January 21, 2011 at 5:24 am

    #1276485

  • RE: SQL QUERY -- PLZZ HELP

    No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1051452-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

    January 21, 2011 at 5:22 am

    #1276484

  • RE: NEED HELP SQL QUERY

    Read this to see the best way to post this to get quick responses. http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Please don't start multiple threads for the same question in future. 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

    January 21, 2011 at 5:21 am

    #1276483

  • RE: Installing Analysis and Integration services On Virtual server

    No further replies to this thread please, there are already 2 open with this question. Replies to the thread Lutz linked 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

    January 21, 2011 at 5:19 am

    #1276482

  • RE: Installing Analysis and Integration services On Virtual server

    The answer doesn't change. The question is not 'can we put it on a virtual', the question is 'does the server (virtual or bare metal) have enough resources'

    These days, 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

    January 21, 2011 at 5:18 am

    #1276480

Viewing 15 posts - 28,261 through 28,275 (of 49,552 total)