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
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 understanding page's sql server

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2011-06-13 : 10:48:15
Hi all,

Can anyone suggest any video tutorial or a webcast which talks about the PAGE architecture whichs gives a picturial representation to understanding the page architecture.

Want to understand GAM,SGAM,PFS,DIFF,ML with some examples.

Any help would be greatly appreciated.

Thanks in advance.

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-06-13 : 10:57:27
try sql server 2008 internals by Kalen Delany


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-06-13 : 11:03:42
There's also Paul Randal's blog: http://sqlskills.com/BLOGS/PAUL/category/On-Disk-Structures.aspx

And the MS SQL Storage Engine team blog: http://blogs.msdn.com/b/sqlserverstorageengine/
Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2011-06-14 : 02:32:40
Thanks for the help.
Go to Top of Page
   

- Advertisement -