Contents
1
谿瑚襭
[
edit
]
1
谿瑚襭
#
碁襦蠏語所鍵.docx
( 螻螳 sqler.com 襴 伎企. 讌~ 伎 蟲襷)
Null Test
覓朱Μ蟲譟
DBCC MEMORYSTATUS 覈轟 SQL Server 2005 覃覈襴 覈磯 覦覯
(http://support.microsoft.com/kb/907877)
Inside the Storage Engine: What's in the buffer pool?
(http://sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Whats-in-the-buffer-pool.aspx)
INSERT and UPDATE loading practice - The impact of forwarding pointers
(http://sqlblogcasts.com/blogs/simons/archive/2009/08/31/INSERT-and-UPDATE-loading-practice---The-impact-of-forwarding-pointers-.aspx)
Under the covers: GAM, SGAM, and PFS pages
(http://blogs.msdn.com/sqlserverstorageengine/archive/2006/07/08/under-the-covers-gam-sgam-and-pfs-pages.aspx)
Under the covers: IAM chains in SQL Server 2000
(http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/24/645803.aspx)
What is a page split? What happens? Why does it happen? Why worry?
(http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/28/what-is-a-page-split-what-happens-why-does-it-happen-why-worry.aspx)
How It Works: SQL Server Page Allocations
(http://blogs.msdn.com/psssql/archive/2008/04/08/how-it-works-sql-server-page-allocations.aspx)
襭(tinyint & smallint) 覓朱Μ蟲譟磯蟲
(http://sqlnote.com/zbxe/Internal/158)
讀 豐蠍壱
(http://msdn.microsoft.com/ko-kr/library/ms175935.aspx)
SQL Server 襦蟾螻 覲糾規 危
(http://technet.microsoft.com/ko-kr/magazine/2009.02.logging.aspx)
8KB襯 豐螻狩 る襦 一危
(http://msdn.microsoft.com/ko-kr/library/ms186981(SQL.90).aspx)
伎 覦 旧ろ 危
(http://technet.microsoft.com/ko-kr/library/ms190969.aspx)
MemToLeave 覃覈