Forum Replies Created

Viewing 15 posts - 4,336 through 4,350 (of 9,244 total)

  • RE: SQL Installation on D drive

    this is because some components are loaded at boot time. Logically, the only drive that is absolutely online during boot is the C drive 😉

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

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

  • RE: Disks are becomming offline after creating the cluster

    Where are the shared disks being presented from?

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

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

  • RE: Error while validating the cluster in wondows server 2008 R2 Using local storage

    The validation wizard should skip any local disks, can you supply more info on the server setups?

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

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

  • RE: 250GB file size limit

    limit of 250GB? Not hosted on a virtual machine by any chance is it?

    Keep well clear of dynamic disks in windows they're only designed to be used in the absence...

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

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

  • RE: AlwaysOn Availability group using FCI

    Firstly, read my article at this link[/url] for more info on AO groups and FCI's

    SQLSACT (2/5/2013)


    My Question: Server1 and ServerB have Shared Storage, how do I prevent ServerC from seeing...

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

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

  • RE: SQL Server 2008 R2 shutdown / startup procedure

    can you post results of the following when run from a command prompt on one of the nodes

    cluster /quorum

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

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

  • RE: sqlio tool in sql server 2008

    Is there particular problem you are having with the SQLIO application?

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

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

  • RE: Fragmentation does not reduce for some tables

    Aside what Gail has said check the index id for the object. If its a heap then it will naturally contain some fragmentation.

    The page allocation marker is 8 pages, any...

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

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

  • RE: SQL Server taking 2 GB ram with out PAE

    adeel.imtiaz (1/28/2013)


    Dear Gurus,

    Can you please let me know why SQL server is taking more than 2 GB of RAM even PAE switch is not being added in boot.ini?

    Can post the...

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

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

  • RE: Multiple values in same column

    Presumably we're talking multiple time slots to multiple doctors?

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

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

  • RE: Mirroring failover

    SQLCrazyCertified (2/1/2013)


    DECLARE fixusers CURSOR

    FOR

    SELECT UserName = name FROM sysusers

    WHERE issqluser = 1 AND (sid IS NOT NULL AND sid <> 0x0)

    This first part declares a cursor checking sql server...

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

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

  • RE: place fulltext index into diffrent filegroup

    ratheesharc (2/1/2013)


    Thank you anthony.green,

    Fulltext index already created the in developing server and want to implement in production server with changing the filegroup.

    How do i change my full text file group.

    On...

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

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

  • RE: what is the need for placing mdf and ldf files in different drives

    Koen Verbeeck (2/1/2013)


    Also, if one of the disks crashes, you don't lose everything.

    That's not entirely true.

    If you have separate data and log drives and no backups and the data...

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

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

  • RE: like to install the failover cluster in pc

    You need to create virtual machines and set up a cluster from there. See my guide at these links

    Part1[/url]

    Part2[/url]

    Part3[/url]

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

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

  • RE: Setting log shipping in AlwaysOn environment

    LS does not provide a true read only standby whereas AO does, up to 4 of them in fact.

    If you're not convinced that AO replaces LS read the MS...

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

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

Viewing 15 posts - 4,336 through 4,350 (of 9,244 total)