摘要：http://technet.microsoft.com/zh-cn/dd793599.aspx[代码] 阅读全文

摘要：This post was published to stswordman at 6:09:31 PM 4/14/2009 table scan against heap with forward pointer Sql server维护了一个内部指针，它指向了表的第一个IAM页,还有一个执行表的首页的内部指针对一个表(heap)执行table scan时，sql server会按照IAM顺序查找... 阅读全文

摘要：CodeCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->select * from sys.dm_os_buffer_descriptors bp inner join ( select OBJECT_ID,allocation_u... 阅读全文