Forum Replies Created

Viewing 15 posts - 6,541 through 6,555 (of 9,244 total)

  • RE: DBCC shrink file

    Ninja's_RGR'us (9/26/2011)


    Is that your prefference for ssrs server over replication??

    why is replication yours then 😉

    For most users log shipping provides excellent report offloading. I dont understand your point about the...

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

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

  • RE: DBCC shrink file

    Have you thought of implementing Log Shipping?

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

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

  • RE: Rebuild index -Timeout error

    mirjawad_2k (9/26/2011)


    I received the below error while rebuilding indexes on the large table . Do you have any info about these errors

    The server is a 64bit OS and has 32Gb...

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

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

  • RE: Sql Server 2008 Enterprise Evaluation Edition Expired!!

    p.van.der.zande (9/26/2011)


    how to solve it?

    Put the DVD disc into the drive, run the setup and upgrade the existing instance. Ensure you have backups first.

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

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

  • RE: Restore DB from SQL 2005 to SQL 2008

    Dan-Ketil Jakobsen (9/26/2011)


    and 1 TB for log.

    wow!

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

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

  • RE: Two Node Cluster Performance Improvement over single server ?

    isuckatsql (9/26/2011)


    What type of performance improvement could i expect from a two node cluster, running sql server 2008 r2 x64 enterprise, over just a single server.

    As Gail said, absolutely none....

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

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

  • RE: SQL Server 2008 R2 SP1 Installation - The cluster disk device name is not valid

    Is this a Windows cluster or a Veritas Cluster Server?

    Are you saying that you saved the SP executable to the C drive and ran it from there?

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

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

  • RE: SS08 SP2 w/ Compression - effectiveness varying wildly on a single table

    can you post the table definition

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

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

  • RE: Adding a node to Cluster - "No mapping between account names and security IDs was done."

    Dr Pliers (9/26/2011)


    How do I change the AD Group that I specified as part of the cluster security policy?

    so you used legacy group security and not Service SID based security?

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

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

  • RE: SQL Server 2008 R2 SP1 Installation - The cluster disk device name is not valid

    Try unpacking the SP to the local C drive and then execute the Setup from there

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

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

  • RE: A time-out occurred while waiting for buffer latch

    so now detail the other drives

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

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

  • RE: SQLServer becoming unresponsive

    what other software runs on this server?

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

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

  • RE: A time-out occurred while waiting for buffer latch

    Ok so can you supply more information regarding the d drive set up and file information for database id 5 as that is what the error is complaining about

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

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

  • RE: Migrating from one db to other

    Generally your vendor should be able to provide the mappings between the legacy database schema and the new database schema.

    IMHO, If they can't then one has to wonder what their...

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

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

  • RE: A time-out occurred while waiting for buffer latch

    could you please also return the results of the following query

    SELECTNAME

    , PHYSICAL_NAME

    , (size * 8) / 1024 as SizeInMBs

    , CASE max_size

    WHEN -1 THEN 'Unrestricted'

    WHEN 0 THEN 'NoGrowth'

    WHEN 268435456 THEN '2TBS'

    END...

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

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

Viewing 15 posts - 6,541 through 6,555 (of 9,244 total)