Regarding row size

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Regarding row size

Regarding row size

Rate Topic

Display Mode

Topic Options

Author

Message

jitendra.padhiyar

Posted Tuesday, September 11, 2012 2:49 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 18, 2013 3:09 AM
Points: 167, Visits: 440

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

Eugene Elutin

Posted Tuesday, September 11, 2012 4:06 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:59 AM
Points: 2,525, Visits: 4,324

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!" BigGrin

(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help

Post #1357264

GilaMonster

Posted Tuesday, September 11, 2012 4:14 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

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

jitendra.padhiyar

Posted Tuesday, September 11, 2012 4:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 18, 2013 3:09 AM
Points: 167, Visits: 440

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

GilaMonster

Posted Tuesday, September 11, 2012 4:21 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

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 »

Permissions