Results 1 to 9 of 9
  1. #1
    Join Date
    May 2012
    Posts
    3

    Unanswered: in memory db for MS SQL Server

    I am new to MS SQL and to databases in general...

    Can we do in memory database using MS SQL? It looks like we can write a piece of code to do that...like DECLARE var_name TABLE and so on....

    But is there a better way to do this?..

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Sounds like you need to learn fundamentals and correct terminology.

    It is not clear what you are asking. Please clarify.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Depending on which definition you're using it is either impossible or easy to run Microsoft SQL Server as an "in memory" database. If you aren't clear on which definition you're using, treat this as a "no". If you can explain what you actually mean, then you'll probably get a more useful answer.

    Based on the question you asked, the terms you used, and when you asked it I assume that you're a student looking for someone to do your homework.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    May 2012
    Posts
    3
    Pat:

    I meant storing the entire database in memory instead of using the hard disk space.

    I know this can be done by declaring a TABLE variable....like DECLARE @myTable TABLE....but was wondering if there is an easier way of doing this...I use MS SQL Server 2008.

    I am a working professional, but never used SQL or any databases before...hence this query.

  5. #5
    Join Date
    May 2012
    Posts
    3
    Ok...let me clarify a few more points
    I need a database that can store contents in memory instead of storing it in the hard disk....a different version of sql server or a different tool is fine too.

  6. #6
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Why does someone believe this needs to be completely "in memory"?

    The only database "things" i recall being done completely in memory was some trickery used by software vendors trying to show how fast their database software would run.

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Google "Solid State Disk" for one solution that seems to meet your needs.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You never mentioned how big your data is

    In any case...SQL Server Puts MOST of the data that has not change in memory

    ou really need to have a better background on databases first

    Someone must have asked you this question, BUT

    NO REAL DB ON THE PLANET WORKS LIKE THIS

    What happens when you go out of range of you memory?

    "Memory" is both physical and virtual

    Do you really know what you are asking for?

    And saying you know it can be done...DECLARE @t table

    Son/sister..that uses tempdb at certain points as does temp tables

    temdb as a SOLUTION just might be worse

    How do you think an RDBMS actually works

    Go investigate that

    In the meantime don't worry about

    WHAT is your reason for this "Memory" Database? Did you watch Rollerball lately (And see the very stupid remake...oh never mind)
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •