How does SQL server stores data?

Manish Kumar Choudhary11y ago

Accepted answer

Hi Zeeshan Azim

Go through these links you might got your answer

http://technet.microsoft.com/en-us/library/ms190969%28v=sql.105%29.aspx

https://docs.oracle.com/database/121/CNCPT/memory.htm#CNCPT7778

+1

Zeeshan Azim11y ago

Hi Manish, It helps me out to some extent but for your understanding I am giving you one example. A table has one row containing 10 columns so how SQL stores data in memory either its on contagious memory location or in paging of 8 KB size. Please forward me some more references so that I may understand the concept clearly. Thanks for your help.

0

Manish Kumar Choudhary11y ago

Hi Zeeshan Azim,
did it help u ?

0

Manish Kumar Choudhary11y ago

Hi Zeeshan Azim,

Read these links it may help you

http://msdn.microsoft.com/en-us/library/dn133186.aspx

http://www.mcobject.com/in_memory_database

0

Joginder Banger11y ago

Hi Azim,

There is a lot of answer because you can backup the table.
Backup Table
This backup table can store any drive or local hard disk.
Generate Script
You can create the Script any table or store procedure or complete database. This script can hold all data (thousand of data).

0