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 |
|
montu
Yak Posting Veteran
60 Posts |
 Posted - 2008-03-25 : 18:21:36
|
| Hi All from following link http://msdn2.microsoft.com/en-us/library/ms143432.aspxi got this information Bytes per row 8,060 Bytes per varchar(max), varbinary(max), xml, text, or image column 2^31-1 Characters per ntext or nvarchar(max) column 2^30-1so is it means we can store in nvarchar(max) or varchar(max) upto 2^31-1 characters/bytes. but on the other hand we can store only 8060 bytes in a row. so the concept of Row-Overflow Data Exceeding 8 KB comes into picture. my questions is suppose i declare a variable of type varchar(max) then i can store upto 2^30-1 bytes in it and SQL Server on its own determine how and where to stores it. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-25 : 23:24:49
|
| Sql stores blob column in separate pages, that's why they can hold more than 8060 bytes. |
 |
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-03-26 : 01:02:25
|
| Rmiao can you please clarify one thing is there is any limitation on size of disk where we store the data or SQL server on his own decides how to store pages on different disks.actually some one asked me this question (is there is any limit on block/disk size for SQL Server where we store data) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-26 : 22:57:27
|
| Sql will not store pages on different disk unless you put data file on it, and there is no block size limit. Db data file size limit is 16tb. |
|
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-03-27 : 21:00:16
|
| Thanks understand your point |
|
|
|
|
|
|
maximun storage