Forum Replies Created

Viewing 15 posts - 5,596 through 5,610 (of 9,244 total)

  • RE: RAID and Its impact on your SQL performance

    GregoryAJackson (5/4/2012)


    Typically the RAID Controller will have an administrative software application or control panel.

    Ultimately it's the BIOS on the RAID controller that handles the array(s), for vendor specific you may...

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

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

  • RE: How to find Disk Alignment and file allocation of a NAS share

    Partly because of the potential for a non NTFS file system, partly because it isn't the Windows box concern. Mostly because the remote file share is an entity outside of...

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

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

  • RE: How to find Disk Alignment and file allocation of a NAS share

    n00bDBA (5/4/2012)


    Hi all,

    Just got a NAS share for SQL backups and i wanted to look at the file allocation and disk alignment for it. Doing the normal command lines...

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

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

  • RE: How to Create a Corrupt SQL Server Database

    dioscoredes (5/4/2012)


    Really enjoyed the article. Thanks. Great demo for my advanced training labs. Have done this in Oracle several times and is interesting to see how SQL server pages map...

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

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

  • RE: How to Create a Corrupt SQL Server Database

    Hi Michael, as the article mentions it's ideal for testing DBCC scripts against and also for practising dealing with a corrupt database.

    It also gives you an idea of what the...

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

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

  • RE: cluster exe remove preferred owners

    bangsql (5/2/2012)


    I used following cmd prompt to set preferred owners

    cluster group "Test" /SetOwners:Machine001

    However what is the command to remove preferred owners

    the below link not suggest anything

    http://technet.microsoft.com/en-us/library/cc723245.aspx

    The command I believe you...

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

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

  • RE: Backup and save a copy on a server on a different domain

    You're welcome

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

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

  • RE: Clustering Services

    How many cluster nodes?

    What quorum type?

    Are you required to shut down the clustered SQL server instance or the cluster node(s)?

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

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

  • RE: Clustering Services

    Whisper9999 (4/30/2012)


    Okay, I'm confused. Let's say someone tells me to shut down "clustering services" on an active/active 2005 cluster. Where do I find it and how do I...

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

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

  • RE: upgrade path to sql server 2012 entreprise

    zetchi (5/1/2012)


    is there anything special to do or to install before installing sp1 ?

    thank you

    apart from the obvious, check you have backups before starting, no. Install the service pack and...

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

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

  • RE: Backups and log shipping

    dixon_dwayne (4/30/2012)


    Question is: after initial full backup on prod box and all the transaction logs created on prod box, do I need to keep them or can they be...

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

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

  • RE: upgrade path to sql server 2012 entreprise

    check this link on the Microsoft website

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

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

  • RE: RAID and Its impact on your SQL performance

    derek.colley (5/1/2012)


    Would have been nice to explore the topic of 1) virtualisation and 2) SANs and how the IOPS rates differ when using these different technologies. Any more articles...

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

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

  • RE: RAID and Its impact on your SQL performance

    Nice article, incidentally RAID 1+0 and 0+1 are not identical. As 0+1 is essentially 2 stripes the loss of 1 disk in each portion of the array is catastrophic. 1+0...

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

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

  • RE: Prerequisites for clustering

    mohan.bndr (4/29/2012)


    Hi,

    Can i know what are the prerequisites for Cluster Environment please....

    Thanks,

    Windows Server 2008 Enterprise or above.

    Sufficient shared storage solution.

    Identical node hardware

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

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

Viewing 15 posts - 5,596 through 5,610 (of 9,244 total)