Forum Replies Created

Viewing 15 posts - 3,091 through 3,105 (of 9,244 total)

  • RE: SQL Encryption - Create Certificate

    swoozie (8/8/2014)

    I feel like this is aother silly question, however I am not finding the answer that makes sense to me.

    I would like to understand the difference between using the...

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

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

    August 8, 2014 at 9:45 am

    #1736472

  • RE: How to Create a Corrupt SQL Server Database

    roberto.regidor (8/8/2014)

    Funny, I had understood that if a nonclustered index is corrupt, you don´t need the option REPAIR_ALLOW_DATA_LOSS

    That is correct

    roberto.regidor (8/8/2014)

    that is shown in the image

    which image are you referring...

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

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

    August 8, 2014 at 9:03 am

    #1736453

  • RE: SQL Server Clustering vLANs

    DBA From The Cold (8/8/2014)

    Hi Perry,

    Thank you for the quick response.

    So having the cluster VIP on the Production vLAN would probably be the best way forward? I can put it...

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

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

    August 8, 2014 at 7:52 am

    #1736418

  • RE: SQL Server Clustering vLANs

    DBA From The Cold (8/8/2014)

    Hello,

    I'm setting a new SQL Server 2012 two node cluster and have a quick question about the virtual IPs of for both the cluster and SQL...

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

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

    August 8, 2014 at 7:06 am

    #1736393

  • RE: questions regarding config_value for affinity mask

    you're welcome

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

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

    August 8, 2014 at 4:37 am

    #1736363

  • RE: questions regarding config_value for affinity mask

    sp_configure is showing the raw bitmap value based on the CPU numbers, they are as follows

    exec sp_configure 'affinity mask'

    CPU number 7 ...

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

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

    August 8, 2014 at 4:26 am

    #1736359

  • RE: Always ON SQL Server 2012

    Firstly, have a look at this.

    http://msdn.microsoft.com/en-gb/library/ff878716.aspx

    Libby1981 (8/7/2014)

    Hello:The question I have is about the third node that I plan on adding to this cluster.

    The third node dbprod1c will be...

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

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

    August 8, 2014 at 4:02 am

    #1736349

  • RE: How to Create a Corrupt SQL Server Database

    This hasn't worked successfully for you, work through the guide again on a new database

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

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

    August 8, 2014 at 1:28 am

    #1736314

  • RE: Running multiple TDE encryptions at once...

    OK as long as you're aware

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

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

    August 8, 2014 at 12:09 am

    #1736292

  • RE: Running multiple TDE encryptions at once...

    Just be aware of the overhead for CPU

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

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

    August 7, 2014 at 2:43 pm

    #1736201

  • RE: Running multiple TDE encryptions at once...

    why on earth would you want to blanket deploy TDE???

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

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

    August 7, 2014 at 7:07 am

    #1735950

  • RE: VLFs on AlwaysOn primary replica after log backup from secondary

    friedrichsenm (8/6/2014)

    I was working on a job to send me info each morning about database file free space and was noticing some odd things when looking at the log file...

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

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

    August 7, 2014 at 3:09 am

    #1735887

  • RE: clustering Vs Mirroing Vs Logshipingf Vs replication

    vkundar (8/6/2014)

    To provide more context, on the HA setup we are looking we have two DC one we are planing to be HA and oter will be DR.

    I have to...

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

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

    August 7, 2014 at 3:02 am

    #1735884

  • RE: Failing over a SQL Cluster Instance

    If you plan a failover, always stop your application services first. Why intentionally rip the database from under the app when you could have a clean shutdown and startup. The...

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

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

    August 7, 2014 at 2:58 am

    #1735881

  • RE: question on cluster private and public network

    You're welcome

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

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

    August 6, 2014 at 3:10 pm

    #1735793

Viewing 15 posts - 3,091 through 3,105 (of 9,244 total)