SQL Server Interview Questions Jan 30 2006

What are page splits?
Pages are contained in extent. Every extent will have around eight data
pages. But all the
eight data pages are not created at once; it's created depending on
data demand. So when
a page becomes full it creates a new page, this process is called as
"Page Split".

Full Interview Questions for .NET and SQL Server
http://www.geocities.com/dotnetinterviews/
Help the community to make job search easier mail your questions to
 jobatyourdoorstep@ya
hoo.co.in
Looking for a job mail your resumes at  jobatyourdoorstep@ya
hoo.co.in