Forum Replies Created

Viewing 15 posts - 1 through 15 (of 93 total)

  • RE: AWE in a mixed memory cluster

    Your problems will arise if your SQL Server is in a running state where it will consume the 8Gb of memory on that node and then that node fails! This will...

  • RE: Closing on One Year

    We've actually hit a bit of a blocker on the upgrade to SQL2k5 due to some replication features being deprecated (alternate Sync Partners), and no reasonable alternative being offered by...

  • RE: Merge Replication + Log Shiiping at the Subscriber

    u just HAD to confirm it for me, didnt u!?

    Ah well ... if there was an easy(er) answer i'd have figured it out...

  • RE: Merge Replication + Log Shiiping at the Subscriber

    I think it's the failure scenario ur not understanding and that is ALL has to be merge replicating. As i mentionioned, worse case scenrio is the WAN link to the...

  • RE: Merge Replication + Log Shiiping at the Subscriber

    Track2 would need to have a Merge Relationship also with Track1 (then also alternate sync partners) ... i didn't think this was allowed!??

    ie Factory1 ---Merge Repl ---> Track1 ---Merge Repl...

  • RE: Removing BUILTIN/Administrator Login

    "Be sure you know the sa of have given explicit rights to a windowsaccount you know the password of  that is sqlserver sysadmin, before you revoke builtinadmin !"

    So, not just...

  • RE: Removing BUILTIN/Administrator Login

    just as a general note from the first posting, you dont need to have built-in\admins on the SQL Server when clustering! As long as you put the Cluster and SQL...

  • RE: Installing Virtual Server

    Only ever had the "failed on node 2" scenario once ... and i've done quite a few clusters over the years. The site in question did (does!) have some network...

  • RE: Installing Virtual Server

    uurrrmmm ... Yeah! Not putting the Cluster and SQL Service accounts in the Local Admins WILL have some minor issues!?

    I'd be a little...

  • RE: Cluster SQL With Database stored on the local Drive

    BTW ... dont use a Blade Center for a cluster. We ran into some significant issues when attempting this ... and then got free(ish) hardware from OUR IBM suppliers cos...

  • RE: SQL Server on a Virtual Server

    did we honestly need to go to the nth level on the context and definition of what a virtual server is! We all knew that he meant he had VMWare...

  • RE: creating file groups for the existing database

    Right click on the database in EM and select "Properties" ... then goto the filegroups tab! U can add new filegroups and set the default in there! From there, u...

  • RE: SQL Server on a Virtual Server

    The only time i've ever heard of virtual server being used in conjunction with SQL server is to emulate a Cluster ... There's nothing inherently wrong with it (apart from...

  • RE: File groups, Merge Repl and ANSI_NULL Setting

    bumping my own posts now!? lol

    Anyway, i posted this just before i was on holiday ... so ask again, has anyone run into this before??

    Cheers

    Vinny

  • RE: My database keeps messing up

    BOL says this (see "composite index") :

    "Covered queries can improve performance. Covered queries are queries where all the columns specified in the query are contained within the same index."

    The example...

Viewing 15 posts - 1 through 15 (of 93 total)