Forum Replies Created

Viewing 15 posts - 2,431 through 2,445 (of 3,232 total)

  • RE: Active-Active or Active-Passive Clustering

    Sqlquery, I echo what all of these guys have said, but I do want to add one thing.  Active-Active SQL Server clustering is not the same as active-active Windows Server...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    February 2, 2007 at 9:08 am

    #687462

  • RE: DBReIndex & Defrag

    I would recommend using the DBREINDEX as your primary index maintenance strategy.  I would also recommend to run DBCC SHOWCONTIG directly prior to, directly after, and 1/2 way in between...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    February 2, 2007 at 8:51 am

    #687451

  • RE: Rebuilt server

    Some of this depends on how you are accessing your SQL Server accross the network.  I would recommend looking into using DNS for the cutover.  If you are referencing the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    February 1, 2007 at 3:51 pm

    #687250

  • RE: DBReIndex & Defrag

    How long does your DBReindex take when you do run it?  How often is 'once in a while'?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    February 1, 2007 at 10:19 am

    #687158

  • RE: Reading txt file then creating new table

    For you to be able to automate the import process, the source files need to be in a consistent format.  I would recommend talking to whoever generates that source file...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    February 1, 2007 at 9:24 am

    #687130

  • RE: Identity Column

    Lowell is correct.  Adding a clustered index on your date columns should force the Identity column to generate values ordered by that date.  I would recommend testing thoroughly.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 30, 2007 at 12:42 pm

    #686575

  • RE: AWE check

    Yes, additional memory will help alleviate paging.

     

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 30, 2007 at 9:29 am

    #686499

  • RE: /3GB switch

    You have 2 options to increase your memory.

    1. Upgrade your server OS to Windows Advanced Server.  Configure your boot.ini file to use the /3GB switch.  Configure SQL Server's Max Server...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 29, 2007 at 4:18 pm

    #686320

  • RE: Getting the current state from a "log" table

    OK, so I misunderstood and you're not working off of the system tables.  If I am understanding you now, you only want to query this single table that you've shown. ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 29, 2007 at 4:13 pm

    #686317

  • RE: /3GB switch

    This will be dependant on your SQL Server 2000 version.  You will need to be running Developer or Enterprise edition.  You will also need at least 4GB of memory installed...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 29, 2007 at 3:51 pm

    #686308

  • RE: Getting the current state from a "log" table

    The current state of any object will be in the system tables.  You should not need to cross reference your 'log' table.  By the way, are you running SQL Server...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 29, 2007 at 3:44 pm

    #686306

  • RE: /3GB switch

    What OS version are you running?  The /3GB switch is only supported in the following Windows platforms:

    Windows XP Professional

    Windows Server 2003

    Windows Server 2003, Enterprise Edition

    Windows Server 2003, Datacenter Edition

    Windows 2000 Advanced...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 29, 2007 at 12:21 pm

    #686242

  • RE: Restore problem, Unable to attach database

    Well, can you be more specific as to what you are doing?  It sounds like you are doing a restore on your QA box, detaching the DB, renaming the physical...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 26, 2007 at 11:25 am

    #685916

  • RE: DTS Package running on Server A and Source file running on Server B

    Use the UNC path in the filename property of the TextFile Source Connection object in your DTS package.  You will have to make sure that you (and the SQL Agent if...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 25, 2007 at 3:44 pm

    #685719

  • RE: DTS job scheduling with Variables

    OK, Kerstin.  Check in your package for an ActiveX script containting the inputBox function.  This will prompt for input from the user.  You could change this prompt to only prompt...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 25, 2007 at 3:03 pm

    #685709

Viewing 15 posts - 2,431 through 2,445 (of 3,232 total)