透明加密视频演示代码
摘要：http://technet.microsoft.com/zh-cn/dd793599.aspx[代码]
阅读全文
posted @
2009-04-27 16:13
stswordman
阅读(3444)
推荐(0) 编辑
table scan against heap with forward pointer
摘要：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顺序查找...
阅读全文
posted @
2009-04-14 18:18
stswordman
阅读(478)
推荐(0) 编辑
what's page are loaded into buffer pool for specified table
摘要：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...
阅读全文
posted @
2009-04-13 11:45
stswordman
阅读(119)
推荐(0) 编辑
