Forum Replies Created

Viewing 15 posts - 9,031 through 9,045 (of 9,244 total)

  • RE: Warning yellow sign when I open my SSMS :crying:

    go into Add\remove programs and select the .NET 2 framework. Run a repair of this first (click change\remove and it will ask to repair or remove)

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

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

  • RE: Advantages to have mutiple data files

    as mentioned the primary reason for filegroups is to spread the database across multiple disks\arrays to increase performance. Placing filegroups on the same array is really pointless

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

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

  • RE: SYstem Upgrade

    just out of interest why are you upgrading Windows 2003 std to 2003 Enterprise in the first place. I always prefer a clean install for NOS's

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

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

  • RE: SQL Server Consolidation

    presumably you have the ESX server installed\configured\secured and hooked up to the SAN?

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

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

  • RE: clustered sql servers with virtual machines - Good or Bad!

    Jeremy Brown (8/8/2008)


    And oh what an awesome thing VMWare HA is...

    sort of makes MSCS redundant really doesnt it

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

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

  • RE: clustered sql servers with virtual machines - Good or Bad!

    Ybol

    the first question has to be

    What virtualisation platform do you intend to use?

    It is not uncommon to have a physical node (active) and a virtual node (passive).

    If using something...

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

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

  • RE: SQL Server Consolidation

    are you planning physical or virtual machines

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

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

  • RE: Running SQLCMD from SQL Server

    what does the input file contain

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

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

  • RE: Upgrade Question

    jim.powers (8/6/2008)


    although our Network Admin would prefer Hyper-V.

    why? what is their reason for choosing this over ESX?

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

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

  • RE: How did you learn SQL

    rbarryyoung (7/30/2008)


    I know I often say that when someone asks me for advice on learning SQL Server.

    😛

    i would have thought judging by your avatar you would say

    "i find your...

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

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

  • RE: How to create new instance in sql server 2005

    once the instance is installed you register it by using

    servername\instancename

    so if you created an instance call "Instance1" on SQL server "London" then register using

    London1\Instance1

    To register a default instance you...

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

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

  • RE: Upgrade Question

    we have around 8 SQL VM's all running fine. Our storage is SAN based which helps. Which virtualisation platform do you intend to use?

    I would go clean install for SQL2005...

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

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

  • RE: Upgrade Question

    we have around 8 SQL VM's all running fine. Our storage is SAN based which helps. Which virtualisation platform do you intend to use?

    I would go clean install for SQL2005...

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

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

  • RE: Slow with the in function

    Tom Brown (8/5/2008)


    Your NOT IN clause would mean checking against every single value to make sure there is no match.

    Check the execution plan for the query, then try

    AND NOT...

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

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

  • RE: "Element Not Found" when trying to save a maintenance plan

    Allison Stresing (8/5/2008)


    I just installed Office 2007 and now I am having this same problem. Has anyone found a fix yet?

    When trying to save a maintenance plan on my...

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

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

Viewing 15 posts - 9,031 through 9,045 (of 9,244 total)