Forum Replies Created

Viewing 15 posts - 9,181 through 9,195 (of 9,244 total)

  • RE: Regarding database file shrinking

    GilaMonster (7/14/2008)


    I know. That's why I wrote the blog post in the first place, so I didn't have to keep on explaining why shrinking is bad.

    😉

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

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

  • RE: SQL Server Errors

    ungmax

    it would be helpful for everyone including yourself if you didnt hijack someone else's thread. Best to start your own you probably get more response that way

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

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

  • RE: Cannot disable NTgroup users using Alter Logins script

    double check spelling of domain\username

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

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

  • RE: SQL Server 2005 Express - can't connect over network

    do you have a firewall enabled?

    if so check the firewall log

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

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

  • RE: SQLServer 2005 on VMWARE

    ALZDBA (6/16/2008)


    Another downside of virtualisation is cpu licensing:

    If you license an instance on a physical server, you license per cpu socket.

    With virtual servers, you license per available cpu (i.e. cpu-core...

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

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

  • RE: how to overcome sql injection

    some brilliant links and advice there, way to go guys 😀

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

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

  • RE: Regarding database file shrinking

    this shrinking malarky has been done to death all over the forum:D

    good job cos i learnt something new 😉

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

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

  • RE: SQL server 2005 hardware configuration

    from memory, (forgive the pun) Windows 2003 server Enterprise shouldnt need a /PAE switch.

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

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

  • RE: failed login attemps as sa from multiple ips

    GilaMonster (7/14/2008)


    ltoso (7/11/2008)


    There should be a firewall. A web-facng server without a firewall is just asking for various forms of trouble.

    that's the thing that worried me, how can public ip's...

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

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

  • RE: SQL Configuration Manager Problem

    check this link

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1721211&SiteID=1

    it may be of some use

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

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

  • RE: create trigger on all tables for insert,update,delete

    are you sure you wanteed to audit all tables, that is quite an overhead to place on the database.

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

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

  • RE: My client just sent me a SQL Server Express 2005 file?!

    installing sql2005 express should be no more than if you were installing another sql2000 instance.

    Install a named instance and then remove it when you're done if you want to

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

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

  • RE: Using Profiler Measurements

    TRACEY (7/12/2008)


    How did you get 129

    i'm assuming he got it from here

    TRACEY (7/12/2008)


    When using profiler. Example

    Trying to determine what the measurements are in profiler in MG and GIG

    Divide by...

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

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

  • RE: Moving the Data from the Old Storage to New Storage SAN

    Mani Singh (7/12/2008)


    you need to ensure that the folder structure and the drive letter are kept the same.

    especially the folder permissions, that applies to SQL whether clustered or not

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

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

  • RE: Is there any difference between Truncate and Shrinking of the Log file?

    DKG (7/12/2008)


    [font="Verdana"]Steve, First of all thanks a lot for this excellent explanation.

    As per my understanding log file contains uncommitted transactions only, the transaction which is already committed has gone to...

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

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

Viewing 15 posts - 9,181 through 9,195 (of 9,244 total)