June 13, 2011 at 8:45 am
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.
June 13, 2011 at 8:50 am
The first few here probably. They're not beginner-level though.
http://www.sqlskills.com/T_MCMVideos.asp
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 13, 2011 at 9:00 am
Thanks Gila for the help.
June 13, 2011 at 9:28 am
In addition to videos which can be incomplete, I'd suggest getting a copy of Kalen Delaney's book "SQL Server 2008 Internals." It's a must own.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2011 at 9:44 am
Klause Aschenbrenner also did a good job with his ppt.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 13, 2011 at 11:34 am
Thank you so much.
June 13, 2011 at 11:37 am
Grant Fritchey (6/13/2011)
In addition to videos which can be incomplete, I'd suggest getting a copy of Kalen Delaney's book "SQL Server 2008 Internals." It's a must own.
I second this.
It will give you a good overview of the SQL Server page structure.
-------------------------------------------------
Will C,
MCITP 2008 Database Admin, Developer
June 14, 2011 at 12:29 am
Thank You.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply