Forum Replies Created

Viewing 15 posts - 8,176 through 8,190 (of 9,241 total)

  • RE: how to configure sql server memory

    what errors particularly. Can you post some samples

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

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

  • RE: I have two instances of SQL Server 2005 version 9.00.3042 on a windows 2003 Enterprise Edition server service pack 1

    Lyn

    its not a good idea to hijack another thread best to start your own. That aside can you post details of the setup log as Santosh has done Some idea...

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

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

  • RE: I have two instances of SQL Server 2005 version 9.00.3042 on a windows 2003 Enterprise Edition server service pack 1

    santosh_chandel (10/2/2008)


    **********************************************************************************

    Products Disqualified & Reason

    Product ...

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

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

  • RE: Cannot Reinstall SQL Server 2005

    try manually installing the SQL native client and .NET 2 framework first

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

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

  • RE: Page life expectency & Memory

    yeah, in my experience McAfee software has some nasty memory leak issues. Get your AV version and go to the McAfee site and check for any fixes. Also stop the...

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

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

  • RE: Changing locaton of data and logs for the database and server

    Krav

    seriously, if you are not comfortable moving files at the OS level you should leave well alone and seek extra help first. Beware also, that whatever path and filename you...

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

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

  • RE: Page life expectency & Memory

    what antivirus software do you have installed?

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

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

  • RE: SQL Server Management Studio 2005 Crashes

    do you have any info about the machine the client is installed on?

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

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

  • RE: Page life expectency & Memory

    antivirus client installed scanning the SQL server folders by any chance?

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

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

  • RE: new 64-bit Sql 2005 Server - integrity check completes then memory spikes 75% and doesnt lower

    the Technet article is incorrect (it wouldnt be the first time would it 😉 )

    see the following Microsoft KB

    http://support.microsoft.com/kb/918483

    i always use lock pages on 64 bit systems, its even more...

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

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

  • RE: Page life expectency & Memory

    i would set the lock pages in memory policy for the sql server service accounts and configure the min and max memory setting values

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

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

  • RE: awe on 64 bit

    on 64 bit sql server systems you only need to apply the lock pages in memory policy to the sql server service account, dont touch the AWE check box it...

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

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

  • RE: Changing locaton of data and logs for the database and server

    Krasavita

    use the following to generate a modify file command for each database

    declare @sql nvarchar(max)

    set @sql = ''

    select 'alter database [' +db.name + '] modify file (name = ' + al.name...

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

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

  • RE: Can multiple instances run on default port?

    i remember playing around with this before, being nosey. If you stack multiple IP's on the NIC and in SQL Server config manager you basically stop each instance from listening...

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

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

  • RE: Windows Authentication - Different domain

    these are separate domains in separate forests is that correct?

    also clarify the group scopes you have used.

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

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

Viewing 15 posts - 8,176 through 8,190 (of 9,241 total)