Forum Replies Created

Viewing 15 posts - 8,521 through 8,535 (of 9,244 total)

  • RE: SQL 2005 and GIS server

    SQL_Quest

    what version of ArcGIS are you using?

    The spatial layers are part of the ArcSDE engine. You can use direct connect to connect to the database from the SDE engine...

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

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

  • RE: Need Uninstall Option for Service Packs

    most updates affect the system databases, i dont think an un install would not be a viable option, although nice too have. An un install would have to tie in...

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

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

  • RE: SQL Server, SANs and Virtualisation

    colin Leversuch-Roberts (1/12/2009)


    see what a hornets nest this stirs up.

    you're not wrong there sir. A great thread going on here!

    who will win the speed war copper or fibre...

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

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

  • RE: SQL Server, SANs and Virtualisation

    its worth noting if you licence the cpus for Enterprise edition of SQL server at the host level, it will cover you for unlimited sql server cpu licences on any...

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

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

  • RE: Best method to migrate to new DB server

    unless your using Redgate or Litespeed, you have have to backup the database which can take a while depending on the size. You then have to copy that file across...

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

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

  • RE: Best method to migrate to new DB server

    i would detach then re attach. Backup and restore remember that if you backup the database and restore, if any transactions get made against the old database then you'll need...

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

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

  • RE: SQL Server, SANs and Virtualisation

    homebrew01 (1/10/2009)


    Perry Whittle (1/10/2009)


    homebrew01 (1/10/2009)


    Our plan is to take our 2 heaviest hit SQL servers and put them onto their own physical machines running VM. They will have the VM...

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

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

  • RE: SQL Server, SANs and Virtualisation

    homebrew01 (1/10/2009)


    Our plan is to take our 2 heaviest hit SQL servers and put them onto their own physical machines running VM. They will have the VM overhead, but not...

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

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

  • RE: RAID 1 vs. RAID 10

    colin Leversuch-Roberts (1/9/2009)


    On one san I have aligned partitions with 64kb block size, 128kb stripe, raid 10 dedicated spindles; I also have some 4kb block size non aligned partitions also...

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

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

  • RE: Create database using Backup file

    click in the combo box and type a new database name 😉

    if you right click at the "databases" node of the tree view the combo box should be empty when...

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

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

  • RE: SQL Server, SANs and Virtualisation

    SQLBOT (1/8/2009)


    Virtualization creates a safe sandbox environment for sa, but does add the overhead of providing a memory and disk space for the OS.

    the only caveat here is unless the...

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

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

  • RE: SQL Server, SANs and Virtualisation

    John

    cant find the link at present, it detailed the NTFS cluster size and disk alignment within the windows OS. MS indicated that changing default cluster sizes,etc didnt necessarily boost performance.

    I've...

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

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

  • RE: SQL Server, SANs and Virtualisation

    Wow, some great responses here. Did I open a can of worms? I appreciate all the feedback both negative and positive. This was only ever meant to be a "quick...

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

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

  • RE: Cumulative update 10 for sql server 2005 EE x64

    option 2 should include the client

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

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

  • RE: Transaction Log file size running away

    ALZDBA (1/7/2009)


    Still the log data is needed in case sqlserver crashes of in case of power failure of the server only to be able to restore the database into a...

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

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

Viewing 15 posts - 8,521 through 8,535 (of 9,244 total)