Post reply

RAM Usage increasing when I use the Select Statement - Why!?

  • January 18, 2008 at 7:36 am

    #119709

    Hello!

    I have a problem when I write the select statement my RAM usage increasing: example

    I'm using the SQL Server 2005 Developer Edition localy on My PC with 2 GB Ram memory!

    writing : SELECT * FROM table_1

    or

    INSERT INTO table_2

    SELECT * FROM table_1 ( definition of these two tables are the same)

    Any idea!?

    thnx!

    Dugi

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

  • January 18, 2008 at 8:13 am

    #769679

    Whats the structure of the table? How much data is in the table?

  • January 18, 2008 at 8:19 am

    #769689

    ....over 500 000 records, with 75 columns lots of data types (varchar, datetime, etcetc)!

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

  • January 18, 2008 at 9:22 am

    #769758

    It should increase as you work with more data. You can set a limit if needed in the server properties in SSMS.

  • January 18, 2008 at 10:40 am

    #769788

    Steve Jones - Editor (1/18/2008)

    It should increase as you work with more data. You can set a limit if needed in the server properties in SSMS.

    It seems to work...I will check with more data ...!

    Many Thnx, Mr. Steve Jones

    Dugi

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply