Forum Replies Created

Viewing 12 posts - 16 through 27 (of 27 total)

  • RE: Transaction replication on a peer to peer replicated Database

    Hi

    It sounds like you're trying to install a second version of replication. You don't want to completely install and configure replication on server A again as replication is already running...

  • RE: SELECT TOP

    donvon40 (12/21/2010)


    Adding a clustered index is equivalent to adding a primary key and doesn't determine order. I don't agree with this answer.

    Categorically untrue. A primary key is a unique logical...

  • RE: Clustered Index Internals

    Rich-403221 (12/9/2009)


    Also, the doubly linked list would imply that there are pointers on every page to the previous and next pages in the table. I have NEVER read anywhere in...

  • RE: It's Time for Encryption

    I think TDE is of limited use in reality. It protects backups on tape but no need to encrypt an entire production database on an enterprise web application to achieve...

  • RE: B-tree

    I disagree. This is not a matter of the writers opinion. This is a SQLServer site and the question relates to SQLServer, not generic databases and structures. BOL clearly states...

  • RE: Implementing Change Data Capture in Microsoft® SQL Server 2008

    And what is up with not being able to reindex a CDC-enabled table?

    I'm a bit puzzled by this. I have CDC enabled tables and I can both rebuild and reorganise...

  • RE: Implementing Change Data Capture in Microsoft® SQL Server 2008

    I haven't had the chance to test out CDC yet so my comments do not in any way address reliability, particularly as Kate points out, with MS's past track record....

  • RE: MatrixDB

    Isn't this basically what Oracle RAC is. You have many instances of Oracle running on individualy boxes, all accessing the single shared data source. They pass a token about to...

  • RE: High Availability (DR) Using SQL Server 2005 Transactional Replication

    Coming from a Sybase background we always initialise using backups of the primary, never on a table by table basis. I'm surprised so few people know of, or use this...

  • RE: Sun Invests, IBM Invests, MS ??

    I think you miss my point. I'm not suggesting that MS should or will consider a unix port. I'm making the point about what may have been had MS &...

  • RE: Sun Invests, IBM Invests, MS ??

    I have to be honest and say I was not aware exactly how the restrictions have changed over the years, and I'm sure you're quite right on this. At least...

  • RE: Sun Invests, IBM Invests, MS ??

    One missing point on the acquisition front. Microsoft did not actually design and build SQLServer, Sybase did. MS "acquired" it in a round about sort of a way. True, they...

Viewing 12 posts - 16 through 27 (of 27 total)