Forum Replies Created

Viewing 15 posts - 9,046 through 9,060 (of 9,241 total)

  • RE: Issues with 400TB Database

    Michael Valentine Jones (8/5/2008)


    Are you really sure about the size of this database? Maybe it is really 400 GB?

    400 TB would make it one of the world’s largest databases...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: SQL 2005 Enterprise Edition x64 SP2

    Lee Hart (8/5/2008)


    forgetting for a moment that SQL server Enterprise edition uses more than the standard install...

    both SQL 2005 Std and Ent address RAM up to the OS limit.

    Lee Hart...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Move System Databases

    just ensure that MSSQLSYTEMRESOURCE and DIST are in the same location as your MASTER database and all should be well

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: BACKUP LOG WITH TRUNCATE_ONLY

    begs the question,

    if you're implementing log shipping, why are you truncating the log?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Wrong TempDB path

    sounds like these guys had the problem as you, give it a shot

    http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=2968469&SiteID=1

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: 2000 to 2005: Upgrade or Migrate ?

    i was involved in an upgrade from a sql2000 instnce to a sql2005 instance early last year. The point raised was how do we get the databases onto the new...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Multiple File Groups

    as stated in your case no.

    if you were SAN based for instance for your VM storage then you could use different LUNs.

    With regards to licensing if you licence your host...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Fill Factor for performance

    are you experiencing page splits on your server?

    SQL server default is 0 which means the same as 100% (you can alos specify when rebuilding an index which overrides the default),...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: MDF?? LDF??

    you wouldbe best to set the default paths after installation.Its a lot easier or use custom scripts to set the paths

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: How to configure new server

    New_to_being_DBA (7/31/2008)


    This is one proposed plan: D: drive RAID 5 (780GB), for databases for all sites; on the other controller, E:drive RAID 1 (146) for transaction log, F:drive RAID 1...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: DBCC opentran

    what are you expecting to see?

    what is the reason for executing dbcc opentran?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Disk 'layout' question

    the 2 HBA's should be multi homed so that in the case of an HBA failure you dont lose any of your data drives.

    In the options you are quoting loss...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: How to know a server have dual/quad core?

    Gordon (7/30/2008)


    Perry, can you elaborate a bit more on which part of the CIMV2 you used?

    WIN32_Processor, as i pointed out previously this class returns an instance for each core that...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: How to disable windows authentication on sql server

    from server config point of view you only have the options of

    mixed mode

    windows

    From the logins point of view you could remove builtin\administrators and any other windows groups\users, etc and this...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: How to know a server have dual/quad core?

    its easier to get the server tag id and check the manufacturers website LOL

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

Viewing 15 posts - 9,046 through 9,060 (of 9,241 total)