Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Regarding row size Expand / Collapse
Author
Message
Posted Tuesday, September 11, 2012 2:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
Hello Masters,

As per "Maximum Capacity Specifications for SQL Server" (for details "http://msdn.microsoft.com/en-us/library/ms143432.aspx") Bytes per row8 is "8060".

That means each row will be of 8 KB, than what will happen if row lengh is more than 8060 bytes (OR 8 KB)? Will it be continue in another row ? will it use another row? My question is what will happen when the length of the row is more than maximum capacity of sql server ?

Thanks in advance,

Jitendra
Post #1357204
Posted Tuesday, September 11, 2012 4:06 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, December 12, 2014 10:09 AM
Points: 2,876, Visits: 5,201
Googling it out would give you the answer quite easily:

http://msdn.microsoft.com/en-us/library/ms186981(v=sql.105).aspx


_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1357264
Posted Tuesday, September 11, 2012 4:14 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:37 PM
Points: 40,662, Visits: 37,127
jitendra.padhiyar (9/11/2012)
My question is what will happen when the length of the row is more than maximum capacity of sql server?


If the row is comprised of fixed-length data types, you'll get an error creating the table. If there are variable-length,they overflow onto LOB pages (much as Varchar(max) and the other max data types are handled).



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1357268
Posted Tuesday, September 11, 2012 4:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
Thanks a lot Gilamonster,

the size of the normal page is 8 KB, what is be the size of LOB pages ? Is it chain of normal pages ?

and my second question is

Can one row be written(expand) on two pages ?

Thanks in advance,

Jitendra
Post #1357274
Posted Tuesday, September 11, 2012 4:21 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:37 PM
Points: 40,662, Visits: 37,127
jitendra.padhiyar (9/11/2012)
the size of the normal page is 8 KB, what is be the size of LOB pages ?


8k. All pages without exception are 8k

Can one row be written(expand) on two pages ?


Other than via the row overflow or LOB data types, no.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1357278
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse