Question SQL Server Internals - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

Question SQL Server Internals

Author

Topic

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-06-24 : 03:00:23

Hi All,

I read that a row should fit into one page only, single row cannot be shared by 2pages,

What If data in the row is not sufficient to fit in 8kb page?
or this never happens.

even if it is placing a pointer in that page and storing data in other page (on some other Allocation units extent), then also this page will be of 8kb only.

How is this handled in SQL Server,

Is there any major changes with SQL Server 2008 compare to 2005 w.r.t page

Regards
aak

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-24 : 03:13:03

Then it's called a LOB (Large OBject) and is stored in the LOB pages, outside the normal table pages.
This is quite common if you store documents and images in the sql server.

The record contains a pointer to the lob pages.

E 12°55'05.63"
N 56°04'39.26"

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-06-24 : 03:17:50

Thanks Peso,

I understands that, again the LOB page is of 8kb only.

Regards,
aak

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-06-24 : 04:35:59

Any updates on this?

ajay_uiet
Starting Member

9 Posts

Posted - 2009-06-24 : 07:07:10

I am getting error in Copy database wizard

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error

Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-06-24 : 08:26:59

Dear Ajay,

I do not understand why you have posted, your question here, you can start a new thread for your query.

Regards,
aak

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-06-24 : 11:09:44

quote:
Originally posted by aakcse

Any updates on this?

All pages are 8kb in size. In the case of LOB data, there'll be a chain of pages that contain the LoB data

--
Gail Shaw
SQL Server MVP

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-06-24 : 11:11:22

Thanks Gila

Means one row data can be spread across the chain of pages?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-06-24 : 11:20:40

Not one data row. On the data pages, a row cannot span more than one page. When there's LOB data in a table (text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml) then that data is stored in LoB pages and those pages can be chained together. A LOB column can contain up to 2 GB of data.

It's only the LOB pages where data from a single row can be on multiple pages.

--
Gail Shaw
SQL Server MVP

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-06-25 : 08:54:43

Thanks your reply is very helpful...now I got it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources