SQLSERVER聚集索引与非聚集索引的再次研究(上)

原文:SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

上篇主要说聚集索引

下篇的地址:SQLSERVER聚集索引与非聚集索引的再次研究(下)

由于本人还是SQLSERVER菜鸟一枚,加上一些实验的逻辑严谨性,
单写《SQLSERVER聚集索引与非聚集索引的再次研究(上)》就用了12个小时,两篇文章加起来最起码写了20个小时,
本人非常非常用心的努力完成这两篇文章,希望各位看官给点意见o(∩_∩)o

 

为了搞清楚索引内部工作原理和结构,真是千头万绪,这篇文章只是作为参考,里面的观点不一定正确

有一些问题,msdn里,网上的文章里,博客园里都有提到,但是这些问题的答案是正确的吗?其实有时候我自己都想知道答案

比如,画聚集索引的图,有一些人用表格来表示,但是他们正确吗?

以前知道聚集索引 非聚集索引是B树 二叉树结构,又知道执行计划图标很像二叉树很传神,但是还是觉得很抽象

这篇文章写完以后还是比较抽象但是最起码比以前清晰一些了

SQLSERVER聚集索引与非聚集索引的再次研究(上)SQLSERVER聚集索引与非聚集索引的再次研究(上)

有很多问题不知道为什么,但是MSDN就是这样说的,既然说得这麽模糊不如自己做一下实验,验证一下MSDN的内容吧o(∩_∩)o

--------------------------------------------华丽的分割线---------------------------------------------

 先来看一下索引的结构,文章里面的一些结构图都是自己画的一些草图,本人自认画得非常烂,希望各位看官谅解o(∩_∩)o

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 SQLSERVER聚集索引与非聚集索引的再次研究(上)

 

 SQLSERVER聚集索引与非聚集索引的再次研究(上)

----------------------------------------------华丽的分割线---------------------------------------------------------

先创建一个表,保存DBCC IND的结果

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 CREATE TABLE DBCCResult (
 2 PageFID NVARCHAR(200),
 3 PagePID NVARCHAR(200),
 4 IAMFID NVARCHAR(200),
 5 IAMPID NVARCHAR(200),
 6 ObjectID NVARCHAR(200),
 7 IndexID NVARCHAR(200),
 8 PartitionNumber NVARCHAR(200),
 9 PartitionID NVARCHAR(200),
10 iam_chain_type NVARCHAR(200),
11 PageType NVARCHAR(200),
12 IndexLevel NVARCHAR(200),
13 NextPageFID NVARCHAR(200),
14 NextPagePID NVARCHAR(200),
15 PrevPageFID NVARCHAR(200),
16 PrevPagePID NVARCHAR(200)
17 )
SQLSERVER聚集索引与非聚集索引的再次研究(上)

创建一个聚集索引表

SQLSERVER聚集索引与非聚集索引的再次研究(上)
1 --只有聚集索引
2 CREATE TABLE Department(
3     DepartmentID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
4     Name NVARCHAR(200) NOT NULL,
5     GroupName NVARCHAR(200) NOT NULL,
6     Company NVARCHAR(300),
7     ModifiedDate datetime NOT NULL  DEFAULT (getdate())
8 )
SQLSERVER聚集索引与非聚集索引的再次研究(上)

插入10W条记录

1 INSERT INTO Department(name,[Company],groupname) VALUES(销售部,中国你好有限公司XX分公司,销售组)
2 GO 100000

将DBCC IND的结果放入DBCCRESULT表

1 INSERT INTO DBCCResult EXEC (DBCC IND(pratice,Department,-1) )

查询Department表中的页面情况

先说明一下:

PageType  分页类型: 1:数据页面;2:索引页面;3:Lob_mixed_page;4:Lob_tree_page;10:IAM页面

IndexID    索引ID:   0 代表堆, 1 代表聚集索引, 2-250 代表非聚集索引 ,大于250就是text或image字段

红色框部分都是需要关注的

SQLSERVER聚集索引与非聚集索引的再次研究(上)

第一个:IAM页不是只有堆表才有也不只是维护堆表中的数据页的连续,有索引的表都有,所以IAM页不只维护数据页,也维护索引页的连续,在下篇说到非聚集索引的时候

我会给出MSDN的解释和IAM页在聚集索引表,非聚集索引表中的情况

第二个:每个数据页的IndexID都是1,不是说数据页变成了索引页,而是说现在数据页已经属于聚集索引的一部分,不在堆里了

第三个:每个数据页的IndexLevel都是0,就是说数据页在聚集索引的最下层

第四个:索引页和数据页,前一页和后一页是首尾相连的,但是数据页和索引页不是首尾相连的,也就是说没有一个数据页的[PrevPagePID]指向14464页或3528页

那么在上面的聚集索引图片中为什麽会说索引页指向数据页呢?叶子节点就是数据页呢?

数据页的index level是0,那么就是说聚集索引的叶子节点就是数据页

SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 上面索引页的结构

SQLSERVER聚集索引与非聚集索引的再次研究(上)

现在来看一下索引页里都有什么,运行下面的SQL语句

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 DBCC TRACEON(3604,-1)
 2 GO
 3 
 4 DBCC PAGE([pratice],1,3527,3)
 5 GO
 6 
 7 
 8 DBCC PAGE([pratice],1,3528,3)
 9 GO
10 
11 DBCC PAGE([pratice],1,14464,3)
12 GO
SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 您们应该看到ChildPageId,所以上面我的图为什麽会这样画的原因,索引页连接着数据页,而且一个索引页指向多个数据页

SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 DepartmentID是主键列,从1开始自增,那么从下图可以看出主键列数据是从最左边的索引节点(不是叶子节点)开始排序

SQLSERVER聚集索引与非聚集索引的再次研究(上)

这里有个问题:为什麽根节点只有两行???是不是根节点只作连接作用,所以只有两行 ,不过这个问题我也不清楚

SQLSERVER聚集索引与非聚集索引的再次研究(上)

聚集索引页里主键列DepartmentID上一行与下一行相差120条记录,一个数据页刚好容纳120条记录

KeyHashValue根据主键列的第一个字段而生成的,就算两个表完全一样,这个hash出来的KeyHashValue都不会一样

我创建了一个一模一样的表Department2,看到hash出来的值都不一样

SQLSERVER聚集索引与非聚集索引的再次研究(上)

而这个KeyHashValue我们就叫做键,也就是key-value中的key

SQLSERVER聚集索引与非聚集索引的再次研究(上)

------------------------------------------------------------华丽的分割线------------------------------------------------------

聚集索引怎麽找记录的???

这里要分两种情况:(1)聚集索引查找和(2)聚集索引扫描

(1)聚集索引查找

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 放大一下索引页

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 SQLSERVER首先把每个数据页的头一条记录里的DepartmentID的值加上一定范围值hash出一个key值,然后放在KeyHashValue列里

当我要找DepartmentID为110的那条记录里的GroupName和Company的值的时候,首先SQLSERVER根据where DepartmentID=110

将110加上一个范围值hash出一个值,这个值就是KeyHashValue的值,找到KeyHashValue=(f000ff86397c)的那条记录

然后到数据页13791里找出DepartmentID为110的那条记录里的GroupName和Company的值

 其实这里的算法应该跟hash join是一样的,但是实际具体怎麽算的?本人就不清楚了,大家可以看一下hash join的原理

个人感觉在SQLSERVER里 key-value hash桶用途很广泛,执行计划、 hash join、 聚集索引都用到了

证明:这里我可以证明一下SQLSERVER聚集索引查找记录的流程

先到索引页里找到键值为KeyHashValue=XXX的那条记录,然后再到数据页里把实际数据读出来

 运行下面的SQL语句,看一下SQLSERVER申请的锁就知道了

 下面实验我在Department2表里做的,表数据和表结构和Department1一模一样

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 --只有聚集索引
 2 CREATE TABLE Department2(
 3     DepartmentID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
 4     Name NVARCHAR(200) NOT NULL,
 5     GroupName NVARCHAR(200) NOT NULL,
 6     Company NVARCHAR(300),
 7     ModifiedDate datetime NOT NULL  DEFAULT (getdate())
 8 )
 9 
10 INSERT INTO Department2(name,[Company],groupname) VALUES(销售部,中国你好有限公司XX分公司,销售组)
11 GO 100000
12 
13 
14 SELECT * FROM Department2
15 
16 --先清空[DBCCResult]表里的记录
17 --TRUNCATE TABLE [dbo].[DBCCResult]
18 INSERT INTO DBCCResult EXEC (DBCC IND(pratice,Department2,-1) )
19 
20 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 
21 
22 DBCC PAGE([pratice],1,14471,3)
23 GO
24 
25 DBCC PAGE([pratice],1,4375,3)
26 GO
27 DBCC PAGE([pratice],1,4376,3)
28 GO
View Code

 下面这个证明代码在《SQLSERVER企业级平台管理实践》里找的

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 USE [pratice]
 2 GO
 3 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
 4 GO
 5 --以下查询使用了聚集索引查找 ctrl+l
 6 BEGIN TRAN
 7 SELECT GroupName FROM [dbo].[Department2]  WHERE DepartmentID IN(32641,361,32281) 
 8 
 9 --COMMIT TRAN
10 
11 USE [pratice] --要查询申请锁的数据库
12 GO
13 SELECT
14 [request_session_id],
15 c.[program_name],
16 DB_NAME(c.[dbid]) AS dbname,
17 [resource_type],
18 [request_status],
19 [request_mode],
20 [resource_description],OBJECT_NAME(p.[object_id]) AS objectname,
21 p.[index_id]
22 FROM sys.[dm_tran_locks] AS a LEFT JOIN sys.[partitions] AS p
23 ON a.[resource_associated_entity_id]=p.[hobt_id]
24 LEFT JOIN sys.[sysprocesses] AS c ON a.[request_session_id]=c.[spid]
25 WHERE c.[dbid]=DB_ID(pratice) AND a.[request_session_id]=@@SPID  ----要查询申请锁的数据库
26 ORDER BY [request_session_id],[resource_type]
View Code

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

(2)聚集索引扫描

先drop掉Department2表,然后重新创建Department2表

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 --只有聚集索引
 2 CREATE TABLE Department2(
 3     DepartmentID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
 4     Name NVARCHAR(200) NOT NULL,
 5     GroupName NVARCHAR(200) NOT NULL,
 6     Company NVARCHAR(300),
 7     ModifiedDate datetime NOT NULL  DEFAULT (getdate())
 8 )
 9 
10 DECLARE @i INT
11 SET @i=1
12 WHILE @i < 100000 
13     BEGIN
14         INSERT  INTO Department3 ( name, [Company], groupname )
15         VALUES  ( 销售部, 中国你好有限公司XX分公司+CAST(@i AS VARCHAR(200)), 销售组+CAST(@i AS VARCHAR(200)) )
16         SET @i = @i + 1
17     END
18 
19 
20 SELECT * FROM Department2
View Code

证明:

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 USE [pratice]
 2 GO
 3 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
 4 GO
 5 --以下查询使用了聚集索引查找 ctrl+l
 6 BEGIN TRAN
 7 SELECT * FROM [dbo].[Department2]  WHERE [GroupName] =销售组83421
 8 
 9 --COMMIT TRAN
10 
11 USE [pratice] --要查询申请锁的数据库
12 GO
13 SELECT
14 [request_session_id],
15 c.[program_name],
16 DB_NAME(c.[dbid]) AS dbname,
17 [resource_type],
18 [request_status],
19 [request_mode],
20 [resource_description],OBJECT_NAME(p.[object_id]) AS objectname,
21 p.[index_id]
22 FROM sys.[dm_tran_locks] AS a LEFT JOIN sys.[partitions] AS p
23 ON a.[resource_associated_entity_id]=p.[hobt_id]
24 LEFT JOIN sys.[sysprocesses] AS c ON a.[request_session_id]=c.[spid]
25 WHERE c.[dbid]=DB_ID(pratice) AND a.[request_session_id]=@@SPID  ----要查询申请锁的数据库
26 ORDER BY [request_session_id],[resource_type]
View Code

SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

上图“以下查询使用了聚集索引查找”,由于本人写SQL代码的时候没有修改上面注释,大家可以不用理会

为什麽会有一个键锁,那么多的页锁,在徐海蔚老师的《SQLSERVER企业级平台管理实践》的书本里第361页说到

因为在有聚集索引的表格上,数据是直接存放在索引的最底层(叶子节点),所以要扫描整个表格里的数据,就要把整个聚集索引

扫描一遍。在这里,聚集索引扫描就相当于一个表扫描。所要用的时间和资源与表扫描没有什么差别

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 

再看一下聚集索引查找的流程

SQLSERVER首先把每个数据页的头一条记录里的DepartmentID的值加上一定范围值hash出一个key值,然后放在KeyHashValue列里

当我要找DepartmentID为110的那条记录里的GroupName和Company的值的时候,首先SQLSERVER根据where DepartmentID=110

将110加上一个范围值hash出一个值,这个值就是KeyHashValue的值,找到KeyHashValue=(f000ff86397c)的那条记录

然后到数据页13791里找出DepartmentID为110的那条记录里的GroupName和Company的值

因为[GroupName]列不是索引列,所以根本找不到KeyHashValue值,所以这里只能使用扫描所有数据页的方法来找出记录,除非找到那条记录

不然SQLSERVER不会停止扫描数据页,所以才看到上图有那么多的页面上加了页锁,SQLSERVER需要逐个数据页逐个数据页去扫描就像堆表的全表扫描那样。

那个键锁我估计是当SQLSERVER找到那条记录之后,需要在

记录的所在页面(即是索引页指向那个记录的数据页的那一行)加上一个键锁,以防止别人删除索引页的那一行记录

但是聚集索引扫描是不是一定比聚集索引查找要差呢?这个不一定,要看实际情况o(∩_∩)o

那么非聚集索引扫描是不是跟聚集索引扫描一样,所要用的时间和资源与表扫描没有什么差别呢???

大家可以看一下《SQLSERVER聚集索引与非聚集索引的再次研究(下)》本人做的一个小实验

实验证明了《SQLSERVER企业级平台管理实践》里第363页说到的内容

索引扫描表明SQLSERVER正在扫描一个非聚集索引。由于非聚集索引上一般只会有一小部分字段,所以这里虽然也是扫描,但是

代价会比整表扫描要小很多

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 

 ------------------------------------------------华丽的分割线--------------------------------------------------------------------

 这里有一个问题:没有主键但是有聚集索引,索引页的列数不一样,会多了一列,而这个列(uniquifier)的作用在下面会讲到

这里创建Department3表

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 --只有聚集索引
 2 CREATE TABLE Department3(
 3     DepartmentID int IDENTITY(1,1) NOT NULL ,
 4     Name NVARCHAR(200) NOT NULL,
 5     GroupName NVARCHAR(200) NOT NULL,
 6     Company NVARCHAR(300),
 7     ModifiedDate datetime NOT NULL  DEFAULT (getdate())
 8 )
 9 
10 CREATE CLUSTERED INDEX CL_DepartmentID ON [dbo].[Department3]([DepartmentID])
11 
12 DECLARE @i INT
13 SET @i=1
14 WHILE @i < 100000 
15     BEGIN
16         INSERT  INTO Department3 ( name, [Company], groupname )
17         VALUES  ( 销售部, 中国你好有限公司XX分公司+CAST(@i AS VARCHAR(200)), 销售组+CAST(@i AS VARCHAR(200)) )
18         SET @i = @i + 1
19     END
20 
21 
22 SELECT * FROM Department3
23 
24 --TRUNCATE TABLE [dbo].[DBCCResult]
25 
26 INSERT INTO DBCCResult EXEC (DBCC IND(pratice,Department3,-1) )
27 
28 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 
29 
30 DBCC PAGE([pratice],1,13861,3)
31 GO
View Code

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 可以看到只有聚集索引没有主键的表会比主键表多了一列uniquifier列,这个列的作用会在创建Department5表的时候讲到

-----------------------------------------------华丽的分割线-------------------------------------------------------

 下面说一下,复合主键或者聚集索引建立在多个字段上,KeyHashValue只会根据第一个字段生成hash key

当你查询的时候where 后面的字段不包含创建聚集索引时的第一个字段或者复合主键的第一个字段就会聚集索引扫描而不是聚集索引查找

 创建Department4表

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 --只有聚集索引
 2 CREATE TABLE Department4  --包含复合主键DepartmentID 和Name
 3 (
 4   DepartmentID INT IDENTITY(1, 1) NOT NULL ,
 5   Name NVARCHAR(200) NOT NULL ,
 6   GroupName NVARCHAR(200) NOT NULL ,
 7   Company NVARCHAR(300) ,
 8   ModifiedDate DATETIME NOT NULL DEFAULT ( GETDATE() ) ,
 9   CONSTRAINT [PK_Department4_1] PRIMARY KEY CLUSTERED
10     ( DepartmentID ASC,
11       Name ASC )
12     WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
13            ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY]
14 ) ON [PRIMARY]
15 
16 
17 DECLARE @i INT
18 SET @i=1
19 WHILE @i < 100000 
20     BEGIN
21         INSERT  INTO Department4 ( name, [Company], groupname )
22         VALUES  ( 销售部+CAST(@i AS VARCHAR(200)), 中国你好有限公司XX分公司, 销售组 )
23         SET @i = @i + 1
24     END
25 
26 
27 SELECT * FROM [dbo].[Department4]
28 
29 
30 
31 --TRUNCATE TABLE [dbo].[DBCCResult]
32 INSERT INTO DBCCResult EXEC (DBCC IND(pratice,Department4,-1) )
33 
34 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 
35 
36 DBCC PAGE([pratice],1,7102,3)
37 GO
View Code

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 

1 SELECT * FROM [dbo].[Department4] WHERE name=销售部6  --聚集索引扫描  因为name不是复合主键中的第一个字段
2 SELECT * FROM [dbo].[Department4] WHERE name=销售部241 AND [DepartmentID]=241  --聚集索引查找
3 SELECT * FROM [dbo].[Department4] WHERE [DepartmentID]=241   --聚集索引查找

 SQLSERVER聚集索引与非聚集索引的再次研究(上)

 SQLSERVER聚集索引与非聚集索引的再次研究(上)

在建立聚集索引的时候在多个字段上建立聚集索引是没有任何意义的

因为聚集索引查找是根据建立索引的第一个字段来查找,索引扫描的时候会到数据页里扫描 ,而聚集索引的每一行只是一个数据页的范围值从而不能直接定位到要找的那条记录

所以只需要在数据表的一个字段上建立聚集索引就可以了,而究竟要在哪一个字段上建立聚集索引大家一定好好斟酌,本人建议那一个字段在order by中经常要排序的

因为数据页都已经按照聚集索引的第一个字段排好序的了

而不像非聚集索引的索引页跟数据表的记录一一对应,扫描的时候扫描索引页的每一行

大家可以对比一下聚集索引和非聚集索引页的结构

聚集索引页的结构

SQLSERVER聚集索引与非聚集索引的再次研究(上)

非聚集索引页的结构

SQLSERVER聚集索引与非聚集索引的再次研究(上)

非聚集索引页面的结构会在SQLSERVER聚集索引与非聚集索引的再次研究(下)里讲到

 ---------------------------------------------------------华丽的分割线-----------------------------------------------------

 由于主键不允许重复值,那么就在表上创建一个不唯一的聚集索引,有人说在重复值很多的列上建立聚集索引没有意义

创建Department5表  在Company字段上建立聚集索引,Company字段的值全部都是"中国你好有限公司XX分公司"

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 --只有聚集索引
 2 USE [pratice]
 3 GO
 4 CREATE TABLE Department5
 5 (
 6   DepartmentID INT IDENTITY(1, 1) NOT NULL ,
 7   Name NVARCHAR(200) NOT NULL ,
 8   GroupName NVARCHAR(200) NOT NULL ,
 9   Company NVARCHAR(300) ,
10   ModifiedDate DATETIME NOT NULL  DEFAULT ( GETDATE() ) 
11 )
12 
13 CREATE CLUSTERED INDEX CL_Company ON [dbo].[Department5]([Company] ASC)
14 
15 --DROP TABLE [dbo].[Department5]
16 
17 DECLARE @i INT
18 SET @i=1
19 WHILE @i < 10000
20     BEGIN
21         INSERT  INTO Department5 ( name, [Company], groupname )
22         VALUES  ( 销售部+CAST(@i AS VARCHAR(200)), 中国你好有限公司XX分公司, 销售组 )
23         SET @i = @i + 1
24     END
View Code

 

