Forum Replies Created

Viewing 15 posts - 8,791 through 8,805 (of 9,244 total)

  • RE: Dynamic IP versus Static IP connection

    the public DNS servers will have no knowledge of your internal network naming

    from a command prompt type the following and post the complete results

    IPCONFIG/ALL

    also what make\model is your router?

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

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

  • RE: Which is quicker when inserting: DROP table and rebuild indexes, or TRUNCATE

    you wont be able to truncate tables if there are referential integrity constraints on them (foreign keys for example)

    disabling the indexes will help from a performance point and maybe you...

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

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

  • RE: Errors in MSSMS running jobs

    go into add\remove programs and run a repair on the .NET 2.0 framework

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

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

  • RE: Combine multiple tables into 1 table

    my thoughts exactly

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

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

  • RE: Which is quicker when inserting: DROP table and rebuild indexes, or TRUNCATE

    depends on the referential integrity of the tables, etc. Do you want to import data such as key id fields?

    disable any constraints and import the data then re enable them

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

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

  • RE: restore a DB to developer server with smaller datafiles than in Backup

    michael.anyone (10/26/2008)


    allocated as 100GB file but having only 20GB inside

    first thing i would do Michael is ascertain just how much disk space the live database requires.

    Once this is done shrink...

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

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

  • RE: Log file full

    choose the correct recovery model for your database and backup accordingly

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

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

  • RE: Question on SQL2000 to SQL2005 imports

    dont forget to run dbcc updateusage against each database and rebuild the indexes too

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

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

  • RE: Help me in my project please

    GilaMonster (10/26/2008)


    There's no direct way to query the filesystem.

    i would say this is best done through the web pages code

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

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

  • RE: sqlserver 64-bit edition

    memory support in the main, 64 bit has better support for larger memory configs

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

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

  • RE: Question on SQL Server Security, Logins, User Mappings

    fivetenmm (10/24/2008)


    So, at the Server level you add a new login let's call it "test1" using Windows Auth mode. Does this just allow "test1" to connect to the Server...

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

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

  • RE: Shrinkfile and log backup

    victor_bosc (10/23/2008)


    And, what do you think about only rebuilding indexes once a week?

    that is the strategy i employ

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

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

  • RE: Change the SQL Server TCP/IP Ports

    your welcome

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

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

  • RE: Change the SQL Server TCP/IP Ports

    for the SQL2005 box leave IP1, Ip2, IP3 unset. Configure IP All with the port number and leave dynamic blank. Restart the instance

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

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

  • RE: Scheduling JOB for SSIS Package

    have you imported the package to the file system or package store on the server

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

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

Viewing 15 posts - 8,791 through 8,805 (of 9,244 total)