is sql 2005 based on imdb (in-memory database)?

Hi guys, i need a page at microsoft that says it, it's for a technical
proposal, until now i've just found oracle's timesten, i've searched at
google and microsoft but i have not results about.
Also i need to know if it supports journaling.
Regards.
I guess we would need to see the definitions of "in memory database" (that can mean a lot of things)
and journaling. If you mean what I think you mean, then the answer is no on both questions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
> Hi guys, i need a page at microsoft that says it, it's for a technical proposal, until now i've
> just found oracle's timesten, i've searched at google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
>
|||Rick wrote:
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
What feature are you looking for? SQL Server does cache data
"in-memory" but if you are looking for a deployable database engine or
one for embeddable systems then look at SQL Server Express or Mobile
Edition
"Journaling" could mean Differential or Transaction Log backups or
Versioning or Snapshots in SQL Server - depends on what your definition
of Journaling is.
SQL Server 2005 Features Comparison:
http://www.microsoft.com/sql/prodinf...-features.mspx
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||ok, well journaling is logging all transactions, and if SQL has it then is
ok
Definition of: in-memory database
A database that keeps all active records in main memory rather than on disk.
Accessing in-memory records is considerably faster than retrieving them from
the disk.
"Rick" <elmargaro@.hotmail.com> escribi en el mensaje
news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
>
|||Yes, SQL Server logs all modifications in the transaction log.
SQL Server has a fairly sophisticated cache handling mechanism, but it essentially means that hot
pages will be cached (in memory).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl...
> ok, well journaling is logging all transactions, and if SQL has it then is ok
> Definition of: in-memory database
> A database that keeps all active records in main memory rather than on disk. Accessing in-memory
> records is considerably faster than retrieving them from the disk.
>
> "Rick" <elmargaro@.hotmail.com> escribi en el mensaje
> news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
>
|||Thanks a lot!!!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribi
en el mensaje news:%235f7kPLTGHA.1572@.tk2msftngp13.phx.gbl...
> Yes, SQL Server logs all modifications in the transaction log.
> SQL Server has a fairly sophisticated cache handling mechanism, but it
> essentially means that hot pages will be cached (in memory).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Rick" <elmargaro@.hotmail.com> wrote in message
> news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl...
>

is sql 2005 based on imdb (in-memory database)?

Hi guys, i need a page at microsoft that says it, it's for a technical
proposal, until now i've just found oracle's timesten, i've searched at
google and microsoft but i have not results about.
Also i need to know if it supports journaling.
Regards.I guess we would need to see the definitions of "in memory database" (that c
an mean a lot of things)
and journaling. If you mean what I think you mean, then the answer is no on
both questions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl..
.
> Hi guys, i need a page at microsoft that says it, it's for a technical pro
posal, until now i've
> just found oracle's timesten, i've searched at google and microsoft but i
have not results about.
> Also i need to know if it supports journaling.
> Regards.
>|||Rick wrote:
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
What feature are you looking for? SQL Server does cache data
"in-memory" but if you are looking for a deployable database engine or
one for embeddable systems then look at SQL Server Express or Mobile
Edition
"Journaling" could mean Differential or Transaction Log backups or
Versioning or Snapshots in SQL Server - depends on what your definition
of Journaling is.
SQL Server 2005 Features Comparison:
http://www.microsoft.com/sql/prodin...e-features.mspx
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||ok, well journaling is logging all transactions, and if SQL has it then is
ok
Definition of: in-memory database
A database that keeps all active records in main memory rather than on disk.
Accessing in-memory records is considerably faster than retrieving them from
the disk.
"Rick" <elmargaro@.hotmail.com> escribi en el mensaje
news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
>|||Yes, SQL Server logs all modifications in the transaction log.
SQL Server has a fairly sophisticated cache handling mechanism, but it essen
tially means that hot
pages will be cached (in memory).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl..
.
> ok, well journaling is logging all transactions, and if SQL has it then is
ok
> Definition of: in-memory database
> A database that keeps all active records in main memory rather than on dis
k. Accessing in-memory
> records is considerably faster than retrieving them from the disk.
>
> "Rick" <elmargaro@.hotmail.com> escribi en el mensaje
> news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
>|||Thanks a lot!!!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribi
en el mensaje news:%235f7kPLTGHA.1572@.tk2msftngp13.phx.gbl...
> Yes, SQL Server logs all modifications in the transaction log.
> SQL Server has a fairly sophisticated cache handling mechanism, but it
> essentially means that hot pages will be cached (in memory).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Rick" <elmargaro@.hotmail.com> wrote in message
> news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl...
>

is sql 2005 based on imdb (in-memory database)?

Hi guys, i need a page at microsoft that says it, it's for a technical
proposal, until now i've just found oracle's timesten, i've searched at
google and microsoft but i have not results about.
Also i need to know if it supports journaling.
Regards.I guess we would need to see the definitions of "in memory database" (that can mean a lot of things)
and journaling. If you mean what I think you mean, then the answer is no on both questions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
> Hi guys, i need a page at microsoft that says it, it's for a technical proposal, until now i've
> just found oracle's timesten, i've searched at google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
>|||Rick wrote:
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
What feature are you looking for? SQL Server does cache data
"in-memory" but if you are looking for a deployable database engine or
one for embeddable systems then look at SQL Server Express or Mobile
Edition
"Journaling" could mean Differential or Transaction Log backups or
Versioning or Snapshots in SQL Server - depends on what your definition
of Journaling is.
SQL Server 2005 Features Comparison:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||ok, well journaling is logging all transactions, and if SQL has it then is
ok
Definition of: in-memory database
A database that keeps all active records in main memory rather than on disk.
Accessing in-memory records is considerably faster than retrieving them from
the disk.
"Rick" <elmargaro@.hotmail.com> escribió en el mensaje
news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
>|||Yes, SQL Server logs all modifications in the transaction log.
SQL Server has a fairly sophisticated cache handling mechanism, but it essentially means that hot
pages will be cached (in memory).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl...
> ok, well journaling is logging all transactions, and if SQL has it then is ok
> Definition of: in-memory database
> A database that keeps all active records in main memory rather than on disk. Accessing in-memory
> records is considerably faster than retrieving them from the disk.
>
> "Rick" <elmargaro@.hotmail.com> escribió en el mensaje
> news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
>> Hi guys, i need a page at microsoft that says it, it's for a technical proposal, until now i've
>> just found oracle's timesten, i've searched at google and microsoft but i have not results about.
>> Also i need to know if it supports journaling.
>> Regards.
>|||Thanks a lot!!!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió
en el mensaje news:%235f7kPLTGHA.1572@.tk2msftngp13.phx.gbl...
> Yes, SQL Server logs all modifications in the transaction log.
> SQL Server has a fairly sophisticated cache handling mechanism, but it
> essentially means that hot pages will be cached (in memory).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Rick" <elmargaro@.hotmail.com> wrote in message
> news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl...
>> ok, well journaling is logging all transactions, and if SQL has it then
>> is ok
>> Definition of: in-memory database
>> A database that keeps all active records in main memory rather than on
>> disk. Accessing in-memory records is considerably faster than retrieving
>> them from the disk.
>>
>> "Rick" <elmargaro@.hotmail.com> escribió en el mensaje
>> news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
>> Hi guys, i need a page at microsoft that says it, it's for a technical
>> proposal, until now i've just found oracle's timesten, i've searched at
>> google and microsoft but i have not results about.
>> Also i need to know if it supports journaling.
>> Regards.
>>
>