SQLSERVER聚集索引与非聚集索引的再次研究(上)
1 --TRUNCATE TABLE [dbo].[DBCCResult]
2 INSERT INTO DBCCResult EXEC (DBCC IND(pratice,Department5,-1) )
3 
4 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 
5 
6 DBCC PAGE([pratice],1,14516,3)
7 GO
View Code

 SQLSERVER聚集索引与非聚集索引的再次研究(上)

在Department3表的时候讲到列(uniquifier),为什麽有主键的表没有这个列,而聚集索引的表有这个列,原因在于

主键列不能有重复值,必须是唯一的,而聚集索引允许有重复值,所以聚集索引需要增加列(uniquifier)来区分重复值

而且可以看到这里uniquifier列是没有规律的,不像Department表每隔120行记录在索引页里标记一行

看一下执行计划和执行结果

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 SET STATISTICS TIME ON
 2 SELECT * FROM [dbo].[Department5] WHERE [Company]=中国你好有限公司XX分公司 AND [DepartmentID]=241 
 3 
 4 SQL Server 分析和编译时间: 
 5    CPU 时间 = 0 毫秒,占用时间 = 0 毫秒。
 6 
 7 (1 行受影响)
 8 
 9 SQL Server 执行时间:
10    CPU 时间 = 0 毫秒,占用时间 = 0 毫秒。
SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

1 SET STATISTICS TIME ON
2 SELECT * FROM [dbo].[Department5] WHERE name=销售部106 AND [DepartmentID]=106  --聚集索引扫描
3 SQL Server 执行时间:
4    CPU 时间 = 0 毫秒,占用时间 = 0 毫秒。

SQLSERVER聚集索引与非聚集索引的再次研究(上)

至于应不应该在重复值很多的列上建立聚集索引我这里也不敢妄下判断,因为实际环境和这里的测试环境不一样

在MSDN中的解释:http://msdn.microsoft.com/zh-cn/library/ms177484(v=SQL.105).aspx

如果聚集索引不是唯一的索引,SQL Server 将添加在内部生成的值(称为唯一值)以使所有重复键唯一。此四字节的值对于用户不可见

还有一个,看一下叶子节点中的数据页,在每个数据页的每行记录中都有

Slot 101 Column 0 Offset 0x1d Length 4

UNIQUIFIER = 206 

因为需要标记索引列中的唯一,所以需要在每行记录中增加一列UNIQUIFIER ,但是这一列在select * 表中数据的时候是select不出来的

还有人说UNIQUIFIER 是一个可变长度的字段,但是Length 4已经说明了是一个占用4字节的字段

SQLSERVER聚集索引与非聚集索引的再次研究(上)
   1 PAGE: (1:14517)
   2 
   3 
   4 BUFFER:
   5 
   6 
   7 BUF @0x03EC9D64
   8 
   9 bpage = 0x1A096000                   bhash = 0x00000000                   bpageno = (1:14517)
  10 bdbid = 5                            breferences = 0                      bUse1 = 4722
  11 bstat = 0x3c00009                    blog = 0x32159                       bnext = 0x00000000
  12 
  13 PAGE HEADER:
  14 
  15 
  16 Page @0x1A096000
  17 
  18 m_pageId = (1:14517)                 m_headerVersion = 1                  m_type = 1
  19 m_typeFlagBits = 0x4                 m_level = 0                          m_flagBits = 0x200
  20 m_objId (AllocUnitId.idObj) = 317    m_indexId (AllocUnitId.idInd) = 256  
  21 Metadata: AllocUnitId = 72057594058702848                                 
  22 Metadata: PartitionId = 72057594049462272                                 Metadata: IndexId = 1
  23 Metadata: ObjectId = 1022626686      m_prevPage = (1:14514)               m_nextPage = (1:14518)
  24 pminlen = 16                         m_slotCnt = 102                      m_freeCnt = 38
  25 m_freeData = 7950                    m_reservedCnt = 0                    m_lsn = (2568:5252:8)
  26 m_xactReserved = 0                   m_xdesId = (0:0)                     m_ghostRecCnt = 0
  27 m_tornBits = -1007571449             
  28 
  29 Allocation Status
  30 
  31 GAM (1:2) = ALLOCATED                SGAM (1:3) = NOT ALLOCATED           
  32 PFS (1:8088) = 0x60 MIXED_EXT ALLOCATED   0_PCT_FULL                      DIFF (1:6) = NOT CHANGED
  33 ML (1:7) = NOT MIN_LOGGED            
  34 

  35 Slot 0 Offset 0x60 Length 77
  36 
  37 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
  38 
  39 Memory Dump @0x0A64C060
  40 
  41 00000000:   30001000 6a000000 d42e7c01 fea10000 ?0...j.....|.....         
  42 00000010:   0600c004 0021003b 0047004d 00690000 ?.....!.;.G.M.i..         
  43 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
  44 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
  45 00000040:   90310030 00360000 952e55c4 7e????????.1.0.6....U.~            
  46 
  47 Slot 0 Column 0 Offset 0x1d Length 4
  48 
  49 UNIQUIFIER = 105                     
  50 
  51 Slot 0 Column 1 Offset 0x21 Length 26
  52 
  53 Company = 中国你好有限公司XX分公司   
  54 
  55 Slot 0 Column 2 Offset 0x4 Length 4
  56 
  57 DepartmentID = 106                   
  58 
  59 Slot 0 Column 3 Offset 0x3b Length 12
  60 
  61 Name = 销售部106                     
  62 
  63 Slot 0 Column 4 Offset 0x47 Length 6
  64 
  65 GroupName = 销售组                   
  66 
  67 Slot 0 Column 5 Offset 0x8 Length 8
  68 
  69 ModifiedDate = 07 17 2013 11:04PM    
  70 
  71 Slot 1 Offset 0xad Length 77
  72 
  73 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
  74 
  75 Memory Dump @0x0A64C0AD
  76 
  77 00000000:   30001000 6b000000 d42e7c01 fea10000 ?0...k.....|.....         
  78 00000010:   0600c004 0021003b 0047004d 006a0000 ?.....!.;.G.M.j..         
  79 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
  80 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
  81 00000040:   90310030 00370000 952e55c4 7e????????.1.0.7....U.~            
  82 
  83 Slot 1 Column 0 Offset 0x1d Length 4
  84 
  85 UNIQUIFIER = 106                     
  86 
  87 Slot 1 Column 1 Offset 0x21 Length 26
  88 
  89 Company = 中国你好有限公司XX分公司   
  90 
  91 Slot 1 Column 2 Offset 0x4 Length 4
  92 
  93 DepartmentID = 107                   
  94 
  95 Slot 1 Column 3 Offset 0x3b Length 12
  96 
  97 Name = 销售部107                     
  98 
  99 Slot 1 Column 4 Offset 0x47 Length 6
 100 
 101 GroupName = 销售组                   
 102 
 103 Slot 1 Column 5 Offset 0x8 Length 8
 104 
 105 ModifiedDate = 07 17 2013 11:04PM    
 106 
 107 Slot 2 Offset 0xfa Length 77
 108 
 109 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 110 
 111 Memory Dump @0x0A64C0FA
 112 
 113 00000000:   30001000 6c000000 d42e7c01 fea10000 ?0...l.....|.....         
 114 00000010:   0600c004 0021003b 0047004d 006b0000 ?.....!.;.G.M.k..         
 115 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 116 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 117 00000040:   90310030 00380000 952e55c4 7e????????.1.0.8....U.~            
 118 
 119 Slot 2 Column 0 Offset 0x1d Length 4
 120 
 121 UNIQUIFIER = 107                     
 122 
 123 Slot 2 Column 1 Offset 0x21 Length 26
 124 
 125 Company = 中国你好有限公司XX分公司   
 126 
 127 Slot 2 Column 2 Offset 0x4 Length 4
 128 
 129 DepartmentID = 108                   
 130 
 131 Slot 2 Column 3 Offset 0x3b Length 12
 132 
 133 Name = 销售部108                     
 134 
 135 Slot 2 Column 4 Offset 0x47 Length 6
 136 
 137 GroupName = 销售组                   
 138 
 139 Slot 2 Column 5 Offset 0x8 Length 8
 140 
 141 ModifiedDate = 07 17 2013 11:04PM    
 142 
 143 Slot 3 Offset 0x147 Length 77
 144 
 145 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 146 
 147 Memory Dump @0x0A64C147
 148 
 149 00000000:   30001000 6d000000 d42e7c01 fea10000 ?0...m.....|.....         
 150 00000010:   0600c004 0021003b 0047004d 006c0000 ?.....!.;.G.M.l..         
 151 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 152 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 153 00000040:   90310030 00390000 952e55c4 7e????????.1.0.9....U.~            
 154 
 155 Slot 3 Column 0 Offset 0x1d Length 4
 156 
 157 UNIQUIFIER = 108                     
 158 
 159 Slot 3 Column 1 Offset 0x21 Length 26
 160 
 161 Company = 中国你好有限公司XX分公司   
 162 
 163 Slot 3 Column 2 Offset 0x4 Length 4
 164 
 165 DepartmentID = 109                   
 166 
 167 Slot 3 Column 3 Offset 0x3b Length 12
 168 
 169 Name = 销售部109                     
 170 
 171 Slot 3 Column 4 Offset 0x47 Length 6
 172 
 173 GroupName = 销售组                   
 174 
 175 Slot 3 Column 5 Offset 0x8 Length 8
 176 
 177 ModifiedDate = 07 17 2013 11:04PM    
 178 
 179 Slot 4 Offset 0x194 Length 77
 180 
 181 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 182 
 183 Memory Dump @0x0A64C194
 184 
 185 00000000:   30001000 6e000000 d42e7c01 fea10000 ?0...n.....|.....         
 186 00000010:   0600c004 0021003b 0047004d 006d0000 ?.....!.;.G.M.m..         
 187 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 188 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 189 00000040:   90310031 00300000 952e55c4 7e????????.1.1.0....U.~            
 190 
 191 Slot 4 Column 0 Offset 0x1d Length 4
 192 
 193 UNIQUIFIER = 109                     
 194 
 195 Slot 4 Column 1 Offset 0x21 Length 26
 196 
 197 Company = 中国你好有限公司XX分公司   
 198 
 199 Slot 4 Column 2 Offset 0x4 Length 4
 200 
 201 DepartmentID = 110                   
 202 
 203 Slot 4 Column 3 Offset 0x3b Length 12
 204 
 205 Name = 销售部110                     
 206 
 207 Slot 4 Column 4 Offset 0x47 Length 6
 208 
 209 GroupName = 销售组                   
 210 
 211 Slot 4 Column 5 Offset 0x8 Length 8
 212 
 213 ModifiedDate = 07 17 2013 11:04PM    
 214 
 215 Slot 5 Offset 0x1e1 Length 77
 216 
 217 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 218 
 219 Memory Dump @0x0A64C1E1
 220 
 221 00000000:   30001000 6f000000 d42e7c01 fea10000 ?0...o.....|.....         
 222 00000010:   0600c004 0021003b 0047004d 006e0000 ?.....!.;.G.M.n..         
 223 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 224 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 225 00000040:   90310031 00310000 952e55c4 7e????????.1.1.1....U.~            
 226 
 227 Slot 5 Column 0 Offset 0x1d Length 4
 228 
 229 UNIQUIFIER = 110                     
 230 
 231 Slot 5 Column 1 Offset 0x21 Length 26
 232 
 233 Company = 中国你好有限公司XX分公司   
 234 
 235 Slot 5 Column 2 Offset 0x4 Length 4
 236 
 237 DepartmentID = 111                   
 238 
 239 Slot 5 Column 3 Offset 0x3b Length 12
 240 
 241 Name = 销售部111                     
 242 
 243 Slot 5 Column 4 Offset 0x47 Length 6
 244 
 245 GroupName = 销售组                   
 246 
 247 Slot 5 Column 5 Offset 0x8 Length 8
 248 
 249 ModifiedDate = 07 17 2013 11:04PM    
 250 
 251 Slot 6 Offset 0x22e Length 77
 252 
 253 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 254 
 255 Memory Dump @0x0A64C22E
 256 
 257 00000000:   30001000 70000000 d42e7c01 fea10000 ?0...p.....|.....         
 258 00000010:   0600c004 0021003b 0047004d 006f0000 ?.....!.;.G.M.o..         
 259 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 260 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 261 00000040:   90310031 00320000 952e55c4 7e????????.1.1.2....U.~            
 262 
 263 Slot 6 Column 0 Offset 0x1d Length 4
 264 
 265 UNIQUIFIER = 111                     
 266 
 267 Slot 6 Column 1 Offset 0x21 Length 26
 268 
 269 Company = 中国你好有限公司XX分公司   
 270 
 271 Slot 6 Column 2 Offset 0x4 Length 4
 272 
 273 DepartmentID = 112                   
 274 
 275 Slot 6 Column 3 Offset 0x3b Length 12
 276 
 277 Name = 销售部112                     
 278 
 279 Slot 6 Column 4 Offset 0x47 Length 6
 280 
 281 GroupName = 销售组                   
 282 
 283 Slot 6 Column 5 Offset 0x8 Length 8
 284 
 285 ModifiedDate = 07 17 2013 11:04PM    
 286 
 287 Slot 7 Offset 0x27b Length 77
 288 
 289 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 290 
 291 Memory Dump @0x0A64C27B
 292 
 293 00000000:   30001000 71000000 d42e7c01 fea10000 ?0...q.....|.....         
 294 00000010:   0600c004 0021003b 0047004d 00700000 ?.....!.;.G.M.p..         
 295 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 296 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 297 00000040:   90310031 00330000 952e55c4 7e????????.1.1.3....U.~            
 298 
 299 Slot 7 Column 0 Offset 0x1d Length 4
 300 
 301 UNIQUIFIER = 112                     
 302 
 303 Slot 7 Column 1 Offset 0x21 Length 26
 304 
 305 Company = 中国你好有限公司XX分公司   
 306 
 307 Slot 7 Column 2 Offset 0x4 Length 4
 308 
 309 DepartmentID = 113                   
 310 
 311 Slot 7 Column 3 Offset 0x3b Length 12
 312 
 313 Name = 销售部113                     
 314 
 315 Slot 7 Column 4 Offset 0x47 Length 6
 316 
 317 GroupName = 销售组                   
 318 
 319 Slot 7 Column 5 Offset 0x8 Length 8
 320 
 321 ModifiedDate = 07 17 2013 11:04PM    
 322 
 323 Slot 8 Offset 0x2c8 Length 77
 324 
 325 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 326 
 327 Memory Dump @0x0A64C2C8
 328 
 329 00000000:   30001000 72000000 d42e7c01 fea10000 ?0...r.....|.....         
 330 00000010:   0600c004 0021003b 0047004d 00710000 ?.....!.;.G.M.q..         
 331 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 332 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 333 00000040:   90310031 00340000 952e55c4 7e????????.1.1.4....U.~            
 334 
 335 Slot 8 Column 0 Offset 0x1d Length 4
 336 
 337 UNIQUIFIER = 113                     
 338 
 339 Slot 8 Column 1 Offset 0x21 Length 26
 340 
 341 Company = 中国你好有限公司XX分公司   
 342 
 343 Slot 8 Column 2 Offset 0x4 Length 4
 344 
 345 DepartmentID = 114                   
 346 
 347 Slot 8 Column 3 Offset 0x3b Length 12
 348 
 349 Name = 销售部114                     
 350 
 351 Slot 8 Column 4 Offset 0x47 Length 6
 352 
 353 GroupName = 销售组                   
 354 
 355 Slot 8 Column 5 Offset 0x8 Length 8
 356 
 357 ModifiedDate = 07 17 2013 11:04PM    
 358 
 359 Slot 9 Offset 0x315 Length 77
 360 
 361 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 362 
 363 Memory Dump @0x0A64C315
 364 
 365 00000000:   30001000 73000000 d42e7c01 fea10000 ?0...s.....|.....         
 366 00000010:   0600c004 0021003b 0047004d 00720000 ?.....!.;.G.M.r..         
 367 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 368 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 369 00000040:   90310031 00350000 952e55c4 7e????????.1.1.5....U.~            
 370 
 371 Slot 9 Column 0 Offset 0x1d Length 4
 372 
 373 UNIQUIFIER = 114                     
 374 
 375 Slot 9 Column 1 Offset 0x21 Length 26
 376 
 377 Company = 中国你好有限公司XX分公司   
 378 
 379 Slot 9 Column 2 Offset 0x4 Length 4
 380 
 381 DepartmentID = 115                   
 382 
 383 Slot 9 Column 3 Offset 0x3b Length 12
 384 
 385 Name = 销售部115                     
 386 
 387 Slot 9 Column 4 Offset 0x47 Length 6
 388 
 389 GroupName = 销售组                   
 390 
 391 Slot 9 Column 5 Offset 0x8 Length 8
 392 
 393 ModifiedDate = 07 17 2013 11:04PM    
 394 
 395 Slot 10 Offset 0x362 Length 77
 396 
 397 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 398 
 399 Memory Dump @0x0A64C362
 400 
 401 00000000:   30001000 74000000 d52e7c01 fea10000 ?0...t.....|.....         
 402 00000010:   0600c004 0021003b 0047004d 00730000 ?.....!.;.G.M.s..         
 403 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 404 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 405 00000040:   90310031 00360000 952e55c4 7e????????.1.1.6....U.~            
 406 
 407 Slot 10 Column 0 Offset 0x1d Length 4
 408 
 409 UNIQUIFIER = 115                     
 410 
 411 Slot 10 Column 1 Offset 0x21 Length 26
 412 
 413 Company = 中国你好有限公司XX分公司   
 414 
 415 Slot 10 Column 2 Offset 0x4 Length 4
 416 
 417 DepartmentID = 116                   
 418 
 419 Slot 10 Column 3 Offset 0x3b Length 12
 420 
 421 Name = 销售部116                     
 422 
 423 Slot 10 Column 4 Offset 0x47 Length 6
 424 
 425 GroupName = 销售组                   
 426 
 427 Slot 10 Column 5 Offset 0x8 Length 8
 428 
 429 ModifiedDate = 07 17 2013 11:04PM    
 430 
 431 Slot 11 Offset 0x3af Length 77
 432 
 433 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 434 
 435 Memory Dump @0x0A64C3AF
 436 
 437 00000000:   30001000 75000000 d52e7c01 fea10000 ?0...u.....|.....         
 438 00000010:   0600c004 0021003b 0047004d 00740000 ?.....!.;.G.M.t..         
 439 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 440 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 441 00000040:   90310031 00370000 952e55c4 7e????????.1.1.7....U.~            
 442 
 443 Slot 11 Column 0 Offset 0x1d Length 4
 444 
 445 UNIQUIFIER = 116                     
 446 
 447 Slot 11 Column 1 Offset 0x21 Length 26
 448 
 449 Company = 中国你好有限公司XX分公司   
 450 
 451 Slot 11 Column 2 Offset 0x4 Length 4
 452 
 453 DepartmentID = 117                   
 454 
 455 Slot 11 Column 3 Offset 0x3b Length 12
 456 
 457 Name = 销售部117                     
 458 
 459 Slot 11 Column 4 Offset 0x47 Length 6
 460 
 461 GroupName = 销售组                   
 462 
 463 Slot 11 Column 5 Offset 0x8 Length 8
 464 
 465 ModifiedDate = 07 17 2013 11:04PM    
 466 
 467 Slot 12 Offset 0x3fc Length 77
 468 
 469 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 470 
 471 Memory Dump @0x0A64C3FC
 472 
 473 00000000:   30001000 76000000 d52e7c01 fea10000 ?0...v.....|.....         
 474 00000010:   0600c004 0021003b 0047004d 00750000 ?.....!.;.G.M.u..         
 475 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 476 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 477 00000040:   90310031 00380000 952e55c4 7e????????.1.1.8....U.~            
 478 
 479 Slot 12 Column 0 Offset 0x1d Length 4
 480 
 481 UNIQUIFIER = 117                     
 482 
 483 Slot 12 Column 1 Offset 0x21 Length 26
 484 
 485 Company = 中国你好有限公司XX分公司   
 486 
 487 Slot 12 Column 2 Offset 0x4 Length 4
 488 
 489 DepartmentID = 118                   
 490 
 491 Slot 12 Column 3 Offset 0x3b Length 12
 492 
 493 Name = 销售部118                     
 494 
 495 Slot 12 Column 4 Offset 0x47 Length 6
 496 
 497 GroupName = 销售组                   
 498 
 499 Slot 12 Column 5 Offset 0x8 Length 8
 500 
 501 ModifiedDate = 07 17 2013 11:04PM    
 502 
 503 Slot 13 Offset 0x449 Length 77
 504 
 505 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 506 
 507 Memory Dump @0x0A64C449
 508 
 509 00000000:   30001000 77000000 d52e7c01 fea10000 ?0...w.....|.....         
 510 00000010:   0600c004 0021003b 0047004d 00760000 ?.....!.;.G.M.v..         
 511 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 512 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 513 00000040:   90310031 00390000 952e55c4 7e????????.1.1.9....U.~            
 514 
 515 Slot 13 Column 0 Offset 0x1d Length 4
 516 
 517 UNIQUIFIER = 118                     
 518 
 519 Slot 13 Column 1 Offset 0x21 Length 26
 520 
 521 Company = 中国你好有限公司XX分公司   
 522 
 523 Slot 13 Column 2 Offset 0x4 Length 4
 524 
 525 DepartmentID = 119                   
 526 
 527 Slot 13 Column 3 Offset 0x3b Length 12
 528 
 529 Name = 销售部119                     
 530 
 531 Slot 13 Column 4 Offset 0x47 Length 6
 532 
 533 GroupName = 销售组                   
 534 
 535 Slot 13 Column 5 Offset 0x8 Length 8
 536 
 537 ModifiedDate = 07 17 2013 11:04PM    
 538 
 539 Slot 14 Offset 0x496 Length 77
 540 
 541 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 542 
 543 Memory Dump @0x0A64C496
 544 
 545 00000000:   30001000 78000000 d52e7c01 fea10000 ?0...x.....|.....         
 546 00000010:   0600c004 0021003b 0047004d 00770000 ?.....!.;.G.M.w..         
 547 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 548 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 549 00000040:   90310032 00300000 952e55c4 7e????????.1.2.0....U.~            
 550 
 551 Slot 14 Column 0 Offset 0x1d Length 4
 552 
 553 UNIQUIFIER = 119                     
 554 
 555 Slot 14 Column 1 Offset 0x21 Length 26
 556 
 557 Company = 中国你好有限公司XX分公司   
 558 
 559 Slot 14 Column 2 Offset 0x4 Length 4
 560 
 561 DepartmentID = 120                   
 562 
 563 Slot 14 Column 3 Offset 0x3b Length 12
 564 
 565 Name = 销售部120                     
 566 
 567 Slot 14 Column 4 Offset 0x47 Length 6
 568 
 569 GroupName = 销售组                   
 570 
 571 Slot 14 Column 5 Offset 0x8 Length 8
 572 
 573 ModifiedDate = 07 17 2013 11:04PM    
 574 
 575 Slot 15 Offset 0x4e3 Length 77
 576 
 577 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 578 
 579 Memory Dump @0x0A64C4E3
 580 
 581 00000000:   30001000 79000000 d52e7c01 fea10000 ?0...y.....|.....         
 582 00000010:   0600c004 0021003b 0047004d 00780000 ?.....!.;.G.M.x..         
 583 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 584 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 585 00000040:   90310032 00310000 952e55c4 7e????????.1.2.1....U.~            
 586 
 587 Slot 15 Column 0 Offset 0x1d Length 4
 588 
 589 UNIQUIFIER = 120                     
 590 
 591 Slot 15 Column 1 Offset 0x21 Length 26
 592 
 593 Company = 中国你好有限公司XX分公司   
 594 
 595 Slot 15 Column 2 Offset 0x4 Length 4
 596 
 597 DepartmentID = 121                   
 598 
 599 Slot 15 Column 3 Offset 0x3b Length 12
 600 
 601 Name = 销售部121                     
 602 
 603 Slot 15 Column 4 Offset 0x47 Length 6
 604 
 605 GroupName = 销售组                   
 606 
 607 Slot 15 Column 5 Offset 0x8 Length 8
 608 
 609 ModifiedDate = 07 17 2013 11:04PM    
 610 
 611 Slot 16 Offset 0x530 Length 77
 612 
 613 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 614 
 615 Memory Dump @0x0A64C530
 616 
 617 00000000:   30001000 7a000000 d52e7c01 fea10000 ?0...z.....|.....         
 618 00000010:   0600c004 0021003b 0047004d 00790000 ?.....!.;.G.M.y..         
 619 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 620 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 621 00000040:   90310032 00320000 952e55c4 7e????????.1.2.2....U.~            
 622 
 623 Slot 16 Column 0 Offset 0x1d Length 4
 624 
 625 UNIQUIFIER = 121                     
 626 
 627 Slot 16 Column 1 Offset 0x21 Length 26
 628 
 629 Company = 中国你好有限公司XX分公司   
 630 
 631 Slot 16 Column 2 Offset 0x4 Length 4
 632 
 633 DepartmentID = 122                   
 634 
 635 Slot 16 Column 3 Offset 0x3b Length 12
 636 
 637 Name = 销售部122                     
 638 
 639 Slot 16 Column 4 Offset 0x47 Length 6
 640 
 641 GroupName = 销售组                   
 642 
 643 Slot 16 Column 5 Offset 0x8 Length 8
 644 
 645 ModifiedDate = 07 17 2013 11:04PM    
 646 
 647 Slot 17 Offset 0x57d Length 77
 648 
 649 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 650 
 651 Memory Dump @0x0A64C57D
 652 
 653 00000000:   30001000 7b000000 d52e7c01 fea10000 ?0...{.....|.....         
 654 00000010:   0600c004 0021003b 0047004d 007a0000 ?.....!.;.G.M.z..         
 655 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         

 656 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 657 00000040:   90310032 00330000 952e55c4 7e????????.1.2.3....U.~            
 658 
 659 Slot 17 Column 0 Offset 0x1d Length 4
 660 
 661 UNIQUIFIER = 122                     
 662 
 663 Slot 17 Column 1 Offset 0x21 Length 26
 664 
 665 Company = 中国你好有限公司XX分公司   
 666 
 667 Slot 17 Column 2 Offset 0x4 Length 4
 668 
 669 DepartmentID = 123                   
 670 
 671 Slot 17 Column 3 Offset 0x3b Length 12
 672 
 673 Name = 销售部123                     
 674 
 675 Slot 17 Column 4 Offset 0x47 Length 6
 676 
 677 GroupName = 销售组                   
 678 
 679 Slot 17 Column 5 Offset 0x8 Length 8
 680 
 681 ModifiedDate = 07 17 2013 11:04PM    
 682 
 683 Slot 18 Offset 0x5ca Length 77
 684 
 685 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 686 
 687 Memory Dump @0x0A64C5CA
 688 
 689 00000000:   30001000 7c000000 d52e7c01 fea10000 ?0...|.....|.....         
 690 00000010:   0600c004 0021003b 0047004d 007b0000 ?.....!.;.G.M.{..         
 691 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 692 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 693 00000040:   90310032 00340000 952e55c4 7e????????.1.2.4....U.~            
 694 
 695 Slot 18 Column 0 Offset 0x1d Length 4
 696 
 697 UNIQUIFIER = 123                     
 698 
 699 Slot 18 Column 1 Offset 0x21 Length 26
 700 
 701 Company = 中国你好有限公司XX分公司   
 702 
 703 Slot 18 Column 2 Offset 0x4 Length 4
 704 
 705 DepartmentID = 124                   
 706 
 707 Slot 18 Column 3 Offset 0x3b Length 12
 708 
 709 Name = 销售部124                     
 710 
 711 Slot 18 Column 4 Offset 0x47 Length 6
 712 
 713 GroupName = 销售组                   
 714 
 715 Slot 18 Column 5 Offset 0x8 Length 8
 716 
 717 ModifiedDate = 07 17 2013 11:04PM    
 718 
 719 Slot 19 Offset 0x617 Length 77
 720 
 721 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 722 
 723 Memory Dump @0x0A64C617
 724 
 725 00000000:   30001000 7d000000 d52e7c01 fea10000 ?0...}.....|.....         
 726 00000010:   0600c004 0021003b 0047004d 007c0000 ?.....!.;.G.M.|..         
 727 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 728 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 729 00000040:   90310032 00350000 952e55c4 7e????????.1.2.5....U.~            
 730 
 731 Slot 19 Column 0 Offset 0x1d Length 4
 732 
 733 UNIQUIFIER = 124                     
 734 
 735 Slot 19 Column 1 Offset 0x21 Length 26
 736 
 737 Company = 中国你好有限公司XX分公司   
 738 
 739 Slot 19 Column 2 Offset 0x4 Length 4
 740 
 741 DepartmentID = 125                   
 742 
 743 Slot 19 Column 3 Offset 0x3b Length 12
 744 
 745 Name = 销售部125                     
 746 
 747 Slot 19 Column 4 Offset 0x47 Length 6
 748 
 749 GroupName = 销售组                   
 750 
 751 Slot 19 Column 5 Offset 0x8 Length 8
 752 
 753 ModifiedDate = 07 17 2013 11:04PM    
 754 
 755 Slot 20 Offset 0x664 Length 77
 756 
 757 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 758 
 759 Memory Dump @0x0A64C664
 760 
 761 00000000:   30001000 7e000000 d52e7c01 fea10000 ?0...~.....|.....         
 762 00000010:   0600c004 0021003b 0047004d 007d0000 ?.....!.;.G.M.}..         
 763 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 764 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 765 00000040:   90310032 00360000 952e55c4 7e????????.1.2.6....U.~            
 766 
 767 Slot 20 Column 0 Offset 0x1d Length 4
 768 
 769 UNIQUIFIER = 125                     
 770 
 771 Slot 20 Column 1 Offset 0x21 Length 26
 772 
 773 Company = 中国你好有限公司XX分公司   
 774 
 775 Slot 20 Column 2 Offset 0x4 Length 4
 776 
 777 DepartmentID = 126                   
 778 
 779 Slot 20 Column 3 Offset 0x3b Length 12
 780 
 781 Name = 销售部126                     
 782 
 783 Slot 20 Column 4 Offset 0x47 Length 6
 784 
 785 GroupName = 销售组                   
 786 
 787 Slot 20 Column 5 Offset 0x8 Length 8
 788 
 789 ModifiedDate = 07 17 2013 11:04PM    
 790 
 791 Slot 21 Offset 0x6b1 Length 77
 792 
 793 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 794 
 795 Memory Dump @0x0A64C6B1
 796 
 797 00000000:   30001000 7f000000 d52e7c01 fea10000 ?0.........|.....         
 798 00000010:   0600c004 0021003b 0047004d 007e0000 ?.....!.;.G.M.~..         
 799 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 800 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 801 00000040:   90310032 00370000 952e55c4 7e????????.1.2.7....U.~            
 802 
 803 Slot 21 Column 0 Offset 0x1d Length 4
 804 
 805 UNIQUIFIER = 126                     
 806 
 807 Slot 21 Column 1 Offset 0x21 Length 26
 808 
 809 Company = 中国你好有限公司XX分公司   
 810 
 811 Slot 21 Column 2 Offset 0x4 Length 4
 812 
 813 DepartmentID = 127                   
 814 
 815 Slot 21 Column 3 Offset 0x3b Length 12
 816 
 817 Name = 销售部127                     
 818 
 819 Slot 21 Column 4 Offset 0x47 Length 6
 820 
 821 GroupName = 销售组                   
 822 
 823 Slot 21 Column 5 Offset 0x8 Length 8
 824 
 825 ModifiedDate = 07 17 2013 11:04PM    
 826 
 827 Slot 22 Offset 0x6fe Length 77
 828 
 829 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 830 
 831 Memory Dump @0x0A64C6FE
 832 
 833 00000000:   30001000 80000000 d52e7c01 fea10000 ?0.........|.....         
 834 00000010:   0600c004 0021003b 0047004d 007f0000 ?.....!.;.G.M....         
 835 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 836 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 837 00000040:   90310032 00380000 952e55c4 7e????????.1.2.8....U.~            
 838 
 839 Slot 22 Column 0 Offset 0x1d Length 4
 840 
 841 UNIQUIFIER = 127                     
 842 
 843 Slot 22 Column 1 Offset 0x21 Length 26
 844 
 845 Company = 中国你好有限公司XX分公司   
 846 
 847 Slot 22 Column 2 Offset 0x4 Length 4
 848 
 849 DepartmentID = 128                   
 850 
 851 Slot 22 Column 3 Offset 0x3b Length 12
 852 
 853 Name = 销售部128                     
 854 
 855 Slot 22 Column 4 Offset 0x47 Length 6
 856 
 857 GroupName = 销售组                   
 858 
 859 Slot 22 Column 5 Offset 0x8 Length 8
 860 
 861 ModifiedDate = 07 17 2013 11:04PM    
 862 
 863 Slot 23 Offset 0x74b Length 77
 864 
 865 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 866 
 867 Memory Dump @0x0A64C74B
 868 
 869 00000000:   30001000 81000000 d52e7c01 fea10000 ?0.........|.....         
 870 00000010:   0600c004 0021003b 0047004d 00800000 ?.....!.;.G.M....         
 871 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 872 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 873 00000040:   90310032 00390000 952e55c4 7e????????.1.2.9....U.~            
 874 
 875 Slot 23 Column 0 Offset 0x1d Length 4
 876 
 877 UNIQUIFIER = 128                     
 878 
 879 Slot 23 Column 1 Offset 0x21 Length 26
 880 
 881 Company = 中国你好有限公司XX分公司   
 882 
 883 Slot 23 Column 2 Offset 0x4 Length 4
 884 
 885 DepartmentID = 129                   
 886 
 887 Slot 23 Column 3 Offset 0x3b Length 12
 888 
 889 Name = 销售部129                     
 890 
 891 Slot 23 Column 4 Offset 0x47 Length 6
 892 
 893 GroupName = 销售组                   
 894 
 895 Slot 23 Column 5 Offset 0x8 Length 8
 896 
 897 ModifiedDate = 07 17 2013 11:04PM    
 898 
 899 Slot 24 Offset 0x798 Length 77
 900 
 901 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 902 
 903 Memory Dump @0x0A64C798
 904 
 905 00000000:   30001000 82000000 d52e7c01 fea10000 ?0.........|.....         
 906 00000010:   0600c004 0021003b 0047004d 00810000 ?.....!.;.G.M....         
 907 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 908 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 909 00000040:   90310033 00300000 952e55c4 7e????????.1.3.0....U.~            
 910 
 911 Slot 24 Column 0 Offset 0x1d Length 4
 912 
 913 UNIQUIFIER = 129                     
 914 
 915 Slot 24 Column 1 Offset 0x21 Length 26
 916 
 917 Company = 中国你好有限公司XX分公司   
 918 
 919 Slot 24 Column 2 Offset 0x4 Length 4
 920 
 921 DepartmentID = 130                   
 922 
 923 Slot 24 Column 3 Offset 0x3b Length 12
 924 
 925 Name = 销售部130                     
 926 
 927 Slot 24 Column 4 Offset 0x47 Length 6
 928 
 929 GroupName = 销售组                   
 930 
 931 Slot 24 Column 5 Offset 0x8 Length 8
 932 
 933 ModifiedDate = 07 17 2013 11:04PM    
 934 
 935 Slot 25 Offset 0x7e5 Length 77
 936 
 937 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 938 
 939 Memory Dump @0x0A64C7E5
 940 
 941 00000000:   30001000 83000000 d52e7c01 fea10000 ?0.........|.....         
 942 00000010:   0600c004 0021003b 0047004d 00820000 ?.....!.;.G.M....         
 943 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 944 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 945 00000040:   90310033 00310000 952e55c4 7e????????.1.3.1....U.~            
 946 
 947 Slot 25 Column 0 Offset 0x1d Length 4
 948 
 949 UNIQUIFIER = 130                     
 950 
 951 Slot 25 Column 1 Offset 0x21 Length 26
 952 
 953 Company = 中国你好有限公司XX分公司   
 954 
 955 Slot 25 Column 2 Offset 0x4 Length 4
 956 
 957 DepartmentID = 131                   
 958 
 959 Slot 25 Column 3 Offset 0x3b Length 12
 960 
 961 Name = 销售部131                     
 962 
 963 Slot 25 Column 4 Offset 0x47 Length 6
 964 
 965 GroupName = 销售组                   
 966 
 967 Slot 25 Column 5 Offset 0x8 Length 8
 968 
 969 ModifiedDate = 07 17 2013 11:04PM    
 970 
 971 Slot 26 Offset 0x832 Length 77
 972 
 973 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
 974 
 975 Memory Dump @0x0A64C832
 976 
 977 00000000:   30001000 84000000 d52e7c01 fea10000 ?0.........|.....         
 978 00000010:   0600c004 0021003b 0047004d 00830000 ?.....!.;.G.M....         
 979 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
 980 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
 981 00000040:   90310033 00320000 952e55c4 7e????????.1.3.2....U.~            
 982 
 983 Slot 26 Column 0 Offset 0x1d Length 4
 984 
 985 UNIQUIFIER = 131                     
 986 
 987 Slot 26 Column 1 Offset 0x21 Length 26
 988 
 989 Company = 中国你好有限公司XX分公司   
 990 
 991 Slot 26 Column 2 Offset 0x4 Length 4
 992 
 993 DepartmentID = 132                   
 994 
 995 Slot 26 Column 3 Offset 0x3b Length 12
 996 
 997 Name = 销售部132                     
 998 
 999 Slot 26 Column 4 Offset 0x47 Length 6
