Forum Replies Created

Viewing 15 posts - 436 through 450 (of 758 total)

  • RE: Index Design

    GilaMonster (8/24/2012)

    Have you read those three indexing articles yet? If not, please read them, especially the third one.

    Thanks Gail

    Got what I needed from those articles

    August 29, 2012 at 7:55 am

    #1531404

  • RE: Uninstallation sql cluster error

    bala2 (8/29/2012)

    Thanks for reply,

    I have installed Sql server 2005 and

    i could not find this option "Remove Node from a SQL Server Failover Cluster" Using the SQL Installation media.

    Check...

    August 29, 2012 at 6:49 am

    #1531359

  • RE: Uninstallation sql cluster error

    bala2 (8/29/2012)

    Hi,

    I have uninstalled sql server 2005 from Add/Remove Programs using Win 2003 server.

    i have verified SQL Server 2005 is no longer listed in the Add/Remove Program but I...

    August 29, 2012 at 5:58 am

    #1531320

  • RE: Orphaned Users

    Divine Flame (8/29/2012)

    SQLSACT (8/29/2012)

    How do I create the Logins with the same SID?

    Is there a process for this?

    Thanks

    Use sp_help_revlogin stored procedure provided by Microsoft at below link to generate the...

    August 29, 2012 at 2:08 am

    #1531254

  • RE: Orphaned Users

    SQLSACT (8/29/2012)

    Suresh B. (8/29/2012)

    SQLSACT (8/29/2012)

    My question is: Will I definately end up with orphaned users whenever I restore a database to another server?

    No. Not necessarily. Orphaned users situation...

    August 29, 2012 at 1:56 am

    #1531248

  • RE: Orphaned Users

    Suresh B. (8/29/2012)

    SQLSACT (8/29/2012)

    My question is: Will I definately end up with orphaned users whenever I restore a database to another server?

    No. Not necessarily. Orphaned users situation araises...

    August 29, 2012 at 1:55 am

    #1531247

  • RE: Index Design

    GilaMonster (8/24/2012)

    Yes, it's used to find the data row.

    Thanks

    I wanna run something by you that might be out of the scope of this thread, please just let me know.

    I came...

    August 24, 2012 at 5:29 am

    #1529662

  • RE: Index Design

    GilaMonster (8/24/2012)

    Yes, it's used to find the data row.

    Thanks Gail

    August 24, 2012 at 5:00 am

    #1529658

  • RE: Index Design

    GilaMonster (8/24/2012)

    Data row = that which is found in a table (heap or clustered index)

    Index row = that which is found in nonclustered indexes.

    There are some differences in their details,...

    August 24, 2012 at 4:48 am

    #1529652

  • RE: Index Design

    GilaMonster (8/24/2012)

    No, what would it need to go to the base table for?

    The only column you're referencing in your query in Col3, and that's in the index row at the...

    August 24, 2012 at 4:32 am

    #1529644

  • RE: Index Design

    GilaMonster (8/24/2012)

    If the index satisfies the query completely, why would SQL need to go to the base table?

    Please read the articles I referenced.

    I'm confused about your first reply

    Also, indexes (nonclustered)...

    August 24, 2012 at 4:19 am

    #1529635

  • RE: Index Design

    GilaMonster (8/24/2012)

    SQLSACT (8/24/2012)

    Am I missing anything here?

    Mainly that the pointer to the rest of the row is the clustered index key (if the base table is a clustered index). Not...

    August 24, 2012 at 4:04 am

    #1529630

  • RE: Primary\Foreign Key

    SQL Kiwi (8/22/2012)

    SQLSACT (8/22/2012)

    So if the Primary Key has 2 columns defined, my foreign key needs to have the same 2 Columns defined?

    Yes. The point is that each child...

    August 22, 2012 at 5:26 am

    #1528558

  • RE: Primary\Foreign Key

    SQL Kiwi (8/22/2012)

    Col1 needs to have a PRIMARY KEY, UNIQUE constraint, or (less acceptably) a UNIQUE index defined on it. Something needs to enforce uniqueness on col1 alone. ...

    August 22, 2012 at 5:21 am

    #1528554

  • RE: SQL Plan Cache

    GilaMonster (8/17/2012)

    Taking a couple steps back... This whole thing is only valid for very, very, very simple queries that qualify for autoparameterisation. Emphasis 'very simple'. It is not at all...

    August 17, 2012 at 3:22 am

    #1526974

Viewing 15 posts - 436 through 450 (of 758 total)