Forum Replies Created

Viewing 15 posts - 5,956 through 5,970 (of 9,241 total)

  • RE: Change Service Account - Impact on Mirroring

    SQLback (2/22/2012)


    It worked. Thanks for the advice.

    You're welcome

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: 3 node clustering in sql server 2008 R2

    Sapen (2/21/2012)


    I was wondering how the cluster would appear in my scenario (behavior of passive node(Node C)). On one active node(Node A) I want to have instance1 and on the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: an i use same instance on single server for Primary & Secondary database for Log shipping

    kumar.sachu08 (2/21/2012)


    Hi,

    I would like to know....Can i use same instance on single server for Primary & Secondary database for Log shipping.

    I have only one server and one instance.

    Regards,

    Sachin.

    No you cannot,...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Cause of High Mirror Commit Overhead

    have you verified connectivity\latency between the instances

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

    Completely understand, but in my experience pointing out their flawed maint plan and correcting it should serve to gain you a little kudos and maybe even an extension to your...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Are you using heartbeat in SQL 2008 R2 clusters

    Quite agree, as I said I did not design\deploy the current cluster I work with, if I had I would not have used dedicated heartbeat NICs 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

    WRACK (2/20/2012)


    Perry Whittle (2/20/2012)Wow, you do like to make your server work for a living don't you 😉

    I am not a DBA for this company, just a temp assignment for...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Upgrading a SQL Server 2005 Clustered Environment to SQL Server 2008 R2

    oradbguru (2/20/2012)


    Has anyone out there upgraded a SS 2005 clustered environment to 2008 R2. Looking for tips and whatever input you may have based on your experiences. I...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

    GilaMonster (2/20/2012)


    My point still stands, if SQL is on a non-dedicated server, then setting a sensible max server memory is almost essential

    Agreed, that and removing wacko maintenance plans 😀

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

    WRACK (2/19/2012)


    Perry Whittle (2/19/2012)


    WRACK (2/19/2012)


    but it does a lot more than just Reindexing.

    Exactly what does it do?

    * Sets some database to Simple Recovery Model

    * Sets AUTO UPDATE STATISTICS on some...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

    WRACK (2/19/2012)


    but it does a lot more than just Reindexing.

    Exactly what does it do?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: how to fix the orphaned users problem

    gantavasu (2/18/2012)


    Sorry not like that i have moved the database from one server to another server here i am getting this problem. and also i don't have the exact idea...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Are you using heartbeat in SQL 2008 R2 clusters

    I've voted yes because the existing SQL Server 2008 R2 cluster in my current assignment is using dedicated heartbeat NICs.

    However, If i were designing and deploying the Windows\SQL 2008...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Convert minutes to HH:MM:SS format

    pwalter83 (2/15/2012)


    GilaMonster (2/15/2012)


    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1252335-391-1.aspx

    This is not a duplicate post....its an altogether different query. Read the post Properly first before writing any...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL 2008 R2 Standard licensing for virtual environments

    Banks1850 (2/18/2012)


    so in the end, the answer is, you cannot use host migration with SQL standard UNLESS you have the physical hosts licensed with Enterprise or DC and have room...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 5,956 through 5,970 (of 9,241 total)