1000 
1001 GroupName = 销售组                   
1002 
1003 Slot 26 Column 5 Offset 0x8 Length 8
1004 
1005 ModifiedDate = 07 17 2013 11:04PM    
1006 
1007 Slot 27 Offset 0x87f Length 77
1008 
1009 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1010 
1011 Memory Dump @0x0A64C87F
1012 
1013 00000000:   30001000 85000000 d52e7c01 fea10000 ?0.........|.....         
1014 00000010:   0600c004 0021003b 0047004d 00840000 ?.....!.;.G.M....         
1015 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1016 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1017 00000040:   90310033 00330000 952e55c4 7e????????.1.3.3....U.~            
1018 
1019 Slot 27 Column 0 Offset 0x1d Length 4
1020 
1021 UNIQUIFIER = 132                     
1022 
1023 Slot 27 Column 1 Offset 0x21 Length 26
1024 
1025 Company = 中国你好有限公司XX分公司   
1026 
1027 Slot 27 Column 2 Offset 0x4 Length 4
1028 
1029 DepartmentID = 133                   
1030 
1031 Slot 27 Column 3 Offset 0x3b Length 12
1032 
1033 Name = 销售部133                     
1034 
1035 Slot 27 Column 4 Offset 0x47 Length 6
1036 
1037 GroupName = 销售组                   
1038 
1039 Slot 27 Column 5 Offset 0x8 Length 8
1040 
1041 ModifiedDate = 07 17 2013 11:04PM    
1042 
1043 Slot 28 Offset 0x8cc Length 77
1044 
1045 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1046 
1047 Memory Dump @0x0A64C8CC
1048 
1049 00000000:   30001000 86000000 d52e7c01 fea10000 ?0.........|.....         
1050 00000010:   0600c004 0021003b 0047004d 00850000 ?.....!.;.G.M....         
1051 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1052 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1053 00000040:   90310033 00340000 952e55c4 7e????????.1.3.4....U.~            
1054 
1055 Slot 28 Column 0 Offset 0x1d Length 4
1056 
1057 UNIQUIFIER = 133                     
1058 
1059 Slot 28 Column 1 Offset 0x21 Length 26
1060 
1061 Company = 中国你好有限公司XX分公司   
1062 
1063 Slot 28 Column 2 Offset 0x4 Length 4
1064 
1065 DepartmentID = 134                   
1066 
1067 Slot 28 Column 3 Offset 0x3b Length 12
1068 
1069 Name = 销售部134                     
1070 
1071 Slot 28 Column 4 Offset 0x47 Length 6
1072 
1073 GroupName = 销售组                   
1074 
1075 Slot 28 Column 5 Offset 0x8 Length 8
1076 
1077 ModifiedDate = 07 17 2013 11:04PM    
1078 
1079 Slot 29 Offset 0x919 Length 77
1080 
1081 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1082 
1083 Memory Dump @0x0A64C919
1084 
1085 00000000:   30001000 87000000 d52e7c01 fea10000 ?0.........|.....         
1086 00000010:   0600c004 0021003b 0047004d 00860000 ?.....!.;.G.M....         
1087 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1088 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1089 00000040:   90310033 00350000 952e55c4 7e????????.1.3.5....U.~            
1090 
1091 Slot 29 Column 0 Offset 0x1d Length 4
1092 
1093 UNIQUIFIER = 134                     
1094 
1095 Slot 29 Column 1 Offset 0x21 Length 26
1096 
1097 Company = 中国你好有限公司XX分公司   
1098 
1099 Slot 29 Column 2 Offset 0x4 Length 4
1100 
1101 DepartmentID = 135                   
1102 
1103 Slot 29 Column 3 Offset 0x3b Length 12
1104 
1105 Name = 销售部135                     
1106 
1107 Slot 29 Column 4 Offset 0x47 Length 6
1108 
1109 GroupName = 销售组                   
1110 
1111 Slot 29 Column 5 Offset 0x8 Length 8
1112 
1113 ModifiedDate = 07 17 2013 11:04PM    
1114 
1115 Slot 30 Offset 0x966 Length 77
1116 
1117 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1118 
1119 Memory Dump @0x0A64C966
1120 
1121 00000000:   30001000 88000000 d62e7c01 fea10000 ?0.........|.....         
1122 00000010:   0600c004 0021003b 0047004d 00870000 ?.....!.;.G.M....         
1123 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1124 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1125 00000040:   90310033 00360000 952e55c4 7e????????.1.3.6....U.~            
1126 
1127 Slot 30 Column 0 Offset 0x1d Length 4
1128 
1129 UNIQUIFIER = 135                     
1130 
1131 Slot 30 Column 1 Offset 0x21 Length 26
1132 
1133 Company = 中国你好有限公司XX分公司   
1134 
1135 Slot 30 Column 2 Offset 0x4 Length 4
1136 
1137 DepartmentID = 136                   
1138 
1139 Slot 30 Column 3 Offset 0x3b Length 12
1140 
1141 Name = 销售部136                     
1142 
1143 Slot 30 Column 4 Offset 0x47 Length 6
1144 
1145 GroupName = 销售组                   
1146 
1147 Slot 30 Column 5 Offset 0x8 Length 8
1148 
1149 ModifiedDate = 07 17 2013 11:04PM    
1150 
1151 Slot 31 Offset 0x9b3 Length 77
1152 
1153 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1154 
1155 Memory Dump @0x0A64C9B3
1156 
1157 00000000:   30001000 89000000 d62e7c01 fea10000 ?0.........|.....         
1158 00000010:   0600c004 0021003b 0047004d 00880000 ?.....!.;.G.M....         
1159 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1160 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1161 00000040:   90310033 00370000 952e55c4 7e????????.1.3.7....U.~            
1162 
1163 Slot 31 Column 0 Offset 0x1d Length 4
1164 
1165 UNIQUIFIER = 136                     
1166 
1167 Slot 31 Column 1 Offset 0x21 Length 26
1168 
1169 Company = 中国你好有限公司XX分公司   
1170 
1171 Slot 31 Column 2 Offset 0x4 Length 4
1172 
1173 DepartmentID = 137                   
1174 
1175 Slot 31 Column 3 Offset 0x3b Length 12
1176 
1177 Name = 销售部137                     
1178 
1179 Slot 31 Column 4 Offset 0x47 Length 6
1180 
1181 GroupName = 销售组                   
1182 
1183 Slot 31 Column 5 Offset 0x8 Length 8
1184 
1185 ModifiedDate = 07 17 2013 11:04PM    
1186 
1187 Slot 32 Offset 0xa00 Length 77
1188 
1189 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1190 
1191 Memory Dump @0x0A64CA00
1192 
1193 00000000:   30001000 8a000000 d62e7c01 fea10000 ?0.........|.....         
1194 00000010:   0600c004 0021003b 0047004d 00890000 ?.....!.;.G.M....         
1195 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1196 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1197 00000040:   90310033 00380000 952e55c4 7e????????.1.3.8....U.~            
1198 
1199 Slot 32 Column 0 Offset 0x1d Length 4
1200 
1201 UNIQUIFIER = 137                     
1202 
1203 Slot 32 Column 1 Offset 0x21 Length 26
1204 
1205 Company = 中国你好有限公司XX分公司   
1206 
1207 Slot 32 Column 2 Offset 0x4 Length 4
1208 
1209 DepartmentID = 138                   
1210 
1211 Slot 32 Column 3 Offset 0x3b Length 12
1212 
1213 Name = 销售部138                     
1214 
1215 Slot 32 Column 4 Offset 0x47 Length 6
1216 
1217 GroupName = 销售组                   
1218 
1219 Slot 32 Column 5 Offset 0x8 Length 8
1220 
1221 ModifiedDate = 07 17 2013 11:04PM    
1222 
1223 Slot 33 Offset 0xa4d Length 77
1224 
1225 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1226 
1227 Memory Dump @0x0A64CA4D
1228 
1229 00000000:   30001000 8b000000 d62e7c01 fea10000 ?0.........|.....         
1230 00000010:   0600c004 0021003b 0047004d 008a0000 ?.....!.;.G.M....         
1231 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1232 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1233 00000040:   90310033 00390000 952e55c4 7e????????.1.3.9....U.~            
1234 
1235 Slot 33 Column 0 Offset 0x1d Length 4
1236 
1237 UNIQUIFIER = 138                     
1238 
1239 Slot 33 Column 1 Offset 0x21 Length 26
1240 
1241 Company = 中国你好有限公司XX分公司   
1242 
1243 Slot 33 Column 2 Offset 0x4 Length 4
1244 
1245 DepartmentID = 139                   
1246 
1247 Slot 33 Column 3 Offset 0x3b Length 12
1248 
1249 Name = 销售部139                     
1250 
1251 Slot 33 Column 4 Offset 0x47 Length 6
1252 
1253 GroupName = 销售组                   
1254 
1255 Slot 33 Column 5 Offset 0x8 Length 8
1256 
1257 ModifiedDate = 07 17 2013 11:04PM    
1258 
1259 Slot 34 Offset 0xa9a Length 77
1260 
1261 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1262 
1263 Memory Dump @0x0A64CA9A
1264 
1265 00000000:   30001000 8c000000 d62e7c01 fea10000 ?0.........|.....         
1266 00000010:   0600c004 0021003b 0047004d 008b0000 ?.....!.;.G.M....         
1267 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1268 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1269 00000040:   90310034 00300000 952e55c4 7e????????.1.4.0....U.~            
1270 
1271 Slot 34 Column 0 Offset 0x1d Length 4
1272 
1273 UNIQUIFIER = 139                     
1274 
1275 Slot 34 Column 1 Offset 0x21 Length 26
1276 
1277 Company = 中国你好有限公司XX分公司   
1278 
1279 Slot 34 Column 2 Offset 0x4 Length 4
1280 
1281 DepartmentID = 140                   
1282 
1283 Slot 34 Column 3 Offset 0x3b Length 12
1284 
1285 Name = 销售部140                     
1286 
1287 Slot 34 Column 4 Offset 0x47 Length 6
1288 
1289 GroupName = 销售组                   
1290 
1291 Slot 34 Column 5 Offset 0x8 Length 8
1292 
1293 ModifiedDate = 07 17 2013 11:04PM    
1294 
1295 Slot 35 Offset 0xae7 Length 77
1296 
1297 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1298 
1299 Memory Dump @0x0A64CAE7
1300 
1301 00000000:   30001000 8d000000 d62e7c01 fea10000 ?0.........|.....         
1302 00000010:   0600c004 0021003b 0047004d 008c0000 ?.....!.;.G.M....         
1303 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1304 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1305 00000040:   90310034 00310000 952e55c4 7e????????.1.4.1....U.~            
1306 
1307 Slot 35 Column 0 Offset 0x1d Length 4
1308 
1309 UNIQUIFIER = 140                     
1310 
1311 Slot 35 Column 1 Offset 0x21 Length 26
1312 
1313 Company = 中国你好有限公司XX分公司   
1314 
1315 Slot 35 Column 2 Offset 0x4 Length 4
1316 
1317 DepartmentID = 141                   
1318 
1319 Slot 35 Column 3 Offset 0x3b Length 12
1320 
1321 Name = 销售部141                     
1322 
1323 Slot 35 Column 4 Offset 0x47 Length 6
1324 
1325 GroupName = 销售组                   
1326 
1327 Slot 35 Column 5 Offset 0x8 Length 8
1328 
1329 ModifiedDate = 07 17 2013 11:04PM    
1330 
1331 Slot 36 Offset 0xb34 Length 77
1332 
1333 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1334 
1335 Memory Dump @0x0A64CB34
1336 
1337 00000000:   30001000 8e000000 d62e7c01 fea10000 ?0.........|.....         
1338 00000010:   0600c004 0021003b 0047004d 008d0000 ?.....!.;.G.M....         
1339 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1340 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1341 00000040:   90310034 00320000 952e55c4 7e????????.1.4.2....U.~            
1342 
1343 Slot 36 Column 0 Offset 0x1d Length 4
1344 
1345 UNIQUIFIER = 141                     
1346 
1347 Slot 36 Column 1 Offset 0x21 Length 26
1348 
1349 Company = 中国你好有限公司XX分公司   
1350 
1351 Slot 36 Column 2 Offset 0x4 Length 4
1352 
1353 DepartmentID = 142                   
1354 
1355 Slot 36 Column 3 Offset 0x3b Length 12
1356 
1357 Name = 销售部142                     
1358 
1359 Slot 36 Column 4 Offset 0x47 Length 6
1360 
1361 GroupName = 销售组                   
1362 
1363 Slot 36 Column 5 Offset 0x8 Length 8
1364 
1365 ModifiedDate = 07 17 2013 11:04PM    
1366 
1367 Slot 37 Offset 0xb81 Length 77
1368 
1369 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1370 
1371 Memory Dump @0x0A64CB81
1372 
1373 00000000:   30001000 8f000000 d62e7c01 fea10000 ?0.........|.....         
1374 00000010:   0600c004 0021003b 0047004d 008e0000 ?.....!.;.G.M....         
1375 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1376 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1377 00000040:   90310034 00330000 952e55c4 7e????????.1.4.3....U.~            
1378 
1379 Slot 37 Column 0 Offset 0x1d Length 4
1380 
1381 UNIQUIFIER = 142                     
1382 
1383 Slot 37 Column 1 Offset 0x21 Length 26
1384 
1385 Company = 中国你好有限公司XX分公司   
1386 
1387 Slot 37 Column 2 Offset 0x4 Length 4
1388 
1389 DepartmentID = 143                   
1390 
1391 Slot 37 Column 3 Offset 0x3b Length 12
1392 
1393 Name = 销售部143                     
1394 
1395 Slot 37 Column 4 Offset 0x47 Length 6
1396 
1397 GroupName = 销售组                   
1398 
1399 Slot 37 Column 5 Offset 0x8 Length 8
1400 
1401 ModifiedDate = 07 17 2013 11:04PM    
1402 
1403 Slot 38 Offset 0xbce Length 77
1404 
1405 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1406 
1407 Memory Dump @0x0A64CBCE
1408 
1409 00000000:   30001000 90000000 d62e7c01 fea10000 ?0.........|.....         
1410 00000010:   0600c004 0021003b 0047004d 008f0000 ?.....!.;.G.M....         
1411 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1412 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1413 00000040:   90310034 00340000 952e55c4 7e????????.1.4.4....U.~            
1414 
1415 Slot 38 Column 0 Offset 0x1d Length 4
1416 
1417 UNIQUIFIER = 143                     
1418 
1419 Slot 38 Column 1 Offset 0x21 Length 26
1420 
1421 Company = 中国你好有限公司XX分公司   
1422 
1423 Slot 38 Column 2 Offset 0x4 Length 4
1424 
1425 DepartmentID = 144                   
1426 
1427 Slot 38 Column 3 Offset 0x3b Length 12
1428 
1429 Name = 销售部144                     
1430 
1431 Slot 38 Column 4 Offset 0x47 Length 6
1432 
1433 GroupName = 销售组                   
1434 
1435 Slot 38 Column 5 Offset 0x8 Length 8
1436 
1437 ModifiedDate = 07 17 2013 11:04PM    
1438 
1439 Slot 39 Offset 0xc1b Length 77
1440 
1441 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1442 
1443 Memory Dump @0x0A64CC1B
1444 
1445 00000000:   30001000 91000000 d62e7c01 fea10000 ?0.........|.....         
1446 00000010:   0600c004 0021003b 0047004d 00900000 ?.....!.;.G.M....         
1447 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1448 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1449 00000040:   90310034 00350000 952e55c4 7e????????.1.4.5....U.~            
1450 
1451 Slot 39 Column 0 Offset 0x1d Length 4
1452 
1453 UNIQUIFIER = 144                     
1454 
1455 Slot 39 Column 1 Offset 0x21 Length 26
1456 
1457 Company = 中国你好有限公司XX分公司   
1458 
1459 Slot 39 Column 2 Offset 0x4 Length 4
1460 
1461 DepartmentID = 145                   
1462 
1463 Slot 39 Column 3 Offset 0x3b Length 12
1464 
1465 Name = 销售部145                     
1466 
1467 Slot 39 Column 4 Offset 0x47 Length 6
1468 
1469 GroupName = 销售组                   
1470 
1471 Slot 39 Column 5 Offset 0x8 Length 8
1472 
1473 ModifiedDate = 07 17 2013 11:04PM    
1474 
1475 Slot 40 Offset 0xc68 Length 77
1476 
1477 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1478 
1479 Memory Dump @0x0A64CC68
1480 
1481 00000000:   30001000 92000000 d62e7c01 fea10000 ?0.........|.....         
1482 00000010:   0600c004 0021003b 0047004d 00910000 ?.....!.;.G.M....         
1483 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1484 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1485 00000040:   90310034 00360000 952e55c4 7e????????.1.4.6....U.~            
1486 
1487 Slot 40 Column 0 Offset 0x1d Length 4
1488 
1489 UNIQUIFIER = 145                     
1490 
1491 Slot 40 Column 1 Offset 0x21 Length 26
1492 
1493 Company = 中国你好有限公司XX分公司   
1494 
1495 Slot 40 Column 2 Offset 0x4 Length 4
1496 
1497 DepartmentID = 146                   
1498 
1499 Slot 40 Column 3 Offset 0x3b Length 12
1500 
1501 Name = 销售部146                     
1502 
1503 Slot 40 Column 4 Offset 0x47 Length 6
1504 
1505 GroupName = 销售组                   
1506 
1507 Slot 40 Column 5 Offset 0x8 Length 8
1508 
1509 ModifiedDate = 07 17 2013 11:04PM    
1510 
1511 Slot 41 Offset 0xcb5 Length 77
1512 
1513 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1514 
1515 Memory Dump @0x0A64CCB5
1516 
1517 00000000:   30001000 93000000 d62e7c01 fea10000 ?0.........|.....         
1518 00000010:   0600c004 0021003b 0047004d 00920000 ?.....!.;.G.M....         
1519 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1520 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1521 00000040:   90310034 00370000 952e55c4 7e????????.1.4.7....U.~            
1522 
1523 Slot 41 Column 0 Offset 0x1d Length 4
1524 
1525 UNIQUIFIER = 146                     
1526 
1527 Slot 41 Column 1 Offset 0x21 Length 26
1528 
1529 Company = 中国你好有限公司XX分公司   
1530 
1531 Slot 41 Column 2 Offset 0x4 Length 4
1532 
1533 DepartmentID = 147                   
1534 
1535 Slot 41 Column 3 Offset 0x3b Length 12
1536 
1537 Name = 销售部147                     
1538 
1539 Slot 41 Column 4 Offset 0x47 Length 6
1540 
1541 GroupName = 销售组                   
1542 
1543 Slot 41 Column 5 Offset 0x8 Length 8
1544 
1545 ModifiedDate = 07 17 2013 11:04PM    
1546 
1547 Slot 42 Offset 0xd02 Length 77
1548 
1549 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1550 
1551 Memory Dump @0x0A64CD02
1552 
1553 00000000:   30001000 94000000 d62e7c01 fea10000 ?0.........|.....         
1554 00000010:   0600c004 0021003b 0047004d 00930000 ?.....!.;.G.M....         
1555 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1556 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1557 00000040:   90310034 00380000 952e55c4 7e????????.1.4.8....U.~            
1558 
1559 Slot 42 Column 0 Offset 0x1d Length 4
1560 
1561 UNIQUIFIER = 147                     
1562 
1563 Slot 42 Column 1 Offset 0x21 Length 26
1564 
1565 Company = 中国你好有限公司XX分公司   
1566 
1567 Slot 42 Column 2 Offset 0x4 Length 4
1568 
1569 DepartmentID = 148                   
1570 
1571 Slot 42 Column 3 Offset 0x3b Length 12
1572 
1573 Name = 销售部148                     
1574 
1575 Slot 42 Column 4 Offset 0x47 Length 6
1576 
1577 GroupName = 销售组                   
1578 
1579 Slot 42 Column 5 Offset 0x8 Length 8
1580 
1581 ModifiedDate = 07 17 2013 11:04PM    
1582 
1583 Slot 43 Offset 0xd4f Length 77
1584 
1585 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1586 
1587 Memory Dump @0x0A64CD4F
1588 
1589 00000000:   30001000 95000000 d62e7c01 fea10000 ?0.........|.....         
1590 00000010:   0600c004 0021003b 0047004d 00940000 ?.....!.;.G.M....         
1591 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1592 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1593 00000040:   90310034 00390000 952e55c4 7e????????.1.4.9....U.~            
1594 
1595 Slot 43 Column 0 Offset 0x1d Length 4
1596 
1597 UNIQUIFIER = 148                     
1598 
1599 Slot 43 Column 1 Offset 0x21 Length 26
1600 
1601 Company = 中国你好有限公司XX分公司   
1602 
1603 Slot 43 Column 2 Offset 0x4 Length 4
1604 
1605 DepartmentID = 149                   
1606 
1607 Slot 43 Column 3 Offset 0x3b Length 12
1608 
1609 Name = 销售部149                     
1610 
1611 Slot 43 Column 4 Offset 0x47 Length 6
1612 
1613 GroupName = 销售组                   
1614 
1615 Slot 43 Column 5 Offset 0x8 Length 8
1616 
1617 ModifiedDate = 07 17 2013 11:04PM    
1618 
1619 Slot 44 Offset 0xd9c Length 77
1620 
1621 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1622 
1623 Memory Dump @0x0A64CD9C
1624 
1625 00000000:   30001000 96000000 d62e7c01 fea10000 ?0.........|.....         
1626 00000010:   0600c004 0021003b 0047004d 00950000 ?.....!.;.G.M....         
1627 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1628 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1629 00000040:   90310035 00300000 952e55c4 7e????????.1.5.0....U.~            
1630 
1631 Slot 44 Column 0 Offset 0x1d Length 4
1632 
1633 UNIQUIFIER = 149                     
1634 
1635 Slot 44 Column 1 Offset 0x21 Length 26
1636 
1637 Company = 中国你好有限公司XX分公司   
1638 
1639 Slot 44 Column 2 Offset 0x4 Length 4
1640 
1641 DepartmentID = 150                   
1642 
1643 Slot 44 Column 3 Offset 0x3b Length 12
1644 
1645 Name = 销售部150                     
1646 
1647 Slot 44 Column 4 Offset 0x47 Length 6
1648 
1649 GroupName = 销售组                   
1650 
1651 Slot 44 Column 5 Offset 0x8 Length 8
1652 
1653 ModifiedDate = 07 17 2013 11:04PM    
1654 
1655 Slot 45 Offset 0xde9 Length 77
1656 
1657 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1658 
1659 Memory Dump @0x0A64CDE9
1660 
1661 00000000:   30001000 97000000 d72e7c01 fea10000 ?0.........|.....         
1662 00000010:   0600c004 0021003b 0047004d 00960000 ?.....!.;.G.M....         
1663 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1664 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1665 00000040:   90310035 00310000 952e55c4 7e????????.1.5.1....U.~            
1666 
1667 Slot 45 Column 0 Offset 0x1d Length 4
1668 
1669 UNIQUIFIER = 150                     
1670 
1671 Slot 45 Column 1 Offset 0x21 Length 26
1672 
1673 Company = 中国你好有限公司XX分公司   
1674 
1675 Slot 45 Column 2 Offset 0x4 Length 4
1676 
1677 DepartmentID = 151                   
1678 
1679 Slot 45 Column 3 Offset 0x3b Length 12
1680 
1681 Name = 销售部151                     
1682 
1683 Slot 45 Column 4 Offset 0x47 Length 6
1684 
1685 GroupName = 销售组                   
1686 
1687 Slot 45 Column 5 Offset 0x8 Length 8
1688 
1689 ModifiedDate = 07 17 2013 11:04PM    
1690 
1691 Slot 46 Offset 0xe36 Length 77
1692 
1693 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1694 
1695 Memory Dump @0x0A64CE36
1696 
1697 00000000:   30001000 98000000 d72e7c01 fea10000 ?0.........|.....         
1698 00000010:   0600c004 0021003b 0047004d 00970000 ?.....!.;.G.M....         
1699 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1700 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1701 00000040:   90310035 00320000 952e55c4 7e????????.1.5.2....U.~            
1702 
1703 Slot 46 Column 0 Offset 0x1d Length 4
1704 
1705 UNIQUIFIER = 151                     
1706 
1707 Slot 46 Column 1 Offset 0x21 Length 26
1708 
1709 Company = 中国你好有限公司XX分公司   
1710 
1711 Slot 46 Column 2 Offset 0x4 Length 4
1712 
1713 DepartmentID = 152                   
1714 
1715 Slot 46 Column 3 Offset 0x3b Length 12
1716 
1717 Name = 销售部152                     
1718 
1719 Slot 46 Column 4 Offset 0x47 Length 6
1720 
1721 GroupName = 销售组                   
1722 
1723 Slot 46 Column 5 Offset 0x8 Length 8
1724 
1725 ModifiedDate = 07 17 2013 11:04PM    
1726 
1727 Slot 47 Offset 0xe83 Length 77
1728 
1729 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1730 
1731 Memory Dump @0x0A64CE83
1732 
1733 00000000:   30001000 99000000 d72e7c01 fea10000 ?0.........|.....         
1734 00000010:   0600c004 0021003b 0047004d 00980000 ?.....!.;.G.M....         
1735 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1736 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1737 00000040:   90310035 00330000 952e55c4 7e????????.1.5.3....U.~            
1738 
1739 Slot 47 Column 0 Offset 0x1d Length 4
1740 
1741 UNIQUIFIER = 152                     
1742 
1743 Slot 47 Column 1 Offset 0x21 Length 26
1744 
1745 Company = 中国你好有限公司XX分公司   
1746 
1747 Slot 47 Column 2 Offset 0x4 Length 4
1748 
1749 DepartmentID = 153                   
1750 
1751 Slot 47 Column 3 Offset 0x3b Length 12
1752 
1753 Name = 销售部153                     
1754 
1755 Slot 47 Column 4 Offset 0x47 Length 6
1756 
1757 GroupName = 销售组                   
1758 
1759 Slot 47 Column 5 Offset 0x8 Length 8
1760 
1761 ModifiedDate = 07 17 2013 11:04PM    
1762 
1763 Slot 48 Offset 0xed0 Length 77
1764 
1765 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1766 
1767 Memory Dump @0x0A64CED0
1768 
1769 00000000:   30001000 9a000000 d72e7c01 fea10000 ?0.........|.....         
1770 00000010:   0600c004 0021003b 0047004d 00990000 ?.....!.;.G.M....         
1771 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1772 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1773 00000040:   90310035 00340000 952e55c4 7e????????.1.5.4....U.~            
1774 
1775 Slot 48 Column 0 Offset 0x1d Length 4
1776 
1777 UNIQUIFIER = 153                     
1778 
1779 Slot 48 Column 1 Offset 0x21 Length 26
1780 
1781 Company = 中国你好有限公司XX分公司   
1782 
1783 Slot 48 Column 2 Offset 0x4 Length 4
1784 
1785 DepartmentID = 154                   
1786 
1787 Slot 48 Column 3 Offset 0x3b Length 12
1788 
1789 Name = 销售部154                     
1790 
1791 Slot 48 Column 4 Offset 0x47 Length 6
1792 
1793 GroupName = 销售组                   
1794 
1795 Slot 48 Column 5 Offset 0x8 Length 8
1796 
1797 ModifiedDate = 07 17 2013 11:04PM    
1798 
1799 Slot 49 Offset 0xf1d Length 77
1800 
1801 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1802 
1803 Memory Dump @0x0A64CF1D
1804 
1805 00000000:   30001000 9b000000 d72e7c01 fea10000 ?0.........|.....         
1806 00000010:   0600c004 0021003b 0047004d 009a0000 ?.....!.;.G.M....         
1807 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1808 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1809 00000040:   90310035 00350000 952e55c4 7e????????.1.5.5....U.~            
1810 
1811 Slot 49 Column 0 Offset 0x1d Length 4
1812 
1813 UNIQUIFIER = 154                     
1814 
1815 Slot 49 Column 1 Offset 0x21 Length 26
1816 
1817 Company = 中国你好有限公司XX分公司   
1818 
1819 Slot 49 Column 2 Offset 0x4 Length 4
1820 
1821 DepartmentID = 155                   
1822 
1823 Slot 49 Column 3 Offset 0x3b Length 12
1824 
1825 Name = 销售部155                     
1826 
1827 Slot 49 Column 4 Offset 0x47 Length 6
1828 
1829 GroupName = 销售组                   
1830 
1831 Slot 49 Column 5 Offset 0x8 Length 8
1832 
1833 ModifiedDate = 07 17 2013 11:04PM    
1834 
1835 Slot 50 Offset 0xf6a Length 77
1836 
1837 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1838 
1839 Memory Dump @0x0A64CF6A
1840 
1841 00000000:   30001000 9c000000 d72e7c01 fea10000 ?0.........|.....         
1842 00000010:   0600c004 0021003b 0047004d 009b0000 ?.....!.;.G.M....         
1843 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1844 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1845 00000040:   90310035 00360000 952e55c4 7e????????.1.5.6....U.~            
1846 
1847 Slot 50 Column 0 Offset 0x1d Length 4
1848 
1849 UNIQUIFIER = 155                     
1850 
1851 Slot 50 Column 1 Offset 0x21 Length 26
1852 
1853 Company = 中国你好有限公司XX分公司   
1854 
1855 Slot 50 Column 2 Offset 0x4 Length 4
1856 
1857 DepartmentID = 156                   
1858 
1859 Slot 50 Column 3 Offset 0x3b Length 12
1860 
1861 Name = 销售部156                     
1862 
1863 Slot 50 Column 4 Offset 0x47 Length 6
1864 
1865 GroupName = 销售组                   
1866 
1867 Slot 50 Column 5 Offset 0x8 Length 8
1868 
1869 ModifiedDate = 07 17 2013 11:04PM    
1870 
1871 Slot 51 Offset 0xfb7 Length 77
1872 
1873 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1874 
1875 Memory Dump @0x0A64CFB7
1876 
1877 00000000:   30001000 9d000000 d72e7c01 fea10000 ?0.........|.....         
1878 00000010:   0600c004 0021003b 0047004d 009c0000 ?.....!.;.G.M....         
1879 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1880 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1881 00000040:   90310035 00370000 952e55c4 7e????????.1.5.7....U.~            
1882 
1883 Slot 51 Column 0 Offset 0x1d Length 4
1884 
1885 UNIQUIFIER = 156                     
1886 
1887 Slot 51 Column 1 Offset 0x21 Length 26
1888 
1889 Company = 中国你好有限公司XX分公司   
1890 
1891 Slot 51 Column 2 Offset 0x4 Length 4
1892 
1893 DepartmentID = 157                   
1894 
1895 Slot 51 Column 3 Offset 0x3b Length 12
1896 
1897 Name = 销售部157                     
1898 
1899 Slot 51 Column 4 Offset 0x47 Length 6
1900 
1901 GroupName = 销售组                   
1902 
1903 Slot 51 Column 5 Offset 0x8 Length 8
1904 

