Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
booyeeka
Starting Member
10 Posts |
 Posted - 2008-03-16 : 10:37:10
|
| hi all!i'm not sure that i understand how sql server stores data.in documentation, i found that sql server stores data in pages.every page have size of 8192 bytes (8060).as i understand well, every table row is stored in one page. also, every table row can not be larger then one page. and that's where my confusion starts - because it sounds like we can not have data in table that is larger then 8060. please, if you can you help me to understand this.thank you in advance! |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-16 : 17:00:56
|
| >> it sounds like we can not have data in table that is larger then 8060.Correct except blob, which can hold 2g bytes and be stored in separate pages. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-16 : 17:03:34
|
| lets not forget the new varchar(max), nvarchar(max) and varbinary(max) datatypes that when larger than 8k uses overflow pages._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
pages and extents