Forum Replies Created

Viewing 15 posts - 136 through 150 (of 789 total)

  • RE: Transfer logins and passwords from SQL Server 2000 to SQL Server 2008

    Not tested but it might work, I recommend you to do a test before!!!

    There is the link:

    http://tinyurl.com/y98ga5w

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    February 1, 2010 at 2:03 am

    #1111465

  • RE: SQL Server AWE?

    dba-vb (1/30/2010)

    thanks fro ur replay,

    i have a doubt:

    If production system is having 16GB RAM then is it required to AWE ON?

    .....

    If your machine running with 64 bit, you don't need...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 30, 2010 at 5:33 am

    #1111176

  • RE: SQL Server AWE?

    PAE is an Operatin System setting and you can find it at Boot.ini

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 30, 2010 at 2:52 am

    #1111156

  • RE: SQL Server AWE?

    PAE allows the OS to use more than 4GB of memory.

    AWE allows the application to use more than 4GB.

    Look at the BOL for more info about AWE configuration...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 30, 2010 at 2:38 am

    #1111151

  • RE: Patern Matching

    UT- (1/30/2010)

    ...

    @jeff:

    Thanks for this new idea, i am really looking forward to see the results BUT in your post you did not include the code to generate the tally table...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 30, 2010 at 2:17 am

    #1111148

  • RE: delete duplicates

    Yes the CTE technique is the best to eliminate your duplicate values...so just do it!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 28, 2010 at 2:21 am

    #1109812

  • RE: DevWeek 2010 is Coming Up

    Seems a lot of stuff in this event, it worth to attend!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 27, 2010 at 12:47 am

    #1109143

  • RE: We'll go no more a' tibbling

    I have seen that some developers practice to name the tables with the name of the application then table name ...etc etc

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 25, 2010 at 2:17 pm

    #1108389

  • RE: We'll go no more a' tibbling

    In tblTableName - tbl seems like schema - LOL :-P.

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 25, 2010 at 7:39 am

    #1108149

  • RE: Database Research

    CirquedeSQLeil (1/22/2010)

    SQLPirate (1/22/2010)

    Using sp_mstablespace won't give you any unused space that the table is holding and sp_msforeachtable won't return internal tables. We were having issues pinpointing our space discrepancies, which...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 22, 2010 at 5:11 pm

    #1107652

  • RE: Database Research

    I vote for CTE to find the duplicates in a table!

    :w00t::cool::hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 22, 2010 at 4:49 pm

    #1107644

  • RE: install sql server 2008 developer over windows 7 professional

    Gift Peddie (1/21/2010)

    You could try installing VS2008 with SP1 any free edition and then install it because I am running VS2008, SQL Server 2005 and SQL Server 2008 and it...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 21, 2010 at 4:49 pm

    #1107018

  • RE: install sql server 2008 developer over windows 7 professional

    Try to uninstall Norton Internet Security 2010, then try again without Norton, anyway install any other anti virus appl instead!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 21, 2010 at 4:46 pm

    #1107017

  • RE: Backup

    dba_neo (1/21/2010)

    Team,my backup job have failed stating this error

    SQL Backup failed with exit code: 505 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.

    Seems...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 21, 2010 at 2:57 pm

    #1106976

  • RE: install sql server 2008 developer over windows 7 professional

    Did you do the upgrade from Vista to Win 7? Try to format everything then install Win 7 with all updates available and after that install from beginning the SQL...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 21, 2010 at 10:23 am

    #1106826

Viewing 15 posts - 136 through 150 (of 789 total)