1905 ModifiedDate = 07 17 2013 11:04PM    
1906 
1907 Slot 52 Offset 0x1004 Length 77
1908 
1909 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1910 
1911 Memory Dump @0x0A64D004
1912 
1913 00000000:   30001000 9e000000 d72e7c01 fea10000 ?0.........|.....         
1914 00000010:   0600c004 0021003b 0047004d 009d0000 ?.....!.;.G.M....         
1915 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1916 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1917 00000040:   90310035 00380000 952e55c4 7e????????.1.5.8....U.~            
1918 
1919 Slot 52 Column 0 Offset 0x1d Length 4
1920 
1921 UNIQUIFIER = 157                     
1922 
1923 Slot 52 Column 1 Offset 0x21 Length 26
1924 
1925 Company = 中国你好有限公司XX分公司   
1926 
1927 Slot 52 Column 2 Offset 0x4 Length 4
1928 
1929 DepartmentID = 158                   
1930 
1931 Slot 52 Column 3 Offset 0x3b Length 12
1932 
1933 Name = 销售部158                     
1934 
1935 Slot 52 Column 4 Offset 0x47 Length 6
1936 
1937 GroupName = 销售组                   
1938 
1939 Slot 52 Column 5 Offset 0x8 Length 8
1940 
1941 ModifiedDate = 07 17 2013 11:04PM    
1942 
1943 Slot 53 Offset 0x1051 Length 77
1944 
1945 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1946 
1947 Memory Dump @0x0A64D051
1948 
1949 00000000:   30001000 9f000000 d72e7c01 fea10000 ?0.........|.....         
1950 00000010:   0600c004 0021003b 0047004d 009e0000 ?.....!.;.G.M....         
1951 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1952 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1953 00000040:   90310035 00390000 952e55c4 7e????????.1.5.9....U.~            
1954 
1955 Slot 53 Column 0 Offset 0x1d Length 4
1956 
1957 UNIQUIFIER = 158                     
1958 
1959 Slot 53 Column 1 Offset 0x21 Length 26
1960 
1961 Company = 中国你好有限公司XX分公司   
1962 
1963 Slot 53 Column 2 Offset 0x4 Length 4
1964 
1965 DepartmentID = 159                   
1966 
1967 Slot 53 Column 3 Offset 0x3b Length 12
1968 
1969 Name = 销售部159                     
1970 
1971 Slot 53 Column 4 Offset 0x47 Length 6
1972 
1973 GroupName = 销售组                   
1974 
1975 Slot 53 Column 5 Offset 0x8 Length 8
1976 
1977 ModifiedDate = 07 17 2013 11:04PM    
1978 
1979 Slot 54 Offset 0x109e Length 77
1980 
1981 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
1982 
1983 Memory Dump @0x0A64D09E
1984 
1985 00000000:   30001000 a0000000 d72e7c01 fea10000 ?0.........|.....         
1986 00000010:   0600c004 0021003b 0047004d 009f0000 ?.....!.;.G.M....         
1987 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
1988 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
1989 00000040:   90310036 00300000 952e55c4 7e????????.1.6.0....U.~            
1990 
1991 Slot 54 Column 0 Offset 0x1d Length 4
1992 
1993 UNIQUIFIER = 159                     
1994 
1995 Slot 54 Column 1 Offset 0x21 Length 26
1996 
1997 Company = 中国你好有限公司XX分公司   
1998 
1999 Slot 54 Column 2 Offset 0x4 Length 4
2000 
2001 DepartmentID = 160                   
2002 
2003 Slot 54 Column 3 Offset 0x3b Length 12
2004 
2005 Name = 销售部160                     
2006 
2007 Slot 54 Column 4 Offset 0x47 Length 6
2008 
2009 GroupName = 销售组                   
2010 
2011 Slot 54 Column 5 Offset 0x8 Length 8
2012 
2013 ModifiedDate = 07 17 2013 11:04PM    
2014 
2015 Slot 55 Offset 0x10eb Length 77
2016 
2017 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2018 
2019 Memory Dump @0x0A64D0EB
2020 
2021 00000000:   30001000 a1000000 d72e7c01 fea10000 ?0.........|.....         
2022 00000010:   0600c004 0021003b 0047004d 00a00000 ?.....!.;.G.M....         
2023 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2024 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2025 00000040:   90310036 00310000 952e55c4 7e????????.1.6.1....U.~            
2026 
2027 Slot 55 Column 0 Offset 0x1d Length 4
2028 
2029 UNIQUIFIER = 160                     
2030 
2031 Slot 55 Column 1 Offset 0x21 Length 26
2032 
2033 Company = 中国你好有限公司XX分公司   
2034 
2035 Slot 55 Column 2 Offset 0x4 Length 4
2036 
2037 DepartmentID = 161                   
2038 
2039 Slot 55 Column 3 Offset 0x3b Length 12
2040 
2041 Name = 销售部161                     
2042 
2043 Slot 55 Column 4 Offset 0x47 Length 6
2044 
2045 GroupName = 销售组                   
2046 
2047 Slot 55 Column 5 Offset 0x8 Length 8
2048 
2049 ModifiedDate = 07 17 2013 11:04PM    
2050 
2051 Slot 56 Offset 0x1138 Length 77
2052 
2053 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2054 
2055 Memory Dump @0x0A64D138
2056 
2057 00000000:   30001000 a2000000 d82e7c01 fea10000 ?0.........|.....         
2058 00000010:   0600c004 0021003b 0047004d 00a10000 ?.....!.;.G.M....         
2059 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2060 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2061 00000040:   90310036 00320000 952e55c4 7e????????.1.6.2....U.~            
2062 
2063 Slot 56 Column 0 Offset 0x1d Length 4
2064 
2065 UNIQUIFIER = 161                     
2066 
2067 Slot 56 Column 1 Offset 0x21 Length 26
2068 
2069 Company = 中国你好有限公司XX分公司   
2070 
2071 Slot 56 Column 2 Offset 0x4 Length 4
2072 
2073 DepartmentID = 162                   
2074 
2075 Slot 56 Column 3 Offset 0x3b Length 12
2076 
2077 Name = 销售部162                     
2078 
2079 Slot 56 Column 4 Offset 0x47 Length 6
2080 
2081 GroupName = 销售组                   
2082 
2083 Slot 56 Column 5 Offset 0x8 Length 8
2084 
2085 ModifiedDate = 07 17 2013 11:04PM    
2086 
2087 Slot 57 Offset 0x1185 Length 77
2088 
2089 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2090 
2091 Memory Dump @0x0A64D185
2092 
2093 00000000:   30001000 a3000000 d82e7c01 fea10000 ?0.........|.....         
2094 00000010:   0600c004 0021003b 0047004d 00a20000 ?.....!.;.G.M....         
2095 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2096 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2097 00000040:   90310036 00330000 952e55c4 7e????????.1.6.3....U.~            
2098 
2099 Slot 57 Column 0 Offset 0x1d Length 4
2100 
2101 UNIQUIFIER = 162                     
2102 
2103 Slot 57 Column 1 Offset 0x21 Length 26
2104 
2105 Company = 中国你好有限公司XX分公司   
2106 
2107 Slot 57 Column 2 Offset 0x4 Length 4
2108 
2109 DepartmentID = 163                   
2110 
2111 Slot 57 Column 3 Offset 0x3b Length 12
2112 
2113 Name = 销售部163                     
2114 
2115 Slot 57 Column 4 Offset 0x47 Length 6
2116 
2117 GroupName = 销售组                   
2118 
2119 Slot 57 Column 5 Offset 0x8 Length 8
2120 
2121 ModifiedDate = 07 17 2013 11:04PM    
2122 
2123 Slot 58 Offset 0x11d2 Length 77
2124 
2125 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2126 
2127 Memory Dump @0x0A64D1D2
2128 
2129 00000000:   30001000 a4000000 d82e7c01 fea10000 ?0.........|.....         
2130 00000010:   0600c004 0021003b 0047004d 00a30000 ?.....!.;.G.M....         
2131 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2132 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2133 00000040:   90310036 00340000 952e55c4 7e????????.1.6.4....U.~            
2134 
2135 Slot 58 Column 0 Offset 0x1d Length 4
2136 
2137 UNIQUIFIER = 163                     
2138 
2139 Slot 58 Column 1 Offset 0x21 Length 26
2140 
2141 Company = 中国你好有限公司XX分公司   
2142 
2143 Slot 58 Column 2 Offset 0x4 Length 4
2144 
2145 DepartmentID = 164                   
2146 
2147 Slot 58 Column 3 Offset 0x3b Length 12
2148 
2149 Name = 销售部164                     
2150 
2151 Slot 58 Column 4 Offset 0x47 Length 6
2152 
2153 GroupName = 销售组                   
2154 
2155 Slot 58 Column 5 Offset 0x8 Length 8
2156 
2157 ModifiedDate = 07 17 2013 11:04PM    
2158 
2159 Slot 59 Offset 0x121f Length 77
2160 
2161 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2162 
2163 Memory Dump @0x0A64D21F
2164 
2165 00000000:   30001000 a5000000 d82e7c01 fea10000 ?0.........|.....         
2166 00000010:   0600c004 0021003b 0047004d 00a40000 ?.....!.;.G.M....         
2167 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2168 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2169 00000040:   90310036 00350000 952e55c4 7e????????.1.6.5....U.~            
2170 
2171 Slot 59 Column 0 Offset 0x1d Length 4
2172 
2173 UNIQUIFIER = 164                     
2174 
2175 Slot 59 Column 1 Offset 0x21 Length 26
2176 
2177 Company = 中国你好有限公司XX分公司   
2178 
2179 Slot 59 Column 2 Offset 0x4 Length 4
2180 
2181 DepartmentID = 165                   
2182 
2183 Slot 59 Column 3 Offset 0x3b Length 12
2184 
2185 Name = 销售部165                     
2186 
2187 Slot 59 Column 4 Offset 0x47 Length 6
2188 
2189 GroupName = 销售组                   
2190 
2191 Slot 59 Column 5 Offset 0x8 Length 8
2192 
2193 ModifiedDate = 07 17 2013 11:04PM    
2194 
2195 Slot 60 Offset 0x126c Length 77
2196 
2197 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2198 
2199 Memory Dump @0x0A64D26C
2200 
2201 00000000:   30001000 a6000000 d82e7c01 fea10000 ?0.........|.....         
2202 00000010:   0600c004 0021003b 0047004d 00a50000 ?.....!.;.G.M....         
2203 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2204 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2205 00000040:   90310036 00360000 952e55c4 7e????????.1.6.6....U.~            
2206 
2207 Slot 60 Column 0 Offset 0x1d Length 4
2208 
2209 UNIQUIFIER = 165                     
2210 
2211 Slot 60 Column 1 Offset 0x21 Length 26
2212 
2213 Company = 中国你好有限公司XX分公司   
2214 
2215 Slot 60 Column 2 Offset 0x4 Length 4
2216 
2217 DepartmentID = 166                   
2218 
2219 Slot 60 Column 3 Offset 0x3b Length 12
2220 
2221 Name = 销售部166                     
2222 
2223 Slot 60 Column 4 Offset 0x47 Length 6
2224 
2225 GroupName = 销售组                   
2226 
2227 Slot 60 Column 5 Offset 0x8 Length 8
2228 
2229 ModifiedDate = 07 17 2013 11:04PM    
2230 
2231 Slot 61 Offset 0x12b9 Length 77
2232 
2233 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2234 
2235 Memory Dump @0x0A64D2B9
2236 
2237 00000000:   30001000 a7000000 d82e7c01 fea10000 ?0.........|.....         
2238 00000010:   0600c004 0021003b 0047004d 00a60000 ?.....!.;.G.M....         
2239 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2240 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2241 00000040:   90310036 00370000 952e55c4 7e????????.1.6.7....U.~            
2242 
2243 Slot 61 Column 0 Offset 0x1d Length 4
2244 
2245 UNIQUIFIER = 166                     
2246 
2247 Slot 61 Column 1 Offset 0x21 Length 26
2248 
2249 Company = 中国你好有限公司XX分公司   
2250 
2251 Slot 61 Column 2 Offset 0x4 Length 4
2252 
2253 DepartmentID = 167                   
2254 
2255 Slot 61 Column 3 Offset 0x3b Length 12
2256 
2257 Name = 销售部167                     
2258 
2259 Slot 61 Column 4 Offset 0x47 Length 6
2260 
2261 GroupName = 销售组                   
2262 
2263 Slot 61 Column 5 Offset 0x8 Length 8
2264 
2265 ModifiedDate = 07 17 2013 11:04PM    
2266 
2267 Slot 62 Offset 0x1306 Length 77
2268 
2269 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2270 
2271 Memory Dump @0x0A64D306
2272 
2273 00000000:   30001000 a8000000 d82e7c01 fea10000 ?0.........|.....         
2274 00000010:   0600c004 0021003b 0047004d 00a70000 ?.....!.;.G.M....         
2275 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2276 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2277 00000040:   90310036 00380000 952e55c4 7e????????.1.6.8....U.~            
2278 
2279 Slot 62 Column 0 Offset 0x1d Length 4
2280 
2281 UNIQUIFIER = 167                     
2282 
2283 Slot 62 Column 1 Offset 0x21 Length 26
2284 
2285 Company = 中国你好有限公司XX分公司   
2286 
2287 Slot 62 Column 2 Offset 0x4 Length 4
2288 
2289 DepartmentID = 168                   
2290 
2291 Slot 62 Column 3 Offset 0x3b Length 12
2292 
2293 Name = 销售部168                     
2294 
2295 Slot 62 Column 4 Offset 0x47 Length 6
2296 
2297 GroupName = 销售组                   
2298 
2299 Slot 62 Column 5 Offset 0x8 Length 8
2300 
2301 ModifiedDate = 07 17 2013 11:04PM    
2302 
2303 Slot 63 Offset 0x1353 Length 77
2304 
2305 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2306 
2307 Memory Dump @0x0A64D353
2308 
2309 00000000:   30001000 a9000000 d82e7c01 fea10000 ?0.........|.....         
2310 00000010:   0600c004 0021003b 0047004d 00a80000 ?.....!.;.G.M....         
2311 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2312 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2313 00000040:   90310036 00390000 952e55c4 7e????????.1.6.9....U.~            
2314 
2315 Slot 63 Column 0 Offset 0x1d Length 4
2316 
2317 UNIQUIFIER = 168                     
2318 
2319 Slot 63 Column 1 Offset 0x21 Length 26
2320 
2321 Company = 中国你好有限公司XX分公司   
2322 
2323 Slot 63 Column 2 Offset 0x4 Length 4
2324 
2325 DepartmentID = 169                   
2326 
2327 Slot 63 Column 3 Offset 0x3b Length 12
2328 
2329 Name = 销售部169                     
2330 
2331 Slot 63 Column 4 Offset 0x47 Length 6
2332 
2333 GroupName = 销售组                   
2334 
2335 Slot 63 Column 5 Offset 0x8 Length 8
2336 
2337 ModifiedDate = 07 17 2013 11:04PM    
2338 
2339 Slot 64 Offset 0x13a0 Length 77
2340 
2341 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2342 
2343 Memory Dump @0x0A64D3A0
2344 
2345 00000000:   30001000 aa000000 d82e7c01 fea10000 ?0.........|.....         
2346 00000010:   0600c004 0021003b 0047004d 00a90000 ?.....!.;.G.M....         
2347 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2348 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2349 00000040:   90310037 00300000 952e55c4 7e????????.1.7.0....U.~            
2350 
2351 Slot 64 Column 0 Offset 0x1d Length 4
2352 
2353 UNIQUIFIER = 169                     
2354 
2355 Slot 64 Column 1 Offset 0x21 Length 26
2356 
2357 Company = 中国你好有限公司XX分公司   
2358 
2359 Slot 64 Column 2 Offset 0x4 Length 4
2360 
2361 DepartmentID = 170                   
2362 
2363 Slot 64 Column 3 Offset 0x3b Length 12
2364 
2365 Name = 销售部170                     
2366 
2367 Slot 64 Column 4 Offset 0x47 Length 6
2368 
2369 GroupName = 销售组                   
2370 
2371 Slot 64 Column 5 Offset 0x8 Length 8
2372 
2373 ModifiedDate = 07 17 2013 11:04PM    
2374 
2375 Slot 65 Offset 0x13ed Length 77
2376 
2377 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2378 
2379 Memory Dump @0x0A64D3ED
2380 
2381 00000000:   30001000 ab000000 d92e7c01 fea10000 ?0.........|.....         
2382 00000010:   0600c004 0021003b 0047004d 00aa0000 ?.....!.;.G.M....         
2383 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2384 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2385 00000040:   90310037 00310000 952e55c4 7e????????.1.7.1....U.~            
2386 
2387 Slot 65 Column 0 Offset 0x1d Length 4
2388 
2389 UNIQUIFIER = 170                     
2390 
2391 Slot 65 Column 1 Offset 0x21 Length 26
2392 
2393 Company = 中国你好有限公司XX分公司   
2394 
2395 Slot 65 Column 2 Offset 0x4 Length 4
2396 
2397 DepartmentID = 171                   
2398 
2399 Slot 65 Column 3 Offset 0x3b Length 12
2400 
2401 Name = 销售部171                     
2402 
2403 Slot 65 Column 4 Offset 0x47 Length 6
2404 
2405 GroupName = 销售组                   
2406 
2407 Slot 65 Column 5 Offset 0x8 Length 8
2408 
2409 ModifiedDate = 07 17 2013 11:04PM    
2410 
2411 Slot 66 Offset 0x143a Length 77
2412 
2413 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2414 
2415 Memory Dump @0x0A64D43A
2416 
2417 00000000:   30001000 ac000000 d92e7c01 fea10000 ?0.........|.....         
2418 00000010:   0600c004 0021003b 0047004d 00ab0000 ?.....!.;.G.M....         
2419 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2420 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2421 00000040:   90310037 00320000 952e55c4 7e????????.1.7.2....U.~            
2422 
2423 Slot 66 Column 0 Offset 0x1d Length 4
2424 
2425 UNIQUIFIER = 171                     
2426 
2427 Slot 66 Column 1 Offset 0x21 Length 26
2428 
2429 Company = 中国你好有限公司XX分公司   
2430 
2431 Slot 66 Column 2 Offset 0x4 Length 4
2432 
2433 DepartmentID = 172                   
2434 
2435 Slot 66 Column 3 Offset 0x3b Length 12
2436 
2437 Name = 销售部172                     
2438 
2439 Slot 66 Column 4 Offset 0x47 Length 6
2440 
2441 GroupName = 销售组                   
2442 
2443 Slot 66 Column 5 Offset 0x8 Length 8
2444 
2445 ModifiedDate = 07 17 2013 11:04PM    
2446 
2447 Slot 67 Offset 0x1487 Length 77
2448 
2449 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2450 
2451 Memory Dump @0x0A64D487
2452 
2453 00000000:   30001000 ad000000 d92e7c01 fea10000 ?0.........|.....         
2454 00000010:   0600c004 0021003b 0047004d 00ac0000 ?.....!.;.G.M....         
2455 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2456 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2457 00000040:   90310037 00330000 952e55c4 7e????????.1.7.3....U.~            
2458 
2459 Slot 67 Column 0 Offset 0x1d Length 4
2460 
2461 UNIQUIFIER = 172                     
2462 
2463 Slot 67 Column 1 Offset 0x21 Length 26
2464 
2465 Company = 中国你好有限公司XX分公司   
2466 
2467 Slot 67 Column 2 Offset 0x4 Length 4
2468 
2469 DepartmentID = 173                   
2470 
2471 Slot 67 Column 3 Offset 0x3b Length 12
2472 
2473 Name = 销售部173                     
2474 
2475 Slot 67 Column 4 Offset 0x47 Length 6
2476 
2477 GroupName = 销售组                   
2478 
2479 Slot 67 Column 5 Offset 0x8 Length 8
2480 
2481 ModifiedDate = 07 17 2013 11:04PM    
2482 
2483 Slot 68 Offset 0x14d4 Length 77
2484 
2485 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2486 
2487 Memory Dump @0x0A64D4D4
2488 
2489 00000000:   30001000 ae000000 d92e7c01 fea10000 ?0.........|.....         
2490 00000010:   0600c004 0021003b 0047004d 00ad0000 ?.....!.;.G.M....         
2491 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2492 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2493 00000040:   90310037 00340000 952e55c4 7e????????.1.7.4....U.~            
2494 
2495 Slot 68 Column 0 Offset 0x1d Length 4
2496 
2497 UNIQUIFIER = 173                     
2498 
2499 Slot 68 Column 1 Offset 0x21 Length 26
2500 
2501 Company = 中国你好有限公司XX分公司   
2502 
2503 Slot 68 Column 2 Offset 0x4 Length 4
2504 
2505 DepartmentID = 174                   
2506 
2507 Slot 68 Column 3 Offset 0x3b Length 12
2508 
2509 Name = 销售部174                     
2510 
2511 Slot 68 Column 4 Offset 0x47 Length 6
2512 
2513 GroupName = 销售组                   
2514 
2515 Slot 68 Column 5 Offset 0x8 Length 8
2516 
2517 ModifiedDate = 07 17 2013 11:04PM    
2518 
2519 Slot 69 Offset 0x1521 Length 77
2520 
2521 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2522 
2523 Memory Dump @0x0A64D521
2524 
2525 00000000:   30001000 af000000 d92e7c01 fea10000 ?0.........|.....         
2526 00000010:   0600c004 0021003b 0047004d 00ae0000 ?.....!.;.G.M....         
2527 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2528 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2529 00000040:   90310037 00350000 952e55c4 7e????????.1.7.5....U.~            
2530 
2531 Slot 69 Column 0 Offset 0x1d Length 4
2532 
2533 UNIQUIFIER = 174                     
2534 
2535 Slot 69 Column 1 Offset 0x21 Length 26
2536 
2537 Company = 中国你好有限公司XX分公司   
2538 
2539 Slot 69 Column 2 Offset 0x4 Length 4
2540 
2541 DepartmentID = 175                   
2542 
2543 Slot 69 Column 3 Offset 0x3b Length 12
2544 
2545 Name = 销售部175                     
2546 
2547 Slot 69 Column 4 Offset 0x47 Length 6
2548 
2549 GroupName = 销售组                   
2550 
2551 Slot 69 Column 5 Offset 0x8 Length 8
2552 
2553 ModifiedDate = 07 17 2013 11:04PM    
2554 
2555 Slot 70 Offset 0x156e Length 77
2556 
2557 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2558 
2559 Memory Dump @0x0A64D56E
2560 
2561 00000000:   30001000 b0000000 d92e7c01 fea10000 ?0.........|.....         
2562 00000010:   0600c004 0021003b 0047004d 00af0000 ?.....!.;.G.M....         
2563 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2564 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2565 00000040:   90310037 00360000 952e55c4 7e????????.1.7.6....U.~            
2566 
2567 Slot 70 Column 0 Offset 0x1d Length 4
2568 
2569 UNIQUIFIER = 175                     
2570 
2571 Slot 70 Column 1 Offset 0x21 Length 26
2572 
2573 Company = 中国你好有限公司XX分公司   
2574 
2575 Slot 70 Column 2 Offset 0x4 Length 4
2576 
2577 DepartmentID = 176                   
2578 
2579 Slot 70 Column 3 Offset 0x3b Length 12
2580 
2581 Name = 销售部176                     
2582 
2583 Slot 70 Column 4 Offset 0x47 Length 6
2584 
2585 GroupName = 销售组                   
2586 
2587 Slot 70 Column 5 Offset 0x8 Length 8
2588 
2589 ModifiedDate = 07 17 2013 11:04PM    
2590 
2591 Slot 71 Offset 0x15bb Length 77
2592 
2593 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2594 
2595 Memory Dump @0x0A64D5BB
2596 
2597 00000000:   30001000 b1000000 d92e7c01 fea10000 ?0.........|.....         
2598 00000010:   0600c004 0021003b 0047004d 00b00000 ?.....!.;.G.M....         
2599 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2600 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2601 00000040:   90310037 00370000 952e55c4 7e????????.1.7.7....U.~            
2602 
2603 Slot 71 Column 0 Offset 0x1d Length 4
2604 
2605 UNIQUIFIER = 176                     
2606 
2607 Slot 71 Column 1 Offset 0x21 Length 26
2608 
2609 Company = 中国你好有限公司XX分公司   
2610 
2611 Slot 71 Column 2 Offset 0x4 Length 4
2612 
2613 DepartmentID = 177                   
2614 
2615 Slot 71 Column 3 Offset 0x3b Length 12
2616 
2617 Name = 销售部177                     
2618 
2619 Slot 71 Column 4 Offset 0x47 Length 6
2620 
2621 GroupName = 销售组                   
2622 
2623 Slot 71 Column 5 Offset 0x8 Length 8
2624 
2625 ModifiedDate = 07 17 2013 11:04PM    
2626 
2627 Slot 72 Offset 0x1608 Length 77
2628 
2629 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2630 
2631 Memory Dump @0x0A64D608
2632 
2633 00000000:   30001000 b2000000 d92e7c01 fea10000 ?0.........|.....         
2634 00000010:   0600c004 0021003b 0047004d 00b10000 ?.....!.;.G.M....         
2635 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2636 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2637 00000040:   90310037 00380000 952e55c4 7e????????.1.7.8....U.~            
2638 
2639 Slot 72 Column 0 Offset 0x1d Length 4
2640 
2641 UNIQUIFIER = 177                     
2642 
2643 Slot 72 Column 1 Offset 0x21 Length 26
2644 
2645 Company = 中国你好有限公司XX分公司   
2646 
2647 Slot 72 Column 2 Offset 0x4 Length 4
2648 
2649 DepartmentID = 178                   
2650 
2651 Slot 72 Column 3 Offset 0x3b Length 12
2652 
2653 Name = 销售部178                     
2654 
2655 Slot 72 Column 4 Offset 0x47 Length 6
2656 
2657 GroupName = 销售组                   
2658 
2659 Slot 72 Column 5 Offset 0x8 Length 8
2660 
2661 ModifiedDate = 07 17 2013 11:04PM    
2662 
2663 Slot 73 Offset 0x1655 Length 77
2664 
2665 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2666 
2667 Memory Dump @0x0A64D655
2668 
2669 00000000:   30001000 b3000000 d92e7c01 fea10000 ?0.........|.....         
2670 00000010:   0600c004 0021003b 0047004d 00b20000 ?.....!.;.G.M....         
2671 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2672 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2673 00000040:   90310037 00390000 952e55c4 7e????????.1.7.9....U.~            
2674 
2675 Slot 73 Column 0 Offset 0x1d Length 4
2676 
2677 UNIQUIFIER = 178                     
2678 
2679 Slot 73 Column 1 Offset 0x21 Length 26
2680 
2681 Company = 中国你好有限公司XX分公司   
2682 
2683 Slot 73 Column 2 Offset 0x4 Length 4
2684 
2685 DepartmentID = 179                   
2686 
2687 Slot 73 Column 3 Offset 0x3b Length 12
2688 
2689 Name = 销售部179                     
2690 
2691 Slot 73 Column 4 Offset 0x47 Length 6
2692 
2693 GroupName = 销售组                   
2694 
2695 Slot 73 Column 5 Offset 0x8 Length 8
2696 
2697 ModifiedDate = 07 17 2013 11:04PM    
2698 
2699 Slot 74 Offset 0x16a2 Length 77
2700 
2701 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2702 
2703 Memory Dump @0x0A64D6A2
2704 
2705 00000000:   30001000 b4000000 d92e7c01 fea10000 ?0.........|.....         
2706 00000010:   0600c004 0021003b 0047004d 00b30000 ?.....!.;.G.M....         
2707 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2708 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2709 00000040:   90310038 00300000 952e55c4 7e????????.1.8.0....U.~            
2710 
2711 Slot 74 Column 0 Offset 0x1d Length 4
2712 
2713 UNIQUIFIER = 179                     
2714 
2715 Slot 74 Column 1 Offset 0x21 Length 26
2716 
2717 Company = 中国你好有限公司XX分公司   
2718 
2719 Slot 74 Column 2 Offset 0x4 Length 4
2720 
2721 DepartmentID = 180                   
2722 
2723 Slot 74 Column 3 Offset 0x3b Length 12
2724 
2725 Name = 销售部180                     
2726 
2727 Slot 74 Column 4 Offset 0x47 Length 6
2728 
2729 GroupName = 销售组                   
2730 
2731 Slot 74 Column 5 Offset 0x8 Length 8
2732 
2733 ModifiedDate = 07 17 2013 11:04PM    
2734 
2735 Slot 75 Offset 0x16ef Length 77
2736 
2737 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2738 
2739 Memory Dump @0x0A64D6EF
2740 
2741 00000000:   30001000 b5000000 d92e7c01 fea10000 ?0.........|.....         
2742 00000010:   0600c004 0021003b 0047004d 00b40000 ?.....!.;.G.M....         
2743 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2744 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2745 00000040:   90310038 00310000 952e55c4 7e????????.1.8.1....U.~            
2746 
2747 Slot 75 Column 0 Offset 0x1d Length 4
2748 
2749 UNIQUIFIER = 180                     
2750 
2751 Slot 75 Column 1 Offset 0x21 Length 26
2752 
2753 Company = 中国你好有限公司XX分公司   
2754 
2755 Slot 75 Column 2 Offset 0x4 Length 4
2756 
2757 DepartmentID = 181                   
2758 
2759 Slot 75 Column 3 Offset 0x3b Length 12
2760 
2761 Name = 销售部181                     
2762 
2763 Slot 75 Column 4 Offset 0x47 Length 6
2764 
2765 GroupName = 销售组                   
2766 
2767 Slot 75 Column 5 Offset 0x8 Length 8
2768 
2769 ModifiedDate = 07 17 2013 11:04PM    
2770 
2771 Slot 76 Offset 0x173c Length 77
2772 
2773 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2774 
2775 Memory Dump @0x0A64D73C
2776 
2777 00000000:   30001000 b6000000 d92e7c01 fea10000 ?0.........|.....         
2778 00000010:   0600c004 0021003b 0047004d 00b50000 ?.....!.;.G.M....         
2779 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2780 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2781 00000040:   90310038 00320000 952e55c4 7e????????.1.8.2....U.~            
2782 
2783 Slot 76 Column 0 Offset 0x1d Length 4
2784 
2785 UNIQUIFIER = 181                     
2786 
2787 Slot 76 Column 1 Offset 0x21 Length 26
2788 
2789 Company = 中国你好有限公司XX分公司   
2790 
2791 Slot 76 Column 2 Offset 0x4 Length 4
2792 
2793 DepartmentID = 182                   
2794 
2795 Slot 76 Column 3 Offset 0x3b Length 12
2796 
2797 Name = 销售部182                     
2798 
2799 Slot 76 Column 4 Offset 0x47 Length 6
2800 
2801 GroupName = 销售组                   
2802 
2803 Slot 76 Column 5 Offset 0x8 Length 8
2804 
2805 ModifiedDate = 07 17 2013 11:04PM    
2806 
2807 Slot 77 Offset 0x1789 Length 77
2808 
2809 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2810 
2811 Memory Dump @0x0A64D789
2812 
2813 00000000:   30001000 b7000000 da2e7c01 fea10000 ?0.........|.....         
2814 00000010:   0600c004 0021003b 0047004d 00b60000 ?.....!.;.G.M....         
2815 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2816 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2817 00000040:   90310038 00330000 952e55c4 7e????????.1.8.3....U.~            
2818 
2819 Slot 77 Column 0 Offset 0x1d Length 4
2820 
2821 UNIQUIFIER = 182                     
2822 
2823 Slot 77 Column 1 Offset 0x21 Length 26
2824 
2825 Company = 中国你好有限公司XX分公司   
2826 
2827 Slot 77 Column 2 Offset 0x4 Length 4
2828 
2829 DepartmentID = 183                   
2830 
2831 Slot 77 Column 3 Offset 0x3b Length 12
2832 
2833 Name = 销售部183                     
2834 
2835 Slot 77 Column 4 Offset 0x47 Length 6
2836 
2837 GroupName = 销售组                   
2838 
2839 Slot 77 Column 5 Offset 0x8 Length 8
2840 
2841 ModifiedDate = 07 17 2013 11:04PM    
2842 
2843 Slot 78 Offset 0x17d6 Length 77
2844 
2845 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2846 
2847 Memory Dump @0x0A64D7D6
2848 
2849 00000000:   30001000 b8000000 da2e7c01 fea10000 ?0.........|.....         
2850 00000010:   0600c004 0021003b 0047004d 00b70000 ?.....!.;.G.M....         
2851 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2852 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2853 00000040:   90310038 00340000 952e55c4 7e????????.1.8.4....U.~            
2854 
2855 Slot 78 Column 0 Offset 0x1d Length 4
2856 
2857 UNIQUIFIER = 183                     
2858 
2859 Slot 78 Column 1 Offset 0x21 Length 26
2860 
2861 Company = 中国你好有限公司XX分公司   
2862 
2863 Slot 78 Column 2 Offset 0x4 Length 4
2864 
2865 DepartmentID = 184                   
2866 
2867 Slot 78 Column 3 Offset 0x3b Length 12
2868 
2869 Name = 销售部184                     
2870 
2871 Slot 78 Column 4 Offset 0x47 Length 6
2872 
2873 GroupName = 销售组                   
2874 
2875 Slot 78 Column 5 Offset 0x8 Length 8
2876 
2877 ModifiedDate = 07 17 2013 11:04PM    
2878 
2879 Slot 79 Offset 0x1823 Length 77
2880 
2881 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2882 
2883 Memory Dump @0x0A64D823
2884 
2885 00000000:   30001000 b9000000 da2e7c01 fea10000 ?0.........|.....         
2886 00000010:   0600c004 0021003b 0047004d 00b80000 ?.....!.;.G.M....         
2887 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2888 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2889 00000040:   90310038 00350000 952e55c4 7e????????.1.8.5....U.~            
2890 
2891 Slot 79 Column 0 Offset 0x1d Length 4
2892 
2893 UNIQUIFIER = 184                     
2894 
2895 Slot 79 Column 1 Offset 0x21 Length 26
2896 
2897 Company = 中国你好有限公司XX分公司   
2898 
2899 Slot 79 Column 2 Offset 0x4 Length 4
2900 
2901 DepartmentID = 185                   
2902 
2903 Slot 79 Column 3 Offset 0x3b Length 12
2904 
2905 Name = 销售部185                     
2906 
2907 Slot 79 Column 4 Offset 0x47 Length 6
2908 
2909 GroupName = 销售组                   
2910 
2911 Slot 79 Column 5 Offset 0x8 Length 8
2912 
2913 ModifiedDate = 07 17 2013 11:04PM    
2914 
2915 Slot 80 Offset 0x1870 Length 77
2916 
2917 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2918 
2919 Memory Dump @0x0A64D870
2920 
2921 00000000:   30001000 ba000000 da2e7c01 fea10000 ?0.........|.....         
2922 00000010:   0600c004 0021003b 0047004d 00b90000 ?.....!.;.G.M....         
2923 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2924 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2925 00000040:   90310038 00360000 952e55c4 7e????????.1.8.6....U.~            
2926 
2927 Slot 80 Column 0 Offset 0x1d Length 4
2928 
2929 UNIQUIFIER = 185                     
2930 
2931 Slot 80 Column 1 Offset 0x21 Length 26
2932 
2933 Company = 中国你好有限公司XX分公司   
2934 
2935 Slot 80 Column 2 Offset 0x4 Length 4
2936 
2937 DepartmentID = 186                   
2938 
2939 Slot 80 Column 3 Offset 0x3b Length 12
2940 
2941 Name = 销售部186                     
2942 
2943 Slot 80 Column 4 Offset 0x47 Length 6
2944 
2945 GroupName = 销售组                   
2946 
2947 Slot 80 Column 5 Offset 0x8 Length 8
2948 
2949 ModifiedDate = 07 17 2013 11:04PM    
2950 
2951 Slot 81 Offset 0x18bd Length 77
2952 
2953 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2954 
2955 Memory Dump @0x0A64D8BD
2956 
2957 00000000:   30001000 bb000000 da2e7c01 fea10000 ?0.........|.....         
2958 00000010:   0600c004 0021003b 0047004d 00ba0000 ?.....!.;.G.M....         
2959 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2960 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2961 00000040:   90310038 00370000 952e55c4 7e????????.1.8.7....U.~            
2962 
2963 Slot 81 Column 0 Offset 0x1d Length 4
2964 
2965 UNIQUIFIER = 186                     
2966 
2967 Slot 81 Column 1 Offset 0x21 Length 26
2968 
2969 Company = 中国你好有限公司XX分公司   
2970 
2971 Slot 81 Column 2 Offset 0x4 Length 4
2972 
2973 DepartmentID = 187                   
2974 
2975 Slot 81 Column 3 Offset 0x3b Length 12
2976 
2977 Name = 销售部187                     
2978 
2979 Slot 81 Column 4 Offset 0x47 Length 6
2980 
2981 GroupName = 销售组                   
2982 
2983 Slot 81 Column 5 Offset 0x8 Length 8
2984 
2985 ModifiedDate = 07 17 2013 11:04PM    
2986 
2987 Slot 82 Offset 0x190a Length 77
2988 
2989 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
2990 
2991 Memory Dump @0x0A64D90A
2992 
2993 00000000:   30001000 bc000000 da2e7c01 fea10000 ?0.........|.....         
2994 00000010:   0600c004 0021003b 0047004d 00bb0000 ?.....!.;.G.M....         
2995 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
2996 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
2997 00000040:   90310038 00380000 952e55c4 7e????????.1.8.8....U.~            
2998 
2999 Slot 82 Column 0 Offset 0x1d Length 4
3000 
3001 UNIQUIFIER = 187                     
3002 
3003 Slot 82 Column 1 Offset 0x21 Length 26
3004 
3005 Company = 中国你好有限公司XX分公司   
3006 
3007 Slot 82 Column 2 Offset 0x4 Length 4
3008 
3009 DepartmentID = 188                   
3010 
3011 Slot 82 Column 3 Offset 0x3b Length 12
3012 
3013 Name = 销售部188                     
3014 
3015 Slot 82 Column 4 Offset 0x47 Length 6
3016 
3017 GroupName = 销售组                   
3018 
3019 Slot 82 Column 5 Offset 0x8 Length 8
3020 
3021 ModifiedDate = 07 17 2013 11:04PM    
3022 
3023 Slot 83 Offset 0x1957 Length 77
3024 
3025 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3026 
3027 Memory Dump @0x0A64D957
3028 
3029 00000000:   30001000 bd000000 da2e7c01 fea10000 ?0.........|.....         
3030 00000010:   0600c004 0021003b 0047004d 00bc0000 ?.....!.;.G.M....         
3031 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3032 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3033 00000040:   90310038 00390000 952e55c4 7e????????.1.8.9....U.~            
3034 
3035 Slot 83 Column 0 Offset 0x1d Length 4
3036 
3037 UNIQUIFIER = 188                     
3038 
3039 Slot 83 Column 1 Offset 0x21 Length 26
3040 
3041 Company = 中国你好有限公司XX分公司   
3042 
3043 Slot 83 Column 2 Offset 0x4 Length 4
3044 
3045 DepartmentID = 189                   
3046 
3047 Slot 83 Column 3 Offset 0x3b Length 12
3048 
3049 Name = 销售部189                     
3050 
3051 Slot 83 Column 4 Offset 0x47 Length 6
3052 
3053 GroupName = 销售组                   
3054 
3055 Slot 83 Column 5 Offset 0x8 Length 8
3056 
3057 ModifiedDate = 07 17 2013 11:04PM    
3058 
3059 Slot 84 Offset 0x19a4 Length 77
3060 
3061 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3062 
3063 Memory Dump @0x0A64D9A4
3064 
3065 00000000:   30001000 be000000 da2e7c01 fea10000 ?0.........|.....         
3066 00000010:   0600c004 0021003b 0047004d 00bd0000 ?.....!.;.G.M....         
3067 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3068 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3069 00000040:   90310039 00300000 952e55c4 7e????????.1.9.0....U.~            
3070 
3071 Slot 84 Column 0 Offset 0x1d Length 4
3072 
3073 UNIQUIFIER = 189                     
3074 
3075 Slot 84 Column 1 Offset 0x21 Length 26
3076 
3077 Company = 中国你好有限公司XX分公司   
3078 
3079 Slot 84 Column 2 Offset 0x4 Length 4
3080 
3081 DepartmentID = 190                   
3082 
3083 Slot 84 Column 3 Offset 0x3b Length 12
3084 
3085 Name = 销售部190                     
3086 
3087 Slot 84 Column 4 Offset 0x47 Length 6
3088 
3089 GroupName = 销售组                   
3090 
3091 Slot 84 Column 5 Offset 0x8 Length 8
3092 
3093 ModifiedDate = 07 17 2013 11:04PM    
3094 
3095 Slot 85 Offset 0x19f1 Length 77
3096 
3097 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3098 
3099 Memory Dump @0x0A64D9F1
3100 
3101 00000000:   30001000 bf000000 da2e7c01 fea10000 ?0.........|.....         
3102 00000010:   0600c004 0021003b 0047004d 00be0000 ?.....!.;.G.M....         
3103 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3104 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3105 00000040:   90310039 00310000 952e55c4 7e????????.1.9.1....U.~            
3106 
3107 Slot 85 Column 0 Offset 0x1d Length 4
3108 
3109 UNIQUIFIER = 190                     
3110 
3111 Slot 85 Column 1 Offset 0x21 Length 26
3112 
3113 Company = 中国你好有限公司XX分公司   
3114 
3115 Slot 85 Column 2 Offset 0x4 Length 4
3116 
3117 DepartmentID = 191                   
3118 
3119 Slot 85 Column 3 Offset 0x3b Length 12
3120 
3121 Name = 销售部191                     
3122 
3123 Slot 85 Column 4 Offset 0x47 Length 6
3124 
3125 GroupName = 销售组                   
3126 
3127 Slot 85 Column 5 Offset 0x8 Length 8
3128 
3129 ModifiedDate = 07 17 2013 11:04PM    
3130 
3131 Slot 86 Offset 0x1a3e Length 77
3132 
3133 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3134 
3135 Memory Dump @0x0A64DA3E
3136 
3137 00000000:   30001000 c0000000 da2e7c01 fea10000 ?0.........|.....         
3138 00000010:   0600c004 0021003b 0047004d 00bf0000 ?.....!.;.G.M....         
3139 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3140 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3141 00000040:   90310039 00320000 952e55c4 7e????????.1.9.2....U.~            
3142 
3143 Slot 86 Column 0 Offset 0x1d Length 4
3144 
3145 UNIQUIFIER = 191                     
3146 
3147 Slot 86 Column 1 Offset 0x21 Length 26
3148 
3149 Company = 中国你好有限公司XX分公司   
3150 
3151 Slot 86 Column 2 Offset 0x4 Length 4
3152 
3153 DepartmentID = 192                   
3154 
3155 Slot 86 Column 3 Offset 0x3b Length 12
3156 
3157 Name = 销售部192                     
3158 
3159 Slot 86 Column 4 Offset 0x47 Length 6
3160 
3161 GroupName = 销售组                   
3162 
3163 Slot 86 Column 5 Offset 0x8 Length 8
3164 
3165 ModifiedDate = 07 17 2013 11:04PM    
3166 
3167 Slot 87 Offset 0x1a8b Length 77
3168 
3169 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3170 
3171 Memory Dump @0x0A64DA8B
3172 
3173 00000000:   30001000 c1000000 da2e7c01 fea10000 ?0.........|.....         
3174 00000010:   0600c004 0021003b 0047004d 00c00000 ?.....!.;.G.M....         
3175 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3176 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3177 00000040:   90310039 00330000 952e55c4 7e????????.1.9.3....U.~            
3178 
3179 Slot 87 Column 0 Offset 0x1d Length 4
3180 
3181 UNIQUIFIER = 192                     
3182 
3183 Slot 87 Column 1 Offset 0x21 Length 26
3184 
3185 Company = 中国你好有限公司XX分公司   
3186 
3187 Slot 87 Column 2 Offset 0x4 Length 4
3188 
3189 DepartmentID = 193                   
3190 
3191 Slot 87 Column 3 Offset 0x3b Length 12
3192 
3193 Name = 销售部193                     
3194 
3195 Slot 87 Column 4 Offset 0x47 Length 6
3196 
3197 GroupName = 销售组                   
3198 
3199 Slot 87 Column 5 Offset 0x8 Length 8
3200 
3201 ModifiedDate = 07 17 2013 11:04PM    
3202 
3203 Slot 88 Offset 0x1ad8 Length 77
3204 
3205 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3206 
3207 Memory Dump @0x0A64DAD8
3208 
3209 00000000:   30001000 c2000000 da2e7c01 fea10000 ?0.........|.....         
3210 00000010:   0600c004 0021003b 0047004d 00c10000 ?.....!.;.G.M....         
3211 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3212 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3213 00000040:   90310039 00340000 952e55c4 7e????????.1.9.4....U.~            
3214 
3215 Slot 88 Column 0 Offset 0x1d Length 4
3216 
3217 UNIQUIFIER = 193                     
3218 
3219 Slot 88 Column 1 Offset 0x21 Length 26
3220 
3221 Company = 中国你好有限公司XX分公司   
3222 
3223 Slot 88 Column 2 Offset 0x4 Length 4
3224 
3225 DepartmentID = 194                   
3226 
3227 Slot 88 Column 3 Offset 0x3b Length 12
3228 
3229 Name = 销售部194                     
3230 
3231 Slot 88 Column 4 Offset 0x47 Length 6
3232 
3233 GroupName = 销售组                   
3234 
3235 Slot 88 Column 5 Offset 0x8 Length 8
3236 
3237 ModifiedDate = 07 17 2013 11:04PM    
3238 
3239 Slot 89 Offset 0x1b25 Length 77
3240 
3241 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3242 
3243 Memory Dump @0x0A64DB25
3244 
3245 00000000:   30001000 c3000000 da2e7c01 fea10000 ?0.........|.....         
3246 00000010:   0600c004 0021003b 0047004d 00c20000 ?.....!.;.G.M....         
3247 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3248 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3249 00000040:   90310039 00350000 952e55c4 7e????????.1.9.5....U.~            
3250 
3251 Slot 89 Column 0 Offset 0x1d Length 4
3252 
3253 UNIQUIFIER = 194                     
3254 
3255 Slot 89 Column 1 Offset 0x21 Length 26
3256 
3257 Company = 中国你好有限公司XX分公司   
3258 
3259 Slot 89 Column 2 Offset 0x4 Length 4
3260 
3261 DepartmentID = 195                   
3262 
3263 Slot 89 Column 3 Offset 0x3b Length 12
3264 
3265 Name = 销售部195                     
3266 
3267 Slot 89 Column 4 Offset 0x47 Length 6
3268 
3269 GroupName = 销售组                   
3270 
3271 Slot 89 Column 5 Offset 0x8 Length 8
3272 
3273 ModifiedDate = 07 17 2013 11:04PM    
3274 
3275 Slot 90 Offset 0x1b72 Length 77
3276 
3277 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3278 
3279 Memory Dump @0x0A64DB72
3280 
3281 00000000:   30001000 c4000000 db2e7c01 fea10000 ?0.........|.....         
3282 00000010:   0600c004 0021003b 0047004d 00c30000 ?.....!.;.G.M....         
3283 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3284 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3285 00000040:   90310039 00360000 952e55c4 7e????????.1.9.6....U.~            
3286 
3287 Slot 90 Column 0 Offset 0x1d Length 4
3288 
3289 UNIQUIFIER = 195                     
3290 
3291 Slot 90 Column 1 Offset 0x21 Length 26
3292 
3293 Company = 中国你好有限公司XX分公司   
3294 
3295 Slot 90 Column 2 Offset 0x4 Length 4
3296 
3297 DepartmentID = 196                   
3298 
3299 Slot 90 Column 3 Offset 0x3b Length 12
3300 
3301 Name = 销售部196                     
3302 
3303 Slot 90 Column 4 Offset 0x47 Length 6
3304 
3305 GroupName = 销售组                   
3306 
3307 Slot 90 Column 5 Offset 0x8 Length 8
3308 
3309 ModifiedDate = 07 17 2013 11:04PM    
3310 
3311 Slot 91 Offset 0x1bbf Length 77
3312 
3313 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3314 
3315 Memory Dump @0x0A64DBBF
3316 
3317 00000000:   30001000 c5000000 db2e7c01 fea10000 ?0.........|.....         
3318 00000010:   0600c004 0021003b 0047004d 00c40000 ?.....!.;.G.M....         
3319 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3320 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3321 00000040:   90310039 00370000 952e55c4 7e????????.1.9.7....U.~            
3322 
3323 Slot 91 Column 0 Offset 0x1d Length 4
3324 
3325 UNIQUIFIER = 196                     
3326 
3327 Slot 91 Column 1 Offset 0x21 Length 26
3328 
3329 Company = 中国你好有限公司XX分公司   
3330 
3331 Slot 91 Column 2 Offset 0x4 Length 4
3332 
3333 DepartmentID = 197                   
3334 
3335 Slot 91 Column 3 Offset 0x3b Length 12
3336 
3337 Name = 销售部197                     
3338 
3339 Slot 91 Column 4 Offset 0x47 Length 6
3340 
3341 GroupName = 销售组                   
3342 
3343 Slot 91 Column 5 Offset 0x8 Length 8
3344 
3345 ModifiedDate = 07 17 2013 11:04PM    
3346 
3347 Slot 92 Offset 0x1c0c Length 77
3348 
3349 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3350 
3351 Memory Dump @0x0A64DC0C
3352 
3353 00000000:   30001000 c6000000 db2e7c01 fea10000 ?0.........|.....         
3354 00000010:   0600c004 0021003b 0047004d 00c50000 ?.....!.;.G.M....         
3355 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3356 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3357 00000040:   90310039 00380000 952e55c4 7e????????.1.9.8....U.~            
3358 
3359 Slot 92 Column 0 Offset 0x1d Length 4
3360 
3361 UNIQUIFIER = 197                     
3362 
3363 Slot 92 Column 1 Offset 0x21 Length 26
3364 
3365 Company = 中国你好有限公司XX分公司   
3366 
3367 Slot 92 Column 2 Offset 0x4 Length 4
3368 
3369 DepartmentID = 198                   
3370 
3371 Slot 92 Column 3 Offset 0x3b Length 12
3372 
3373 Name = 销售部198                     
3374 
3375 Slot 92 Column 4 Offset 0x47 Length 6
3376 
3377 GroupName = 销售组                   
3378 
3379 Slot 92 Column 5 Offset 0x8 Length 8
3380 
3381 ModifiedDate = 07 17 2013 11:04PM    
3382 
3383 Slot 93 Offset 0x1c59 Length 77
3384 
3385 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3386 
3387 Memory Dump @0x0A64DC59
3388 
3389 00000000:   30001000 c7000000 db2e7c01 fea10000 ?0.........|.....         
3390 00000010:   0600c004 0021003b 0047004d 00c60000 ?.....!.;.G.M....         
3391 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3392 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3393 00000040:   90310039 00390000 952e55c4 7e????????.1.9.9....U.~            
3394 
3395 Slot 93 Column 0 Offset 0x1d Length 4
3396 
3397 UNIQUIFIER = 198                     
3398 
3399 Slot 93 Column 1 Offset 0x21 Length 26
3400 
3401 Company = 中国你好有限公司XX分公司   
3402 
3403 Slot 93 Column 2 Offset 0x4 Length 4
3404 
3405 DepartmentID = 199                   
3406 
3407 Slot 93 Column 3 Offset 0x3b Length 12
3408 
3409 Name = 销售部199                     
3410 
3411 Slot 93 Column 4 Offset 0x47 Length 6
3412 
3413 GroupName = 销售组                   
3414 
3415 Slot 93 Column 5 Offset 0x8 Length 8
3416 
3417 ModifiedDate = 07 17 2013 11:04PM    
3418 
3419 Slot 94 Offset 0x1ca6 Length 77
3420 
3421 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3422 
3423 Memory Dump @0x0A64DCA6
3424 
3425 00000000:   30001000 c8000000 db2e7c01 fea10000 ?0.........|.....         
3426 00000010:   0600c004 0021003b 0047004d 00c70000 ?.....!.;.G.M....         
3427 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3428 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3429 00000040:   90320030 00300000 952e55c4 7e????????.2.0.0....U.~            
3430 
3431 Slot 94 Column 0 Offset 0x1d Length 4
3432 
3433 UNIQUIFIER = 199                     
3434 
3435 Slot 94 Column 1 Offset 0x21 Length 26
3436 
3437 Company = 中国你好有限公司XX分公司   
3438 
3439 Slot 94 Column 2 Offset 0x4 Length 4
3440 
3441 DepartmentID = 200                   
3442 

