data pages

Hi everyone and thanks in advance for help.
May one data page contain data from different tables?
Thank you,
Alex
No, a data page contains data for a single table.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>
|||Page, No.
Extent, yes.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>
|||No, pages are allocated to individual tables.
http://www.aspfaq.com/
(Reverse address to reply.)
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>

data pages

Hi everyone and thanks in advance for help.
May one data page contain data from different tables?
Thank you,
AlexNo, a data page contains data for a single table.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>|||Page, No.
Extent, yes.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>|||No, pages are allocated to individual tables.
http://www.aspfaq.com/
(Reverse address to reply.)
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>

data pages

Hi everyone and thanks in advance for help.
May one data page contain data from different tables?
--
Thank you,
AlexNo, a data page contains data for a single table.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>|||Page, No.
Extent, yes.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>|||No, pages are allocated to individual tables.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>

Data Migration - Insert Script / Fresh install

Hi

I have some tables in my SQL Server 2005 database. I need to create insert scripts for them. Since these tables contain the CLOB and BLOB values and the number of records is huge, I need to devise a way to install this table data on any new database(Assuming the new database is created and the table structure exists) .Can some one suggest me how I can do this ?

DTS or SSIS is out of question because least manual interference is required.

Thanks & Regards
ImtiazYou could use BCP to export the data into text/binary files and then import it back. This is the most efficient way. Generating insert statements is not cumbersome (there are some 3rd party tools that does this). But the files will still be huge and difficult to manage.