3443 Slot 94 Column 3 Offset 0x3b Length 12
3444 
3445 Name = 销售部200                     
3446 
3447 Slot 94 Column 4 Offset 0x47 Length 6
3448 
3449 GroupName = 销售组                   
3450 
3451 Slot 94 Column 5 Offset 0x8 Length 8
3452 
3453 ModifiedDate = 07 17 2013 11:04PM    
3454 
3455 Slot 95 Offset 0x1cf3 Length 77
3456 
3457 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3458 
3459 Memory Dump @0x0A64DCF3
3460 
3461 00000000:   30001000 c9000000 db2e7c01 fea10000 ?0.........|.....         
3462 00000010:   0600c004 0021003b 0047004d 00c80000 ?.....!.;.G.M....         
3463 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3464 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3465 00000040:   90320030 00310000 952e55c4 7e????????.2.0.1....U.~            
3466 
3467 Slot 95 Column 0 Offset 0x1d Length 4
3468 
3469 UNIQUIFIER = 200                     
3470 
3471 Slot 95 Column 1 Offset 0x21 Length 26
3472 
3473 Company = 中国你好有限公司XX分公司   
3474 
3475 Slot 95 Column 2 Offset 0x4 Length 4
3476 
3477 DepartmentID = 201                   
3478 
3479 Slot 95 Column 3 Offset 0x3b Length 12
3480 
3481 Name = 销售部201                     
3482 
3483 Slot 95 Column 4 Offset 0x47 Length 6
3484 
3485 GroupName = 销售组                   
3486 
3487 Slot 95 Column 5 Offset 0x8 Length 8
3488 
3489 ModifiedDate = 07 17 2013 11:04PM    
3490 
3491 Slot 96 Offset 0x1d40 Length 77
3492 
3493 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3494 
3495 Memory Dump @0x0A64DD40
3496 
3497 00000000:   30001000 ca000000 db2e7c01 fea10000 ?0.........|.....         
3498 00000010:   0600c004 0021003b 0047004d 00c90000 ?.....!.;.G.M....         
3499 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3500 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3501 00000040:   90320030 00320000 952e55c4 7e????????.2.0.2....U.~            
3502 
3503 Slot 96 Column 0 Offset 0x1d Length 4
3504 
3505 UNIQUIFIER = 201                     
3506 
3507 Slot 96 Column 1 Offset 0x21 Length 26
3508 
3509 Company = 中国你好有限公司XX分公司   
3510 
3511 Slot 96 Column 2 Offset 0x4 Length 4
3512 
3513 DepartmentID = 202                   
3514 
3515 Slot 96 Column 3 Offset 0x3b Length 12
3516 
3517 Name = 销售部202                     
3518 
3519 Slot 96 Column 4 Offset 0x47 Length 6
3520 
3521 GroupName = 销售组                   
3522 
3523 Slot 96 Column 5 Offset 0x8 Length 8
3524 
3525 ModifiedDate = 07 17 2013 11:04PM    
3526 
3527 Slot 97 Offset 0x1d8d Length 77
3528 
3529 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3530 
3531 Memory Dump @0x0A64DD8D
3532 
3533 00000000:   30001000 cb000000 db2e7c01 fea10000 ?0.........|.....         
3534 00000010:   0600c004 0021003b 0047004d 00ca0000 ?.....!.;.G.M....         
3535 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3536 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3537 00000040:   90320030 00330000 952e55c4 7e????????.2.0.3....U.~            
3538 
3539 Slot 97 Column 0 Offset 0x1d Length 4
3540 
3541 UNIQUIFIER = 202                     
3542 
3543 Slot 97 Column 1 Offset 0x21 Length 26
3544 
3545 Company = 中国你好有限公司XX分公司   
3546 
3547 Slot 97 Column 2 Offset 0x4 Length 4
3548 
3549 DepartmentID = 203                   
3550 
3551 Slot 97 Column 3 Offset 0x3b Length 12
3552 
3553 Name = 销售部203                     
3554 
3555 Slot 97 Column 4 Offset 0x47 Length 6
3556 
3557 GroupName = 销售组                   
3558 
3559 Slot 97 Column 5 Offset 0x8 Length 8
3560 
3561 ModifiedDate = 07 17 2013 11:04PM    
3562 
3563 Slot 98 Offset 0x1dda Length 77
3564 
3565 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3566 
3567 Memory Dump @0x0A64DDDA
3568 
3569 00000000:   30001000 cc000000 db2e7c01 fea10000 ?0.........|.....         
3570 00000010:   0600c004 0021003b 0047004d 00cb0000 ?.....!.;.G.M....         
3571 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3572 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3573 00000040:   90320030 00340000 952e55c4 7e????????.2.0.4....U.~            
3574 
3575 Slot 98 Column 0 Offset 0x1d Length 4
3576 
3577 UNIQUIFIER = 203                     
3578 
3579 Slot 98 Column 1 Offset 0x21 Length 26
3580 
3581 Company = 中国你好有限公司XX分公司   
3582 
3583 Slot 98 Column 2 Offset 0x4 Length 4
3584 
3585 DepartmentID = 204                   
3586 
3587 Slot 98 Column 3 Offset 0x3b Length 12
3588 
3589 Name = 销售部204                     
3590 
3591 Slot 98 Column 4 Offset 0x47 Length 6
3592 
3593 GroupName = 销售组                   
3594 
3595 Slot 98 Column 5 Offset 0x8 Length 8
3596 
3597 ModifiedDate = 07 17 2013 11:04PM    
3598 
3599 Slot 99 Offset 0x1e27 Length 77
3600 
3601 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3602 
3603 Memory Dump @0x0A64DE27
3604 
3605 00000000:   30001000 cd000000 db2e7c01 fea10000 ?0.........|.....         
3606 00000010:   0600c004 0021003b 0047004d 00cc0000 ?.....!.;.G.M....         
3607 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3608 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3609 00000040:   90320030 00350000 952e55c4 7e????????.2.0.5....U.~            
3610 
3611 Slot 99 Column 0 Offset 0x1d Length 4
3612 
3613 UNIQUIFIER = 204                     
3614 
3615 Slot 99 Column 1 Offset 0x21 Length 26
3616 
3617 Company = 中国你好有限公司XX分公司   
3618 
3619 Slot 99 Column 2 Offset 0x4 Length 4
3620 
3621 DepartmentID = 205                   
3622 
3623 Slot 99 Column 3 Offset 0x3b Length 12
3624 
3625 Name = 销售部205                     
3626 
3627 Slot 99 Column 4 Offset 0x47 Length 6
3628 
3629 GroupName = 销售组                   
3630 
3631 Slot 99 Column 5 Offset 0x8 Length 8
3632 
3633 ModifiedDate = 07 17 2013 11:04PM    
3634 
3635 Slot 100 Offset 0x1e74 Length 77
3636 
3637 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3638 
3639 Memory Dump @0x0A64DE74
3640 
3641 00000000:   30001000 ce000000 db2e7c01 fea10000 ?0.........|.....         
3642 00000010:   0600c004 0021003b 0047004d 00cd0000 ?.....!.;.G.M....         
3643 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3644 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3645 00000040:   90320030 00360000 952e55c4 7e????????.2.0.6....U.~            
3646 
3647 Slot 100 Column 0 Offset 0x1d Length 4
3648 
3649 UNIQUIFIER = 205                     
3650 
3651 Slot 100 Column 1 Offset 0x21 Length 26
3652 
3653 Company = 中国你好有限公司XX分公司   
3654 
3655 Slot 100 Column 2 Offset 0x4 Length 4
3656 
3657 DepartmentID = 206                   
3658 
3659 Slot 100 Column 3 Offset 0x3b Length 12
3660 
3661 Name = 销售部206                     
3662 
3663 Slot 100 Column 4 Offset 0x47 Length 6
3664 
3665 GroupName = 销售组                   
3666 
3667 Slot 100 Column 5 Offset 0x8 Length 8
3668 
3669 ModifiedDate = 07 17 2013 11:04PM    
3670 
3671 Slot 101 Offset 0x1ec1 Length 77
3672 
3673 Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS
3674 
3675 Memory Dump @0x0A64DEC1
3676 
3677 00000000:   30001000 cf000000 db2e7c01 fea10000 ?0.........|.....         
3678 00000010:   0600c004 0021003b 0047004d 00ce0000 ?.....!.;.G.M....         
3679 00000020:   002d4efd 56604f7d 59096750 966c51f8 ?.-N.V`O}Y.gP.lQ.         
3680 00000030:   53580058 0006526c 51f85300 952e55e8 ?SX.X..RlQ.S...U.         
3681 00000040:   90320030 00370000 952e55c4 7e????????.2.0.7....U.~            
3682 
3683 Slot 101 Column 0 Offset 0x1d Length 4
3684 
3685 UNIQUIFIER = 206                     
3686 
3687 Slot 101 Column 1 Offset 0x21 Length 26
3688 
3689 Company = 中国你好有限公司XX分公司   
3690 
3691 Slot 101 Column 2 Offset 0x4 Length 4
3692 
3693 DepartmentID = 207                   
3694 
3695 Slot 101 Column 3 Offset 0x3b Length 12
3696 
3697 Name = 销售部207                     
3698 
3699 Slot 101 Column 4 Offset 0x47 Length 6
3700 
3701 GroupName = 销售组                   
3702 
3703 Slot 101 Column 5 Offset 0x8 Length 8
3704 
3705 ModifiedDate = 07 17 2013 11:04PM    
3706 
3707 
3708 DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。
View Code

还有增加了UNIQUIFIER 列之后,无论索引页和数据页都会有所增加,性能有所损耗

下面截图右边的是数据页pageid:14517中的数据,左边的是聚集索引页面

SQLSERVER聚集索引与非聚集索引的再次研究(上)

至于性能损耗多少,可以看一下宋大侠这篇文章:

从性能的角度谈SQL Server聚集索引键的选择

----------------------------------------------------华丽的分割线-------------------------------------------------------

 堆表中的数据页之间[PrevPagePID],[NextPagePID]是否会首尾相连

堆表

SQLSERVER聚集索引与非聚集索引的再次研究(上)

聚集索引表

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 -----------------------------------------------------华丽的分割线-------------------------------------------------

 聚集索引有一个特点,就是当表记录太少的时候不会生成任何索引页,当记录达到一定数量才生成索引页这个数量我现在还不清楚

但是就算没有索引页,SQLSERVER还会使用聚集索引查找,这个问题的确奇怪

创建Department6表,然后插入9条记录

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 --只有聚集索引
 2 USE [pratice]
 3 GO
 4 CREATE TABLE Department6
 5 (
 6   DepartmentID INT IDENTITY(1, 1) NOT NULL ,
 7   Name NVARCHAR(200) NOT NULL ,
 8   GroupName NVARCHAR(200) NOT NULL ,
 9   Company NVARCHAR(300) ,
10   ModifiedDate DATETIME NOT NULL DEFAULT ( GETDATE() ) ,
11   CONSTRAINT [PK_Department6_1] PRIMARY KEY CLUSTERED
12     (  Name ASC,DepartmentID ASC )
13     WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
14            ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY]
15 ) ON [PRIMARY]
16 
17 
18 DECLARE @i INT
19 SET @i=1
20 WHILE @i < 10
21     BEGIN
22         INSERT  INTO Department6 ( name, [Company], groupname )
23         VALUES  ( 销售部+CAST(@i AS VARCHAR(200)), 中国你好有限公司XX分公司, 销售组 )
24         SET @i = @i + 1
25     END
SQLSERVER聚集索引与非聚集索引的再次研究(上)

只有一个数据页和一个IAM页

SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

插入更多记录

SQLSERVER聚集索引与非聚集索引的再次研究(上)
1 DECLARE @i INT
2 SET @i=1
3 WHILE @i < 100000
4     BEGIN
5         INSERT  INTO Department6 ( name, [Company], groupname )
6         VALUES  ( 销售部+CAST(@i AS VARCHAR(200)), 中国你好有限公司XX分公司, 销售组 )
7         SET @i = @i + 1
8     END
SQLSERVER聚集索引与非聚集索引的再次研究(上)

开始有索引页了

SQLSERVER聚集索引与非聚集索引的再次研究(上)


---------------------------------------------华丽的分割线---------------------------------------------------

大家再看一下Department2表的那部分,究竟数据页的排序顺序跟主键DepartmentID的排序顺序有没有关系呢?

先创建Department7表,插入1000条记录

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 CREATE TABLE Department7(
 2     DepartmentID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
 3     Name NVARCHAR(200) NOT NULL,
 4     GroupName NVARCHAR(200) NOT NULL,
 5     Company NVARCHAR(300),
 6     ModifiedDate datetime NOT NULL  DEFAULT (getdate())
 7 )
 8 
 9 INSERT INTO Department7(name,[Company],groupname) VALUES(销售部,中国你好有限公司XX分公司,销售组)
10 GO 1000
11 
12 SELECT * FROM Department7
View Code
1 --TRUNCATE TABLE [dbo].[DBCCResult]
2 INSERT INTO DBCCResult EXEC (DBCC IND(pratice,Department7,-1) )
3 
4 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 


根据数据页的首尾连接顺序,我画了一下草图

SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

看一下索引页13791

SQLSERVER聚集索引与非聚集索引的再次研究(上)
1 DBCC TRACEON(3604,-1)
2 GO
3 
4 DBCC PAGE([pratice],1,13791,3)
5 GO
View Code

SQLSERVER聚集索引与非聚集索引的再次研究(上)

再画一下草图

SQLSERVER聚集索引与非聚集索引的再次研究(上)

对比一下数据页的首尾连接顺序那张图,不知道大家看出规律没有

所以我把聚集索引结构图画成下面这个样子

SQLSERVER聚集索引与非聚集索引的再次研究(上)

为什麽聚集索引只能按照第一个字段生成key?为什麽数据页只能按照第一个字段来排序?

其实这个跟数据页排序有关的,大家再仔细看下面两张图

SQLSERVER聚集索引与非聚集索引的再次研究(上)SQLSERVER聚集索引与非聚集索引的再次研究(上)

聚集索引页里根据第一个字段排列好这些数据页的第一个字段的范围值,数据页根据这个范围值首尾相连一一排序好

如果聚集索引按多个字段来排序,那么数据页根本排不了,多个字段又升序,又降序??那怎么排序啊?只能按照一个字段来排序

聚集索引查找的时候,使用order by为什麽这么快,因为数据已经根据索引第一个字段排好序了,例子中的字段就是DepartmentID

而只有非聚集索引的表order by的时候就需要排一下序了,因为表中没有聚集索引,数据页没有预先按照一定顺序来排序

详细可以看一下非聚集索引的结构:SQLSERVER聚集索引与非聚集索引的再次研究(下)

---------------------------------------------华丽的分割线--------------------------------------------------------

问题:为什么一个表只能建立一个聚集索引

其实大家看一下我上面画的聚集索引结构图和非聚集索引结构图就知道了

SQLSERVER聚集索引与非聚集索引的再次研究(上)

因为如果一个表有聚集索引,那么他的数据页跟索引页有非常强的联系,数据页跟主键第一个字段排好序了,例子中就是“DepartmentID”

如果你再建一个聚集索引,你叫SQLSERVER应该按哪个字段来排序?排序方式是按照你原来的那个聚集索引的DepartmentID列来排序还是

按照你新建的那个聚集索引的第一个字段来排序??

多个聚集索引,数据页都按不同的字段顺序排序,来建立双向链表,那数据表不就乱套了???

但是如果一个表中只有非聚集索引,非聚集索引里的索引页的每一行会有一个指针值指向数据页,数据页依然是堆,没有任何顺序可言

所以你可以在一个表上建立多个非聚集索引也没问题

至于表里面只有非聚集索引表结构是怎样的,大家可以看一下本系列的《SQLSERVER聚集索引与非聚集索引的再次研究(下)》

到时大家就会更加清楚了o(∩_∩)o

----------------------------------------------华丽的分割线----------------------------------------------------------


还有一个问题没有解决:

为什麽根节点只有两行???是不是根节点只作连接作用,所以只有两行 ?

 

聚集索引就说到这里了,有些地方有可能不对,希望大家强烈拍砖o(∩_∩)o

也希望给个推荐o(∩_∩)o

---------------------------------------------------------------------------

2013-7-21补充

为什麽根节点只有两行??其实根节点不只有两行的

由于出现二层索引节点需要插入大量数据,如果数据很少的话索引节点只有一层,并且不能用主键,只能创建聚集索引

根据宋大侠说的,当页拆分的时候,根节点就会增加记录,我这里提供一下脚本

 

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 USE [pratice]
 2 GO
 3 --------------------------------------------------------------------
 4 --只有聚集索引
 5 --DROP TABLE [dbo].[Department]
 6 CREATE TABLE Department(
 7     DepartmentID int  NOT NULL ,
 8     Name NVARCHAR(200) NOT NULL,
 9     GroupName NVARCHAR(200) NOT NULL,
10     Company NVARCHAR(300),
11     ModifiedDate datetime NOT NULL  DEFAULT (getdate())
12 )
13 
14 CREATE CLUSTERED INDEX CL_DepartmentID ON Department(DepartmentID ASC)
15 
16 DECLARE @i INT
17 SET @i=1
18 WHILE @i < 300000
19     BEGIN
20         INSERT  INTO Department([DepartmentID], name, [Company], groupname )
21         VALUES  ( @i,销售部+CAST(@i AS VARCHAR(200)), 中国你好有限公司XX分公司, 销售组+CAST(@i AS VARCHAR(200)) )
22         SET @i = @i + 3
23     END
24 
25 --DROP TABLE Department
26 SELECT * FROM Department
27 
28 
29 
30 --TRUNCATE TABLE [dbo].[DBCCResult]
31 INSERT INTO DBCCResult EXEC (DBCC IND(pratice,Department,-1) )
32 
33 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 
SQLSERVER聚集索引与非聚集索引的再次研究(上)

大家可以测试一下

插入数据的时候最好是根节点前的记录

SQLSERVER聚集索引与非聚集索引的再次研究(上)

附上宋大侠的文章:

T-SQL查询高级—SQL Server索引中的碎片和填充因子

根节点的记录行数在下面两种情况下会有所变化

(1)向表中插入数据或更新表中数据并产生碎片的时候

(2)碎片很多然后alter index REORGANIZE 重组索引的时候

1 ALTER INDEX [dbo].[TableForTest].[CIX] ON [dbo].[Department] REORGANIZE

 ------------------------------------------------------------------------------

2013-8-24  补充:

关于我在文中说的

至于应不应该在重复值很多的列上建立聚集索引我这里也不敢妄下判断,因为实际环境和这里的测试环境不一样

SQLSERVER聚集索引与非聚集索引的再次研究(上)

 

今天看了一下《SQLSERVER企业级平台管理实践》,书里面第437页是这样说的

SQLSERVER聚集索引与非聚集索引的再次研究(上)

要慎重选择索引的第一个字段,最好选择一个重复记录最少的字段。这是因为索引上的统计信息只保存第一个字段的数据直方图。如果选择一个

重复数据很多的字段,这个索引的可选度就比较低了,会影响索引的价值

 

所以,为什麽建立聚集索引的时候,只能在一个字段上建立索引,并且这个字段最好不要重复,从数据直方图上也能解释这个原因

------------------------------------------------------------------------------------------

2013-9-15 补充:

如何查看聚集索引页面的内容,使用DBCC PAGE的时候使用1这个格式就可以了

聚集索引页中有三条记录,而且三条记录的Record Type = INDEX_RECORD

1 DBCC TRACEON(3604,-1)
2 GO
3 DBCC PAGE([pratice],1,37397,1)
4 GO

SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)
 1 DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。
 2 
 3 PAGE: (1:37397)
 4 
 5 
 6 BUFFER:
 7 
 8 
 9 BUF @0x03E5DC3C
10 
11 bpage = 0x1A8D8000                   bhash = 0x00000000                   bpageno = (1:37397)
12 bdbid = 5                            breferences = 0                      bUse1 = 6487
13 bstat = 0x3c0000b                    blog = 0x212159bb                    bnext = 0x00000000
14 
15 PAGE HEADER:
16 
17 
18 Page @0x1A8D8000
19 
20 m_pageId = (1:37397)                 m_headerVersion = 1                  m_type = 2
21 m_typeFlagBits = 0x0                 m_level = 1                          m_flagBits = 0x0
22 m_objId (AllocUnitId.idObj) = 549    m_indexId (AllocUnitId.idInd) = 256  
23 Metadata: AllocUnitId = 72057594073907200                                 
24 Metadata: PartitionId = 72057594061717504                                 Metadata: IndexId = 1
25 Metadata: ObjectId = 1543676547      m_prevPage = (0:0)                   m_nextPage = (0:0)
26 pminlen = 11                         m_slotCnt = 3                        m_freeCnt = 8057
27 m_freeData = 129                     m_reservedCnt = 0                    m_lsn = (3046:261:41)
28 m_xactReserved = 0                   m_xdesId = (0:0)                     m_ghostRecCnt = 0
29 m_tornBits = 0                       
30 
31 Allocation Status
32 
33 GAM (1:2) = ALLOCATED                SGAM (1:3) = ALLOCATED               
34 PFS (1:32352) = 0x60 MIXED_EXT ALLOCATED   0_PCT_FULL                     DIFF (1:6) = CHANGED
35 ML (1:7) = NOT MIN_LOGGED            
36 
37 DATA:
38 
39 
40 Slot 0, Offset 0x60, Length 11, DumpStyle BYTE
41 
42 Record Type = INDEX_RECORD           Record Attributes =                  
43 Memory Dump @0x0A3BC060
44 
45 00000000:   06010000 00283d00 000100?????????????.....(=....              
46 
47 Slot 1, Offset 0x6b, Length 11, DumpStyle BYTE
48 
49 Record Type = INDEX_RECORD           Record Attributes =                  
50 Memory Dump @0x0A3BC06B
51 
52 00000000:   06950100 00929100 000100?????????????...........              
53 
54 Slot 2, Offset 0x76, Length 11, DumpStyle BYTE
55 
56 Record Type = INDEX_RECORD           Record Attributes =                  
57 Memory Dump @0x0A3BC076
58 
59 00000000:   06290300 002f0000 000100?????????????.).../.....              
60 
61 OFFSET TABLE:
62 
63 Row - Offset                         
64 2 (0x2) - 118 (0x76)                 
65 1 (0x1) - 107 (0x6b)                 
66 0 (0x0) - 96 (0x60)                  
67 
68 
69 DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。
SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上)

SQLSERVER聚集索引与非聚集索引的再次研究(上),布布扣,bubuko.com

SQLSERVER聚集索引与非聚集索引的再次研究(上)

上一篇:SQLSERVER聚集索引与非聚集索引的再次研究(下)


下一篇:程序员离开大厂进工厂,你会是一份子吗?【每周畅聊