General Database Report

General Database Report

Property	Value
DTM Database Content Analyzer	1.03.01
Database	SQL Server Native Client 11.0: .///AdventureWorks [AdventureWorks]
Analyzed tables	70
Total data size, bytes	69 892 712
Report created	07-Sep-2015 15:46

Table of Content

dbo.AWBuildVersion
dbo.DatabaseLog
HumanResources.Department
HumanResources.Employee
HumanResources.EmployeeAddress
HumanResources.EmployeeDepartmentHistory
HumanResources.EmployeePayHistory
HumanResources.JobCandidate
HumanResources.Shift
Person.Address
Person.AddressType
Person.Contact
Person.ContactType
Person.CountryRegion
Person.StateProvince
Production.BillOfMaterials
Production.Culture
Production.Document
Production.Illustration
Production.Location
Production.Product
Production.ProductCategory
Production.ProductCostHistory
Production.ProductDescription
Production.ProductDocument
Production.ProductInventory
Production.ProductListPriceHistory
Production.ProductModel
Production.ProductModelIllustration
Production.ProductModelProductDescriptionCulture
Production.ProductPhoto
Production.ProductProductPhoto
Production.ProductReview
Production.ProductSubcategory
Production.ScrapReason
Production.TransactionHistory
Production.TransactionHistoryArchive
Production.UnitMeasure
Production.WorkOrder
Production.WorkOrderRouting
Purchasing.ProductVendor
Purchasing.PurchaseOrderDetail
Purchasing.PurchaseOrderHeader
Purchasing.ShipMethod
Purchasing.Vendor
Purchasing.VendorAddress
Purchasing.VendorContact
Sales.ContactCreditCard
Sales.CountryRegionCurrency
Sales.CreditCard
Sales.Currency
Sales.CurrencyRate
Sales.Customer
Sales.CustomerAddress
Sales.Individual
Sales.SalesOrderDetail
Sales.SalesOrderHeader
Sales.SalesOrderHeaderSalesReason
Sales.SalesPerson
Sales.SalesPersonQuotaHistory
Sales.SalesReason
Sales.SalesTaxRate
Sales.SalesTerritory
Sales.SalesTerritoryHistory
Sales.ShoppingCartItem
Sales.SpecialOffer
Sales.SpecialOfferProduct
Sales.Store
Sales.StoreContact

Table: dbo.AWBuildVersion

Property	Value
Table description	Current version number of the AdventureWorks sample database.
Analyzed columns	4
Data rows	1
Data size, bytes	46 or 0.00 % of database size
Table has fixed row size, bytes	46

Column Statistics for 'dbo.AWBuildVersion' table

Column	Property	Value
SystemInformationID	Data type and presentation size	tinyint identity, 3
	Data length, bytes	1
	Actual data size, bytes	1 or 2.17 % of table size
	Minimum value	1
	Average value	1.00
	Maximum value	1

Column	Property	Value
Database Version	Data type and presentation size	nvarchar, 25
	Data length, bytes	50
	Actual data size, bytes	13 or 28.26 % of table size
	Minimum value length	13
	Maximum value length	13

Column	Property	Value
VersionDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	16 or 34.78 % of table size
	Minimum value	2006-04-26
	Average value	2006-04-26
	Maximum value	2006-04-26

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	16 or 34.78 % of table size
	Minimum value	2006-04-26
	Average value	2006-04-26
	Maximum value	2006-04-26

Table: dbo.DatabaseLog

Property	Value
Table description	Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
Analyzed columns	8
Data rows	389
Data size, bytes	211 519 or 0.30 % of database size
Average row size, bytes	543.75
Minimum row size, bytes	80
Maximum row size, bytes	6 848

Column Statistics for 'dbo.DatabaseLog' table

Column	Property	Value
DatabaseLogID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	1 556 or 0.74 % of table size
	Minimum value	1
	Average value	195.00
	Maximum value	389

Column	Property	Value
PostTime	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	6 224 or 2.94 % of table size
	Minimum value	2006-04-26
	Average value	2006-04-26
	Maximum value	2006-04-26

Column	Property	Value
DatabaseUser	Data type and presentation size	sysname, 128
	Data length, bytes	256
	Actual data size, bytes	1 167 or 0.55 % of table size
	Minimum value length	3
	Maximum value length	3

Column	Property	Value
Event	Data type and presentation size	sysname, 128
	Data length, bytes	256
	Actual data size, bytes	4 995 or 2.36 % of table size
	Minimum value length	11
	Maximum value length	28

Column	Property	Value
Schema	Data type and presentation size	sysname, 128
	Data length, bytes	256
	Actual data size, bytes	3 081 or 1.46 % of table size
	Minimum value length	3
	Maximum value length	14

Column	Property	Value
Object	Data type and presentation size	sysname, 128
	Data length, bytes	256
	NULL values	5 or 1.29 %
	Actual data size, bytes	7 681 or 3.63 % of table size
	Minimum value length	4
	Maximum value length	68

Column	Property	Value
TSQL	Data type and presentation size	nvarchar, 128
	Data length, bytes	0
	Actual data size, bytes	186 815 or 88.32 % of table size
	Minimum value length	13
	Maximum value length	6759

Column	Property	Value
XmlEvent	Data type and presentation size	xml, 128
	Data length, bytes	0
	Actual data size, bytes	0 or 0.00 % of table size

Table: HumanResources.Department

Property	Value
Table description	Lookup table containing the departments within the Adventure Works Cycles company.
Analyzed columns	4
Data rows	16
Data size, bytes	908 or 0.00 % of database size
Average row size, bytes	56.75
Minimum row size, bytes	41
Maximum row size, bytes	80

Column Statistics for 'HumanResources.Department' table

Column	Property	Value
DepartmentID	Data type and presentation size	smallint identity, 5
	Data length, bytes	2
	Actual data size, bytes	32 or 3.52 % of table size
	Minimum value	1
	Average value	8.50
	Maximum value	16

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	230 or 25.33 % of table size
	Minimum value length	5
	Maximum value length	26

Column	Property	Value
GroupName	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	390 or 42.95 % of table size
	Minimum value length	13
	Maximum value length	36

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	256 or 28.19 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: HumanResources.Employee

Property	Value
Table description	Employee information such as salary, department, and title.
Analyzed columns	16
Data rows	290
Data size, bytes	41 213 or 0.06 % of database size
Average row size, bytes	142.11
Minimum row size, bytes	119
Maximum row size, bytes	157

Column Statistics for 'HumanResources.Employee' table

Column	Property	Value
EmployeeID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	1 160 or 2.81 % of table size
	Minimum value	1
	Average value	145.50
	Maximum value	290

Column	Property	Value
NationalIDNumber	Data type and presentation size	nvarchar, 15
	Data length, bytes	30
	Actual data size, bytes	2 561 or 6.21 % of table size
	Minimum value length	5
	Maximum value length	9

Column	Property	Value
ContactID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 160 or 2.81 % of table size
	Minimum value	1 001
	Average value	1 145.50
	Maximum value	1 290

Column	Property	Value
LoginID	Data type and presentation size	nvarchar, 256
	Data length, bytes	512
	Actual data size, bytes	6 492 or 15.75 % of table size
	Minimum value length	19
	Maximum value length	28

Column	Property	Value
ManagerID	Data type and presentation size	int, 10
	Data length, bytes	4
	NULL values	1 or 0.34 %
	Actual data size, bytes	1 156 or 2.80 % of table size
	Minimum value	3
	Average value	107.83
	Maximum value	288

Column	Property	Value
Title	Data type and presentation size	nvarchar, 50
	Data length, bytes	100
	Actual data size, bytes	7 224 or 17.53 % of table size
	Minimum value length	5
	Maximum value length	40

Column	Property	Value
BirthDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	4 640 or 11.26 % of table size
	Minimum value	1941-11-17
	Average value	1968-07-05
	Maximum value	1981-07-01

Column	Property	Value
MaritalStatus	Data type and presentation size	nchar, 1
	Data length, bytes	2
	Actual data size, bytes	580 or 1.41 % of table size

Column	Property	Value
Gender	Data type and presentation size	nchar, 1
	Data length, bytes	2
	Actual data size, bytes	580 or 1.41 % of table size

Column	Property	Value
HireDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	4 640 or 11.26 % of table size
	Minimum value	1996-08-00
	Average value	1999-06-20
	Maximum value	2003-07-01

Column	Property	Value
SalariedFlag	Data type and presentation size	Flag, 1
	Data length, bytes	1
	Actual data size, bytes	290 or 0.70 % of table size

Column	Property	Value
VacationHours	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	580 or 1.41 % of table size
	Minimum value	0
	Average value	50.61
	Maximum value	99

Column	Property	Value
SickLeaveHours	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	580 or 1.41 % of table size
	Minimum value	20
	Average value	45.30
	Maximum value	80

Column	Property	Value
CurrentFlag	Data type and presentation size	Flag, 1
	Data length, bytes	1
	Actual data size, bytes	290 or 0.70 % of table size

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	4 640 or 11.26 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	4 640 or 11.26 % of table size
	Minimum value	2004-08-00
	Average value	2004-08-01
	Maximum value	2005-01-26

Table: HumanResources.EmployeeAddress

Property	Value
Table description	Cross-reference table mapping employees to their address(es).
Analyzed columns	4
Data rows	290
Data size, bytes	11 600 or 0.02 % of database size
Table has fixed row size, bytes	40

Column Statistics for 'HumanResources.EmployeeAddress' table

Column	Property	Value
EmployeeID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 160 or 10.00 % of table size
	Minimum value	1
	Average value	145.50
	Maximum value	290

Column	Property	Value
AddressID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 160 or 10.00 % of table size
	Minimum value	1
	Average value	2 127.76
	Maximum value	32 521

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	4 640 or 40.00 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	4 640 or 40.00 % of table size
	Minimum value	2004-10-13
	Average value	2004-10-13
	Maximum value	2004-10-13

Table: HumanResources.EmployeeDepartmentHistory

Property	Value
Table description	Employee department transfers.
Analyzed columns	6
Data rows	296
Data size, bytes	11 640 or 0.02 % of database size
Average row size, bytes	39.32
Minimum row size, bytes	39
Maximum row size, bytes	55

Column Statistics for 'HumanResources.EmployeeDepartmentHistory' table

Column	Property	Value
EmployeeID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 184 or 10.17 % of table size
	Minimum value	1
	Average value	145.23
	Maximum value	290

Column	Property	Value
DepartmentID	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	592 or 5.09 % of table size
	Minimum value	1
	Average value	7.26
	Maximum value	16

Column	Property	Value
ShiftID	Data type and presentation size	tinyint, 3
	Data length, bytes	1
	Actual data size, bytes	296 or 2.54 % of table size
	Minimum value	1
	Average value	1.56
	Maximum value	3

Column	Property	Value
StartDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	4 736 or 40.69 % of table size
	Minimum value	1996-08-00
	Average value	1999-07-06
	Maximum value	2003-12-16

Column	Property	Value
EndDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	NULL values	290 or 97.97 %
	Actual data size, bytes	96 or 0.82 % of table size
	Minimum value	1999-08-15
	Average value	2001-09-06
	Maximum value	2003-12-15

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	4 736 or 40.69 % of table size
	Minimum value	1996-07-30
	Average value	1999-07-21
	Maximum value	2003-12-15

Table: HumanResources.EmployeePayHistory

Property	Value
Table description	Employee pay history.
Analyzed columns	5
Data rows	316
Data size, bytes	18 328 or 0.03 % of database size
Table has fixed row size, bytes	58

Column Statistics for 'HumanResources.EmployeePayHistory' table

Column	Property	Value
EmployeeID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 264 or 6.90 % of table size
	Minimum value	1
	Average value	143.38
	Maximum value	290

Column	Property	Value
RateChangeDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	5 056 or 27.59 % of table size
	Minimum value	1996-08-00
	Average value	1999-09-14
	Maximum value	2003-08-15

Column	Property	Value
Rate	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	6 636 or 36.21 % of table size
	Minimum value	6.50
	Average value	6 636 or 36.21 % of table size
	Maximum value	125.50

Column	Property	Value
PayFrequency	Data type and presentation size	tinyint, 3
	Data length, bytes	1
	Actual data size, bytes	316 or 1.72 % of table size
	Minimum value	1
	Average value	1.43
	Maximum value	2

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	5 056 or 27.59 % of table size
	Minimum value	1997-12-22
	Average value	2004-03-02
	Maximum value	2004-08-00

Table: HumanResources.JobCandidate

Property	Value
Table description	Resumes submitted to Human Resources by job applicants.
Analyzed columns	4
Data rows	13
Data size, bytes	268 or 0.00 % of database size
Average row size, bytes	20.61
Minimum row size, bytes	20
Maximum row size, bytes	24

Column Statistics for 'HumanResources.JobCandidate' table

Column	Property	Value
JobCandidateID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	52 or 19.40 % of table size
	Minimum value	1
	Average value	7.00
	Maximum value	13

Column	Property	Value
EmployeeID	Data type and presentation size	int, 10
	Data length, bytes	4
	NULL values	11 or 84.62 %
	Actual data size, bytes	8 or 2.99 % of table size
	Minimum value	41
	Average value	23.76
	Maximum value	268

Column	Property	Value
Resume	Data type and presentation size	xml, 128
	Data length, bytes	0
	Actual data size, bytes	0 or 0.00 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	208 or 77.61 % of table size
	Minimum value	1997-07-24
	Average value	1998-07-24
	Maximum value	2004-01-23

Table: HumanResources.Shift

Property	Value
Table description	Work shift lookup table.
Analyzed columns	5
Data rows	3
Data size, bytes	162 or 0.00 % of database size
Average row size, bytes	54.00
Minimum row size, bytes	52
Maximum row size, bytes	56

Column Statistics for 'HumanResources.Shift' table

Column	Property	Value
ShiftID	Data type and presentation size	tinyint identity, 3
	Data length, bytes	1
	Actual data size, bytes	3 or 1.85 % of table size
	Minimum value	1
	Average value	2.00
	Maximum value	3

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	15 or 9.26 % of table size
	Minimum value length	3
	Maximum value length	7

Column	Property	Value
StartTime	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	48 or 29.63 % of table size
	Minimum value	1901-01-01
	Average value	1901-01-01
	Maximum value	1901-01-01

Column	Property	Value
EndTime	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	48 or 29.63 % of table size
	Minimum value	1901-01-01
	Average value	1901-01-01
	Maximum value	1901-01-01

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	48 or 29.63 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Person.Address

Property	Value
Table description	Street address information for customers, employees, and vendors.
Analyzed columns	8
Data rows	19 614
Data size, bytes	1 398 756 or 2.00 % of database size
Average row size, bytes	71.31
Minimum row size, bytes	57
Maximum row size, bytes	102

Column Statistics for 'Person.Address' table

Column	Property	Value
AddressID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	78 456 or 5.61 % of table size
	Minimum value	1
	Average value	19 516.28
	Maximum value	32 521

Column	Property	Value
AddressLine1	Data type and presentation size	nvarchar, 60
	Data length, bytes	120
	Actual data size, bytes	342 670 or 24.50 % of table size
	Minimum value length	5
	Maximum value length	39

Column	Property	Value
AddressLine2	Data type and presentation size	nvarchar, 60
	Data length, bytes	120
	NULL values	19252 or 98.15 %
	Actual data size, bytes	2 880 or 0.21 % of table size
	Minimum value length	1
	Maximum value length	28

Column	Property	Value
City	Data type and presentation size	nvarchar, 30
	Data length, bytes	60
	Actual data size, bytes	172 148 or 12.31 % of table size
	Minimum value length	3
	Maximum value length	21

Column	Property	Value
StateProvinceID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	78 456 or 5.61 % of table size
	Minimum value	1
	Average value	49.28
	Maximum value	181

Column	Property	Value
PostalCode	Data type and presentation size	nvarchar, 15
	Data length, bytes	30
	Actual data size, bytes	96 498 or 6.90 % of table size
	Minimum value length	2
	Maximum value length	10

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	313 824 or 22.44 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	313 824 or 22.44 % of table size
	Minimum value	1996-07-24
	Average value	2003-07-23
	Maximum value	2004-08-00

Table: Person.AddressType

Property	Value
Table description	Types of addresses stored in the Address table.
Analyzed columns	4
Data rows	6
Data size, bytes	260 or 0.00 % of database size
Average row size, bytes	43.33
Minimum row size, bytes	40
Maximum row size, bytes	47

Column Statistics for 'Person.AddressType' table

Column	Property	Value
AddressTypeID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	24 or 9.23 % of table size
	Minimum value	1
	Average value	3.50
	Maximum value	6

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	44 or 16.92 % of table size
	Minimum value length	4
	Maximum value length	11

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	96 or 36.92 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	96 or 36.92 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Person.Contact

Property	Value
Table description	Names of each employee, customer contact, and vendor contact.
Analyzed columns	15
Data rows	19 972
Data size, bytes	2 957 444 or 4.23 % of database size
Average row size, bytes	148.07
Minimum row size, bytes	134
Maximum row size, bytes	181

Column Statistics for 'Person.Contact' table

Column	Property	Value
ContactID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	79 888 or 2.70 % of table size
	Minimum value	1
	Average value	9 991.25
	Maximum value	19 977

Column	Property	Value
NameStyle	Data type and presentation size	NameStyle, 1
	Data length, bytes	1
	Actual data size, bytes	19 972 or 0.68 % of table size

Column	Property	Value
Title	Data type and presentation size	nvarchar, 8
	Data length, bytes	16
	NULL values	18963 or 94.95 %
	Actual data size, bytes	3 031 or 0.10 % of table size
	Minimum value length	2
	Maximum value length	4

Column	Property	Value
FirstName	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	117 910 or 3.99 % of table size
	Minimum value length	2
	Maximum value length	24

Column	Property	Value
MiddleName	Data type and presentation size	Name, 50
	Data length, bytes	100
	NULL values	8499 or 42.55 %
	Actual data size, bytes	12 175 or 0.41 % of table size
	Minimum value length	1
	Maximum value length	16

Column	Property	Value
LastName	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	111 969 or 3.79 % of table size
	Minimum value length	2
	Maximum value length	22

Column	Property	Value
Suffix	Data type and presentation size	nvarchar, 10
	Data length, bytes	20
	NULL values	19919 or 99.73 %
	Actual data size, bytes	150 or 0.01 % of table size
	Minimum value length	2
	Maximum value length	3

Column	Property	Value
EmailAddress	Data type and presentation size	nvarchar, 50
	Data length, bytes	100
	Actual data size, bytes	550 840 or 18.63 % of table size
	Minimum value length	22
	Maximum value length	43

Column	Property	Value
EmailPromotion	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	79 888 or 2.70 % of table size
	Minimum value	0
	Average value	0.63
	Maximum value	2

Column	Property	Value
Phone	Data type and presentation size	Phone, 25
	Data length, bytes	50
	Actual data size, bytes	303 973 or 10.28 % of table size
	Minimum value length	12
	Maximum value length	19

Column	Property	Value
PasswordHash	Data type and presentation size	varchar, 128
	Data length, bytes	128
	Actual data size, bytes	878 768 or 29.71 % of table size
	Minimum value length	44
	Maximum value length	44

Column	Property	Value
PasswordSalt	Data type and presentation size	varchar, 10
	Data length, bytes	10
	Actual data size, bytes	159 776 or 5.40 % of table size
	Minimum value length	8
	Maximum value length	8

Column	Property	Value
AdditionalContactInfo	Data type and presentation size	xml, 128
	Data length, bytes	0
	NULL values	19962 or 99.95 %
	Actual data size, bytes	0 or 0.00 % of table size

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	319 552 or 10.81 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	319 552 or 10.81 % of table size
	Minimum value	1996-07-24
	Average value	2003-06-18
	Maximum value	2005-05-16

Table: Person.ContactType

Property	Value
Table description	Lookup table containing the types of contacts stored in Contact.
Analyzed columns	3
Data rows	20
Data size, bytes	795 or 0.00 % of database size
Average row size, bytes	39.75
Minimum row size, bytes	25
Maximum row size, bytes	51

Column Statistics for 'Person.ContactType' table

Column	Property	Value
ContactTypeID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	80 or 10.06 % of table size
	Minimum value	1
	Average value	10.50
	Maximum value	20

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	395 or 49.69 % of table size
	Minimum value length	5
	Maximum value length	31

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	320 or 40.25 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Person.CountryRegion

Property	Value
Table description	Lookup table containing the ISO standard codes for countries and regions.
Analyzed columns	3
Data rows	238
Data size, bytes	6 679 or 0.01 % of database size
Average row size, bytes	28.06
Minimum row size, bytes	22
Maximum row size, bytes	62

Column Statistics for 'Person.CountryRegion' table

Column	Property	Value
CountryRegionCode	Data type and presentation size	nvarchar, 3
	Data length, bytes	6
	Actual data size, bytes	476 or 7.13 % of table size
	Minimum value length	2
	Maximum value length	2

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	2 395 or 35.86 % of table size
	Minimum value length	4
	Maximum value length	44

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	3 808 or 57.01 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Person.StateProvince

Property	Value
Table description	State and province lookup table.
Analyzed columns	8
Data rows	181
Data size, bytes	10 576 or 0.02 % of database size
Average row size, bytes	58.43
Minimum row size, bytes	52
Maximum row size, bytes	73

Column Statistics for 'Person.StateProvince' table

Column	Property	Value
StateProvinceID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	724 or 6.85 % of table size
	Minimum value	1
	Average value	91.00
	Maximum value	181

Column	Property	Value
StateProvinceCode	Data type and presentation size	nchar, 3
	Data length, bytes	6
	Actual data size, bytes	1 086 or 10.27 % of table size

Column	Property	Value
CountryRegionCode	Data type and presentation size	nvarchar, 3
	Data length, bytes	6
	Actual data size, bytes	362 or 3.42 % of table size
	Minimum value length	2
	Maximum value length	2

Column	Property	Value
IsOnlyStateProvinceFlag	Data type and presentation size	Flag, 1
	Data length, bytes	1
	Actual data size, bytes	181 or 1.71 % of table size

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	1 707 or 16.14 % of table size
	Minimum value length	3
	Maximum value length	24

Column	Property	Value
TerritoryID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	724 or 6.85 % of table size
	Minimum value	1
	Average value	5.83
	Maximum value	10

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	2 896 or 27.38 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	2 896 or 27.38 % of table size
	Minimum value	1998-06-01
	Average value	2001-01-23
	Maximum value	2004-03-11

Table: Production.BillOfMaterials

Property	Value
Table description	Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
Analyzed columns	9
Data rows	2 679
Data size, bytes	168 870 or 0.24 % of database size
Average row size, bytes	63.03
Minimum row size, bytes	58
Maximum row size, bytes	78

Column Statistics for 'Production.BillOfMaterials' table

Column	Property	Value
BillOfMaterialsID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	10 716 or 6.35 % of table size
	Minimum value	1
	Average value	1 760.27
	Maximum value	3 482

Column	Property	Value
ProductAssemblyID	Data type and presentation size	int, 10
	Data length, bytes	4
	NULL values	103 or 3.84 %
	Actual data size, bytes	10 304 or 6.10 % of table size
	Minimum value	3
	Average value	805.47
	Maximum value	999

Column	Property	Value
ComponentID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	10 716 or 6.35 % of table size
	Minimum value	1
	Average value	701.77
	Maximum value	999

Column	Property	Value
StartDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	42 864 or 25.38 % of table size
	Minimum value	2000-04-04
	Average value	2000-08-13
	Maximum value	2001-01-23

Column	Property	Value
EndDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	NULL values	2480 or 92.57 %
	Actual data size, bytes	3 184 or 1.89 % of table size
	Minimum value	2000-06-03
	Average value	2000-09-09
	Maximum value	2000-12-15

Column	Property	Value
UnitMeasureCode	Data type and presentation size	nchar, 3
	Data length, bytes	6
	Actual data size, bytes	16 074 or 9.52 % of table size

Column	Property	Value
BOMLevel	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	5 358 or 3.17 % of table size
	Minimum value	1
	Average value	1.35
	Maximum value	4

Column	Property	Value
PerAssemblyQty	Data type and presentation size	decimal, 8
	Data length, bytes	10
	Actual data size, bytes	26 790 or 15.86 % of table size
	Minimum value	1.00
	Average value	26 790 or 15.86 % of table size
	Maximum value	41.00

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	42 864 or 25.38 % of table size
	Minimum value	2000-03-21
	Average value	2000-08-05
	Maximum value	2001-01-09

Table: Production.Culture

Property	Value
Table description	Lookup table containing the languages in which some AdventureWorks data is stored.
Analyzed columns	3
Data rows	8
Data size, bytes	305 or 0.00 % of database size
Average row size, bytes	38.12
Minimum row size, bytes	32
Maximum row size, bytes	66

Column Statistics for 'Production.Culture' table

Column	Property	Value
CultureID	Data type and presentation size	nchar, 6
	Data length, bytes	12
	Actual data size, bytes	96 or 31.48 % of table size

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	81 or 26.56 % of table size
	Minimum value length	4
	Maximum value length	38

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	128 or 41.97 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Production.Document

Property	Value
Table description	Product maintenance documents.
Analyzed columns	10
Data rows	9
Data size, bytes	291 203 or 0.42 % of database size
Average row size, bytes	32 355.88
Minimum row size, bytes	23 138
Maximum row size, bytes	47 136

Column Statistics for 'Production.Document' table

Column	Property	Value
DocumentID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	36 or 0.01 % of table size
	Minimum value	1
	Average value	5.00
	Maximum value	9

Column	Property	Value
Title	Data type and presentation size	nvarchar, 50
	Data length, bytes	100
	Actual data size, bytes	239 or 0.08 % of table size
	Minimum value length	13
	Maximum value length	48

Column	Property	Value
FileName	Data type and presentation size	nvarchar, 400
	Data length, bytes	800
	Actual data size, bytes	1 427 or 0.49 % of table size
	Minimum value length	145
	Maximum value length	180

Column	Property	Value
FileExtension	Data type and presentation size	nvarchar, 8
	Data length, bytes	16
	Actual data size, bytes	36 or 0.01 % of table size
	Minimum value length	4
	Maximum value length	4

Column	Property	Value
Revision	Data type and presentation size	nchar, 5
	Data length, bytes	10
	Actual data size, bytes	90 or 0.03 % of table size

Column	Property	Value
ChangeNumber	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	36 or 0.01 % of table size
	Minimum value	8
	Average value	51.33
	Maximum value	288

Column	Property	Value
Status	Data type and presentation size	tinyint, 3
	Data length, bytes	1
	Actual data size, bytes	9 or 0.00 % of table size
	Minimum value	1
	Average value	1.88
	Maximum value	3

Column	Property	Value
DocumentSummary	Data type and presentation size	nvarchar, 128
	Data length, bytes	0
	NULL values	4 or 44.44 %
	Actual data size, bytes	1 442 or 0.50 % of table size
	Minimum value length	206
	Maximum value length	393

Column	Property	Value
Document	Data type and presentation size	varbinary, 128
	Data length, bytes	0
	Actual data size, bytes	287 744 or 98.81 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	144 or 0.05 % of table size
	Minimum value	1998-05-02
	Average value	2002-06-26
	Maximum value	2003-07-01

Table: Production.Illustration

Property	Value
Table description	Bicycle assembly diagrams.
Analyzed columns	3
Data rows	5
Data size, bytes	100 or 0.00 % of database size
Table has fixed row size, bytes	20

Column Statistics for 'Production.Illustration' table

Column	Property	Value
IllustrationID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	20 or 20.00 % of table size
	Minimum value	3
	Average value	5.00
	Maximum value	7

Column	Property	Value
Diagram	Data type and presentation size	xml, 128
	Data length, bytes	0
	Actual data size, bytes	0 or 0.00 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	80 or 80.00 % of table size
	Minimum value	2004-02-10
	Average value	2004-02-10
	Maximum value	2004-02-10

Table: Production.Location

Property	Value
Table description	Product inventory and manufacturing locations.
Analyzed columns	5
Data rows	14
Data size, bytes	754 or 0.00 % of database size
Average row size, bytes	53.85
Minimum row size, bytes	45
Maximum row size, bytes	62

Column Statistics for 'Production.Location' table

Column	Property	Value
LocationID	Data type and presentation size	smallint identity, 5
	Data length, bytes	2
	Actual data size, bytes	28 or 3.71 % of table size
	Minimum value	1
	Average value	20.21
	Maximum value	60

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	194 or 25.73 % of table size
	Minimum value length	5
	Maximum value length	22

Column	Property	Value
CostRate	Data type and presentation size	smallmoney, 10
	Data length, bytes	12
	Actual data size, bytes	168 or 22.28 % of table size
	Minimum value	12.25
	Average value	168 or 22.28 % of table size
	Maximum value	25.00

Column	Property	Value
Availability	Data type and presentation size	decimal, 8
	Data length, bytes	10
	Actual data size, bytes	140 or 18.57 % of table size
	Minimum value	80.00
	Average value	140 or 18.57 % of table size
	Maximum value	120.00

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	224 or 29.71 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Production.Product

Property	Value
Table description	Products sold or used in the manfacturing of sold products.
Analyzed columns	25
Data rows	504
Data size, bytes	78 729 or 0.11 % of database size
Average row size, bytes	156.20
Minimum row size, bytes	115
Maximum row size, bytes	210

Column Statistics for 'Production.Product' table

Column	Property	Value
ProductID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	2 016 or 2.56 % of table size
	Minimum value	1
	Average value	673.03
	Maximum value	999

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	9 278 or 11.78 % of table size
	Minimum value length	4
	Maximum value length	32

Column	Property	Value
ProductNumber	Data type and presentation size	nvarchar, 25
	Data length, bytes	50
	Actual data size, bytes	4 131 or 5.25 % of table size
	Minimum value length	7
	Maximum value length	10

Column	Property	Value
MakeFlag	Data type and presentation size	Flag, 1
	Data length, bytes	1
	Actual data size, bytes	504 or 0.64 % of table size

Column	Property	Value
FinishedGoodsFlag	Data type and presentation size	Flag, 1
	Data length, bytes	1
	Actual data size, bytes	504 or 0.64 % of table size

Column	Property	Value
Color	Data type and presentation size	nvarchar, 15
	Data length, bytes	30
	NULL values	248 or 49.21 %
	Actual data size, bytes	1 305 or 1.66 % of table size
	Minimum value length	3
	Maximum value length	12

Column	Property	Value
SafetyStockLevel	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	1 008 or 1.28 % of table size
	Minimum value	4
	Average value	535.15
	Maximum value	1 000

Column	Property	Value
ReorderPoint	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	1 008 or 1.28 % of table size
	Minimum value	3
	Average value	401.36
	Maximum value	750

Column	Property	Value
StandardCost	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	10 584 or 13.44 % of table size
	Minimum value	0.00
	Average value	10 584 or 13.44 % of table size
	Maximum value	2 171.29

Column	Property	Value
ListPrice	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	10 584 or 13.44 % of table size
	Minimum value	0.00
	Average value	10 584 or 13.44 % of table size
	Maximum value	3 578.26

Column	Property	Value
Size	Data type and presentation size	nvarchar, 5
	Data length, bytes	10
	NULL values	293 or 58.13 %
	Actual data size, bytes	391 or 0.50 % of table size
	Minimum value length	1
	Maximum value length	2

Column	Property	Value
SizeUnitMeasureCode	Data type and presentation size	nchar, 3
	Data length, bytes	6
	NULL values	328 or 65.08 %
	Actual data size, bytes	1 056 or 1.34 % of table size

Column	Property	Value
WeightUnitMeasureCode	Data type and presentation size	nchar, 3
	Data length, bytes	6
	NULL values	299 or 59.33 %
	Actual data size, bytes	1 230 or 1.56 % of table size

Column	Property	Value
Weight	Data type and presentation size	decimal, 8
	Data length, bytes	10
	NULL values	299 or 59.33 %
	Actual data size, bytes	2 050 or 2.60 % of table size
	Minimum value	2.12
	Average value	2 050 or 2.60 % of table size
	Maximum value	1 050.00

Column	Property	Value
DaysToManufacture	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	2 016 or 2.56 % of table size
	Minimum value	0
	Average value	1.10
	Maximum value	4

Column	Property	Value
ProductLine	Data type and presentation size	nchar, 2
	Data length, bytes	4
	NULL values	226 or 44.84 %
	Actual data size, bytes	1 112 or 1.41 % of table size

Column	Property	Value
Class	Data type and presentation size	nchar, 2
	Data length, bytes	4
	NULL values	257 or 50.99 %
	Actual data size, bytes	988 or 1.25 % of table size

Column	Property	Value
Style	Data type and presentation size	nchar, 2
	Data length, bytes	4
	NULL values	293 or 58.13 %
	Actual data size, bytes	844 or 1.07 % of table size

Column	Property	Value
ProductSubcategoryID	Data type and presentation size	int, 10
	Data length, bytes	4
	NULL values	209 or 41.47 %
	Actual data size, bytes	1 180 or 1.50 % of table size
	Minimum value	1
	Average value	7.19
	Maximum value	37

Column	Property	Value
ProductModelID	Data type and presentation size	int, 10
	Data length, bytes	4
	NULL values	209 or 41.47 %
	Actual data size, bytes	1 180 or 1.50 % of table size
	Minimum value	1
	Average value	21.91
	Maximum value	128

Column	Property	Value
SellStartDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	8 064 or 10.24 % of table size
	Minimum value	1998-06-01
	Average value	2000-12-00
	Maximum value	2003-07-01

Column	Property	Value
SellEndDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	NULL values	406 or 80.56 %
	Actual data size, bytes	1 568 or 1.99 % of table size
	Minimum value	2002-07-00
	Average value	2003-03-13
	Maximum value	2003-07-00

Column	Property	Value
DiscontinuedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	NULL values	504 or 100.00 %
	Actual data size, bytes	0 or 0.00 % of table size
	Minimum value	1901-01-00
	Maximum value	1901-01-00

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	8 064 or 10.24 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	8 064 or 10.24 % of table size
	Minimum value	2004-03-11
	Average value	2004-03-11
	Maximum value	2004-03-11

Table: Production.ProductCategory

Property	Value
Table description	High-level product categorization.
Analyzed columns	4
Data rows	4
Data size, bytes	178 or 0.00 % of database size
Average row size, bytes	44.50
Minimum row size, bytes	41
Maximum row size, bytes	47

Column Statistics for 'Production.ProductCategory' table

Column	Property	Value
ProductCategoryID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	16 or 8.99 % of table size
	Minimum value	1
	Average value	2.50
	Maximum value	4

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	34 or 19.10 % of table size
	Minimum value length	5
	Maximum value length	11

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	64 or 35.96 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	64 or 35.96 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Production.ProductCostHistory

Property	Value
Table description	Changes in the cost of a product over time.
Analyzed columns	5
Data rows	395
Data size, bytes	25 715 or 0.04 % of database size
Average row size, bytes	65.10
Minimum row size, bytes	57
Maximum row size, bytes	73

Column Statistics for 'Production.ProductCostHistory' table

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 580 or 6.14 % of table size
	Minimum value	707
	Average value	828.72
	Maximum value	999

Column	Property	Value
StartDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	6 320 or 24.58 % of table size
	Minimum value	2001-07-01
	Average value	2002-10-22
	Maximum value	2003-07-01

Column	Property	Value
EndDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	NULL values	195 or 49.37 %
	Actual data size, bytes	3 200 or 12.44 % of table size
	Minimum value	2002-07-00
	Average value	2003-02-18
	Maximum value	2003-07-00

Column	Property	Value
StandardCost	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	8 295 or 32.26 % of table size
	Minimum value	0.85
	Average value	8 295 or 32.26 % of table size
	Maximum value	2 171.29

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	6 320 or 24.58 % of table size
	Minimum value	2002-07-00
	Average value	2003-04-18
	Maximum value	2003-07-00

Table: Production.ProductDescription

Property	Value
Table description	Product descriptions in several languages.
Analyzed columns	4
Data rows	762
Data size, bytes	79 678 or 0.11 % of database size
Average row size, bytes	104.56
Minimum row size, bytes	39
Maximum row size, bytes	305

Column Statistics for 'Production.ProductDescription' table

Column	Property	Value
ProductDescriptionID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	3 048 or 3.83 % of table size
	Minimum value	3
	Average value	1 542.58
	Maximum value	2 010

Column	Property	Value
Description	Data type and presentation size	nvarchar, 400
	Data length, bytes	800
	Actual data size, bytes	52 246 or 65.57 % of table size
	Minimum value length	3
	Maximum value length	269

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	12 192 or 15.30 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	12 192 or 15.30 % of table size
	Minimum value	2003-06-01
	Average value	2003-07-17
	Maximum value	2004-03-11

Table: Production.ProductDocument

Property	Value
Table description	Cross-reference table mapping products to related product documents.
Analyzed columns	3
Data rows	32
Data size, bytes	768 or 0.00 % of database size
Table has fixed row size, bytes	24

Column Statistics for 'Production.ProductDocument' table

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	128 or 16.67 % of table size
	Minimum value	317
	Average value	740.06
	Maximum value	999

Column	Property	Value
DocumentID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	128 or 16.67 % of table size
	Minimum value	1
	Average value	4.21
	Maximum value	8

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	512 or 66.67 % of table size
	Minimum value	2004-01-30
	Average value	2004-01-30
	Maximum value	2004-01-30

Table: Production.ProductInventory

Property	Value
Table description	Product inventory information.
Analyzed columns	7
Data rows	1 069
Data size, bytes	45 478 or 0.07 % of database size
Average row size, bytes	42.54
Minimum row size, bytes	42
Maximum row size, bytes	44

Column Statistics for 'Production.ProductInventory' table

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	4 276 or 9.40 % of table size
	Minimum value	1
	Average value	611.96
	Maximum value	999

Column	Property	Value
LocationID	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	2 138 or 4.70 % of table size
	Minimum value	1
	Average value	23.68
	Maximum value	60

Column	Property	Value
Shelf	Data type and presentation size	nvarchar, 10
	Data length, bytes	20
	Actual data size, bytes	1 649 or 3.63 % of table size
	Minimum value length	1
	Maximum value length	3

Column	Property	Value
Bin	Data type and presentation size	tinyint, 3
	Data length, bytes	1
	Actual data size, bytes	1 069 or 2.35 % of table size
	Minimum value	0
	Average value	8.89
	Maximum value	61

Column	Property	Value
Quantity	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	2 138 or 4.70 % of table size
	Minimum value	0
	Average value	314.28
	Maximum value	924

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	17 104 or 37.61 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	17 104 or 37.61 % of table size
	Minimum value	1998-05-02
	Average value	2003-06-27
	Maximum value	2004-09-12

Table: Production.ProductListPriceHistory

Property	Value
Table description	Changes in the list price of a product over time.
Analyzed columns	5
Data rows	395
Data size, bytes	25 715 or 0.04 % of database size
Average row size, bytes	65.10
Minimum row size, bytes	57
Maximum row size, bytes	73

Column Statistics for 'Production.ProductListPriceHistory' table

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 580 or 6.14 % of table size
	Minimum value	707
	Average value	828.72
	Maximum value	999

Column	Property	Value
StartDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	6 320 or 24.58 % of table size
	Minimum value	2001-07-01
	Average value	2002-10-22
	Maximum value	2003-07-01

Column	Property	Value
EndDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	NULL values	195 or 49.37 %
	Actual data size, bytes	3 200 or 12.44 % of table size
	Minimum value	2002-07-00
	Average value	2003-02-18
	Maximum value	2003-07-00

Column	Property	Value
ListPrice	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	8 295 or 32.26 % of table size
	Minimum value	2.29
	Average value	8 295 or 32.26 % of table size
	Maximum value	3 578.26

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	6 320 or 24.58 % of table size
	Minimum value	2002-07-00
	Average value	2003-04-14
	Maximum value	2003-07-00

Table: Production.ProductModel

Property	Value
Table description	Product model classification.
Analyzed columns	6
Data rows	128
Data size, bytes	6 645 or 0.01 % of database size
Average row size, bytes	51.91
Minimum row size, bytes	41
Maximum row size, bytes	63

Column Statistics for 'Production.ProductModel' table

Column	Property	Value
ProductModelID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	512 or 7.71 % of table size
	Minimum value	1
	Average value	64.50
	Maximum value	128

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	2 037 or 30.65 % of table size
	Minimum value length	5
	Maximum value length	27

Column	Property	Value
CatalogDescription	Data type and presentation size	xml, 128
	Data length, bytes	0
	NULL values	122 or 95.31 %
	Actual data size, bytes	0 or 0.00 % of table size

Column	Property	Value
Instructions	Data type and presentation size	xml, 128
	Data length, bytes	0
	NULL values	119 or 92.97 %
	Actual data size, bytes	0 or 0.00 % of table size

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	2 048 or 30.82 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	2 048 or 30.82 % of table size
	Minimum value	1998-05-02
	Average value	2002-12-15
	Maximum value	2005-05-16

Table: Production.ProductModelIllustration

Property	Value
Table description	Cross-reference table mapping product models and illustrations.
Analyzed columns	3
Data rows	7
Data size, bytes	168 or 0.00 % of database size
Table has fixed row size, bytes	24

Column Statistics for 'Production.ProductModelIllustration' table

Column	Property	Value
ProductModelID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	28 or 16.67 % of table size
	Minimum value	7
	Average value	39.14
	Maximum value	67

Column	Property	Value
IllustrationID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	28 or 16.67 % of table size
	Minimum value	3
	Average value	4.28
	Maximum value	6

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	112 or 66.67 % of table size
	Minimum value	2004-02-10
	Average value	2004-02-10
	Maximum value	2004-02-10

Table: Production.ProductModelProductDescriptionCulture

Property	Value
Table description	Cross-reference table mapping product descriptions and the language the description is written in.
Analyzed columns	4
Data rows	762
Data size, bytes	27 432 or 0.04 % of database size
Table has fixed row size, bytes	36

Column Statistics for 'Production.ProductModelProductDescriptionCulture' table

Column	Property	Value
ProductModelID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	3 048 or 11.11 % of table size
	Minimum value	1
	Average value	64.00
	Maximum value	127

Column	Property	Value
ProductDescriptionID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	3 048 or 11.11 % of table size
	Minimum value	3
	Average value	1 542.58
	Maximum value	2 010

Column	Property	Value
CultureID	Data type and presentation size	nchar, 6
	Data length, bytes	12
	Actual data size, bytes	9 144 or 33.33 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	12 192 or 44.44 % of table size
	Minimum value	2003-06-01
	Average value	2003-06-01
	Maximum value	2003-06-01

Table: Production.ProductPhoto

Property	Value
Table description	Product images.
Analyzed columns	6
Data rows	101
Data size, bytes	2 013 474 or 2.88 % of database size
Average row size, bytes	19 935.38
Minimum row size, bytes	2 826
Maximum row size, bytes	35 318

Column Statistics for 'Production.ProductPhoto' table

Column	Property	Value
ProductPhotoID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	404 or 0.02 % of table size
	Minimum value	1
	Average value	125.77
	Maximum value	181

Column	Property	Value
ThumbNailPhoto	Data type and presentation size	varbinary, 128
	Data length, bytes	0
	Actual data size, bytes	329 917 or 16.39 % of table size

Column	Property	Value
ThumbnailPhotoFileName	Data type and presentation size	nvarchar, 50
	Data length, bytes	100
	Actual data size, bytes	2 409 or 0.12 % of table size
	Minimum value length	14
	Maximum value length	35

Column	Property	Value
LargePhoto	Data type and presentation size	varbinary, 128
	Data length, bytes	0
	Actual data size, bytes	1 676 719 or 83.27 % of table size

Column	Property	Value
LargePhotoFileName	Data type and presentation size	nvarchar, 50
	Data length, bytes	100
	Actual data size, bytes	2 409 or 0.12 % of table size
	Minimum value length	14
	Maximum value length	35

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 616 or 0.08 % of table size
	Minimum value	1998-05-02
	Average value	2002-07-21
	Maximum value	2003-06-01

Table: Production.ProductProductPhoto

Property	Value
Table description	Cross-reference table mapping products and product photos.
Analyzed columns	4
Data rows	504
Data size, bytes	12 600 or 0.02 % of database size
Table has fixed row size, bytes	25

Column Statistics for 'Production.ProductProductPhoto' table

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	2 016 or 16.00 % of table size
	Minimum value	1
	Average value	673.03
	Maximum value	999

Column	Property	Value
ProductPhotoID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	2 016 or 16.00 % of table size
	Minimum value	1
	Average value	41.67
	Maximum value	179

Column	Property	Value
Primary	Data type and presentation size	Flag, 1
	Data length, bytes	1
	Actual data size, bytes	504 or 4.00 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	8 064 or 64.00 % of table size
	Minimum value	1998-05-02
	Average value	2000-11-00
	Maximum value	2003-06-01

Table: Production.ProductReview

Property	Value
Table description	Customer reviews of products they have purchased.
Analyzed columns	8
Data rows	4
Data size, bytes	5 225 or 0.01 % of database size
Average row size, bytes	1 306.25
Minimum row size, bytes	324
Maximum row size, bytes	3 890

Column Statistics for 'Production.ProductReview' table

Column	Property	Value
ProductReviewID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	16 or 0.31 % of table size
	Minimum value	1
	Average value	2.50
	Maximum value	4

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	16 or 0.31 % of table size
	Minimum value	709
	Average value	845.25
	Maximum value	937

Column	Property	Value
ReviewerName	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	31 or 0.59 % of table size
	Minimum value length	4
	Maximum value length	12

Column	Property	Value
ReviewDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	64 or 1.22 % of table size
	Minimum value	2003-10-20
	Average value	2003-12-02
	Maximum value	2003-12-17

Column	Property	Value
EmailAddress	Data type and presentation size	nvarchar, 50
	Data length, bytes	100
	Actual data size, bytes	97 or 1.86 % of table size
	Minimum value length	21
	Maximum value length	32

Column	Property	Value
Rating	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	16 or 0.31 % of table size
	Minimum value	2
	Average value	4.00
	Maximum value	5

Column	Property	Value
Comments	Data type and presentation size	nvarchar, 3850
	Data length, bytes	7700
	Actual data size, bytes	4 921 or 94.18 % of table size
	Minimum value length	254
	Maximum value length	3812

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	64 or 1.22 % of table size
	Minimum value	2003-10-20
	Average value	2003-12-02
	Maximum value	2003-12-17

Table: Production.ProductSubcategory

Property	Value
Table description	Product subcategories. See ProductCategory table.
Analyzed columns	5
Data rows	37
Data size, bytes	1 809 or 0.00 % of database size
Average row size, bytes	48.89
Minimum row size, bytes	44
Maximum row size, bytes	57

Column Statistics for 'Production.ProductSubcategory' table

Column	Property	Value
ProductSubcategoryID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	148 or 8.18 % of table size
	Minimum value	1
	Average value	19.00
	Maximum value	37

Column	Property	Value
ProductCategoryID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	148 or 8.18 % of table size
	Minimum value	1
	Average value	2.78
	Maximum value	4

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	329 or 18.19 % of table size
	Minimum value length	4
	Maximum value length	17

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	592 or 32.73 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	592 or 32.73 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Production.ScrapReason

Property	Value
Table description	Manufacturing failure reasons lookup table.
Analyzed columns	3
Data rows	16
Data size, bytes	629 or 0.00 % of database size
Average row size, bytes	39.31
Minimum row size, bytes	32
Maximum row size, bytes	49

Column Statistics for 'Production.ScrapReason' table

Column	Property	Value
ScrapReasonID	Data type and presentation size	smallint identity, 5
	Data length, bytes	2
	Actual data size, bytes	32 or 5.09 % of table size
	Minimum value	1
	Average value	8.50
	Maximum value	16

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	341 or 54.21 % of table size
	Minimum value length	14
	Maximum value length	31

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	256 or 40.70 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Production.TransactionHistory

Property	Value
Table description	Record of each purchase order, sales order, or work order transaction year to date.
Analyzed columns	9
Data rows	113 443
Data size, bytes	8 508 225 or 12.17 % of database size
Table has fixed row size, bytes	75

Column Statistics for 'Production.TransactionHistory' table

Column	Property	Value
TransactionID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	453 772 or 5.33 % of table size
	Minimum value	100 000
	Average value	156 721.00
	Maximum value	213 442

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	453 772 or 5.33 % of table size
	Minimum value	1
	Average value	813.31
	Maximum value	999

Column	Property	Value
ReferenceOrderID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	453 772 or 5.33 % of table size
	Minimum value	417
	Average value	57 587.75
	Maximum value	75 123

Column	Property	Value
ReferenceOrderLineID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	453 772 or 5.33 % of table size
	Minimum value	0
	Average value	4.67
	Maximum value	71

Column	Property	Value
TransactionDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 815 088 or 21.33 % of table size
	Minimum value	2003-09-01
	Average value	2004-02-07
	Maximum value	2004-09-03

Column	Property	Value
TransactionType	Data type and presentation size	nchar, 1
	Data length, bytes	2
	Actual data size, bytes	226 886 or 2.67 % of table size

Column	Property	Value
Quantity	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	453 772 or 5.33 % of table size
	Minimum value	1
	Average value	35.05
	Maximum value	39 270

Column	Property	Value
ActualCost	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	2 382 303 or 28.00 % of table size
	Minimum value	0.00
	Average value	2 382 303 or 28.00 % of table size
	Maximum value	2 443.34

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 815 088 or 21.33 % of table size
	Minimum value	2003-09-01
	Average value	2004-02-07
	Maximum value	2004-09-03

Table: Production.TransactionHistoryArchive

Property	Value
Table description	Transactions for previous years.
Analyzed columns	9
Data rows	89 253
Data size, bytes	6 693 975 or 9.58 % of database size
Table has fixed row size, bytes	75

Column Statistics for 'Production.TransactionHistoryArchive' table

Column	Property	Value
TransactionID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	357 012 or 5.33 % of table size
	Minimum value	1
	Average value	44 627.00
	Maximum value	89 253

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	357 012 or 5.33 % of table size
	Minimum value	1
	Average value	734.88
	Maximum value	999

Column	Property	Value
ReferenceOrderID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	357 012 or 5.33 % of table size
	Minimum value	1
	Average value	35 121.18
	Maximum value	53 449

Column	Property	Value
ReferenceOrderLineID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	357 012 or 5.33 % of table size
	Minimum value	0
	Average value	6.77
	Maximum value	72

Column	Property	Value
TransactionDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 428 048 or 21.33 % of table size
	Minimum value	2001-05-17
	Average value	2002-10-17
	Maximum value	2003-09-00

Column	Property	Value
TransactionType	Data type and presentation size	nchar, 1
	Data length, bytes	2
	Actual data size, bytes	178 506 or 2.67 % of table size

Column	Property	Value
Quantity	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	357 012 or 5.33 % of table size
	Minimum value	1
	Average value	34.26
	Maximum value	39 570

Column	Property	Value
ActualCost	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	1 874 313 or 28.00 % of table size
	Minimum value	0.00
	Average value	1 874 313 or 28.00 % of table size
	Maximum value	3 578.26

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 428 048 or 21.33 % of table size
	Minimum value	2001-05-17
	Average value	2002-10-17
	Maximum value	2003-09-00

Table: Production.UnitMeasure

Property	Value
Table description	Unit of measure lookup table.
Analyzed columns	3
Data rows	38
Data size, bytes	1 158 or 0.00 % of database size
Average row size, bytes	30.47
Minimum row size, bytes	26
Maximum row size, bytes	42

Column Statistics for 'Production.UnitMeasure' table

Column	Property	Value
UnitMeasureCode	Data type and presentation size	nchar, 3
	Data length, bytes	6
	Actual data size, bytes	228 or 19.69 % of table size

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	322 or 27.81 % of table size
	Minimum value length	4
	Maximum value length	20

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	608 or 52.50 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Production.WorkOrder

Property	Value
Table description	Manufacturing work orders.
Analyzed columns	10
Data rows	72 591
Data size, bytes	5 953 920 or 8.52 % of database size
Average row size, bytes	82.02
Minimum row size, bytes	82
Maximum row size, bytes	84

Column Statistics for 'Production.WorkOrder' table

Column	Property	Value
WorkOrderID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	290 364 or 4.88 % of table size
	Minimum value	1
	Average value	36 296.00
	Maximum value	72 591

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	290 364 or 4.88 % of table size
	Minimum value	3
	Average value	704.32
	Maximum value	999

Column	Property	Value
OrderQty	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	290 364 or 4.88 % of table size
	Minimum value	1
	Average value	62.09
	Maximum value	39 570

Column	Property	Value
StockedQty	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	290 364 or 4.88 % of table size
	Minimum value	1
	Average value	61.95
	Maximum value	39 570

Column	Property	Value
ScrappedQty	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	145 182 or 2.44 % of table size
	Minimum value	0
	Average value	0.14
	Maximum value	673

Column	Property	Value
StartDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 161 456 or 19.51 % of table size
	Minimum value	2001-07-04
	Average value	2003-04-19
	Maximum value	2004-07-03

Column	Property	Value
EndDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 161 456 or 19.51 % of table size
	Minimum value	2001-07-14
	Average value	2003-05-02
	Maximum value	2004-07-18

Column	Property	Value
DueDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 161 456 or 19.51 % of table size
	Minimum value	2001-07-15
	Average value	2003-05-00
	Maximum value	2004-07-14

Column	Property	Value
ScrapReasonID	Data type and presentation size	smallint, 5
	Data length, bytes	2
	NULL values	71862 or 99.00 %
	Actual data size, bytes	1 458 or 0.02 % of table size
	Minimum value	1
	Average value	0.08
	Maximum value	16

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 161 456 or 19.51 % of table size
	Minimum value	2001-07-14
	Average value	2003-05-02
	Maximum value	2004-07-18

Table: Production.WorkOrderRouting

Property	Value
Table description	Work order details.
Analyzed columns	12
Data rows	67 131
Data size, bytes	9 733 995 or 13.93 % of database size
Table has fixed row size, bytes	145

Column Statistics for 'Production.WorkOrderRouting' table

Column	Property	Value
WorkOrderID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	268 524 or 2.76 % of table size
	Minimum value	13
	Average value	38 394.30
	Maximum value	72 587

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	268 524 or 2.76 % of table size
	Minimum value	514
	Average value	798.92
	Maximum value	999

Column	Property	Value
OperationSequence	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	134 262 or 1.38 % of table size
	Minimum value	1
	Average value	5.10
	Maximum value	7

Column	Property	Value
LocationID	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	134 262 or 1.38 % of table size
	Minimum value	10
	Average value	43.80
	Maximum value	60

Column	Property	Value
ScheduledStartDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 074 096 or 11.03 % of table size
	Minimum value	2001-07-04
	Average value	2003-05-22
	Maximum value	2004-07-03

Column	Property	Value
ScheduledEndDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 074 096 or 11.03 % of table size
	Minimum value	2001-07-15
	Average value	2003-06-02
	Maximum value	2004-07-14

Column	Property	Value
ActualStartDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 074 096 or 11.03 % of table size
	Minimum value	2001-07-04
	Average value	2003-05-26
	Maximum value	2004-07-18

Column	Property	Value
ActualEndDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 074 096 or 11.03 % of table size
	Minimum value	2001-07-16
	Average value	2003-06-07
	Maximum value	2004-07-29

Column	Property	Value
ActualResourceHrs	Data type and presentation size	decimal, 9
	Data length, bytes	11
	Actual data size, bytes	738 441 or 7.59 % of table size
	Minimum value	1.00
	Average value	738 441 or 7.59 % of table size
	Maximum value	4.09

Column	Property	Value
PlannedCost	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	1 409 751 or 14.48 % of table size
	Minimum value	14.50
	Average value	1 409 751 or 14.48 % of table size
	Maximum value	92.25

Column	Property	Value
ActualCost	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	1 409 751 or 14.48 % of table size
	Minimum value	14.50
	Average value	1 409 751 or 14.48 % of table size
	Maximum value	92.25

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 074 096 or 11.03 % of table size
	Minimum value	2001-07-16
	Average value	2003-06-07
	Maximum value	2004-07-29

Table: Purchasing.ProductVendor

Property	Value
Table description	Cross-reference table mapping vendors with the products they supply.
Analyzed columns	11
Data rows	460
Data size, bytes	46 620 or 0.07 % of database size
Average row size, bytes	101.34
Minimum row size, bytes	100
Maximum row size, bytes	104

Column Statistics for 'Purchasing.ProductVendor' table

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 840 or 3.95 % of table size
	Minimum value	1
	Average value	517.24
	Maximum value	952

Column	Property	Value
VendorID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 840 or 3.95 % of table size
	Minimum value	1
	Average value	51.35
	Maximum value	104

Column	Property	Value
AverageLeadTime	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 840 or 3.95 % of table size
	Minimum value	10
	Average value	19.44
	Maximum value	120

Column	Property	Value
StandardPrice	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	9 660 or 20.72 % of table size
	Minimum value	0.20
	Average value	9 660 or 20.72 % of table size
	Maximum value	78.89

Column	Property	Value
LastReceiptCost	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	9 660 or 20.72 % of table size
	Minimum value	0.21
	Average value	9 660 or 20.72 % of table size
	Maximum value	82.83

Column	Property	Value
LastReceiptDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	7 360 or 15.79 % of table size
	Minimum value	2001-08-22
	Average value	2002-01-10
	Maximum value	2004-11-22

Column	Property	Value
MinOrderQty	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 840 or 3.95 % of table size
	Minimum value	1
	Average value	145.90
	Maximum value	5 000

Column	Property	Value
MaxOrderQty	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	1 840 or 3.95 % of table size
	Minimum value	5
	Average value	776.46
	Maximum value	15 000

Column	Property	Value
OnOrderQty	Data type and presentation size	int, 10
	Data length, bytes	4
	NULL values	305 or 66.30 %
	Actual data size, bytes	620 or 1.33 % of table size
	Minimum value	3
	Average value	222.63
	Maximum value	8 000

Column	Property	Value
UnitMeasureCode	Data type and presentation size	nchar, 3
	Data length, bytes	6
	Actual data size, bytes	2 760 or 5.92 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	7 360 or 15.79 % of table size
	Minimum value	2001-08-22
	Average value	2002-03-07
	Maximum value	2005-09-12

Table: Purchasing.PurchaseOrderDetail

Property	Value
Table description	Individual products associated with a specific purchase order. See PurchaseOrderHeader.
Analyzed columns	11
Data rows	8 845
Data size, bytes	1 052 555 or 1.51 % of database size
Table has fixed row size, bytes	119

Column Statistics for 'Purchasing.PurchaseOrderDetail' table

Column	Property	Value
PurchaseOrderID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	35 380 or 3.36 % of table size
	Minimum value	1
	Average value	1 992.32
	Maximum value	4 012

Column	Property	Value
PurchaseOrderDetailID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	35 380 or 3.36 % of table size
	Minimum value	1
	Average value	4 423.00
	Maximum value	8 845

Column	Property	Value
DueDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	141 520 or 13.45 % of table size
	Minimum value	2001-06-00
	Average value	2004-02-07
	Maximum value	2004-11-22

Column	Property	Value
OrderQty	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	17 690 or 1.68 % of table size
	Minimum value	3
	Average value	265.53
	Maximum value	8 000

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	35 380 or 3.36 % of table size
	Minimum value	1
	Average value	527.50
	Maximum value	952

Column	Property	Value
UnitPrice	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	185 745 or 17.65 % of table size
	Minimum value	0.21
	Average value	185 745 or 17.65 % of table size
	Maximum value	82.83

Column	Property	Value
LineTotal	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	185 745 or 17.65 % of table size
	Minimum value	37.07
	Average value	185 745 or 17.65 % of table size
	Maximum value	249 420.00

Column	Property	Value
ReceivedQty	Data type and presentation size	decimal, 8
	Data length, bytes	10
	Actual data size, bytes	88 450 or 8.40 % of table size
	Minimum value	2.00
	Average value	88 450 or 8.40 % of table size
	Maximum value	8 000.00

Column	Property	Value
RejectedQty	Data type and presentation size	decimal, 8
	Data length, bytes	10
	Actual data size, bytes	88 450 or 8.40 % of table size
	Minimum value	0.00
	Average value	88 450 or 8.40 % of table size
	Maximum value	1 250.00

Column	Property	Value
StockedQty	Data type and presentation size	decimal, 9
	Data length, bytes	11
	Actual data size, bytes	97 295 or 9.24 % of table size
	Minimum value	0.00
	Average value	97 295 or 9.24 % of table size
	Maximum value	8 000.00

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	141 520 or 13.45 % of table size
	Minimum value	2001-05-24
	Average value	2004-02-03
	Maximum value	2005-09-12

Table: Purchasing.PurchaseOrderHeader

Property	Value
Table description	General purchase order information. See PurchaseOrderDetail.
Analyzed columns	13
Data rows	4 012
Data size, bytes	601 800 or 0.86 % of database size
Table has fixed row size, bytes	150

Column Statistics for 'Purchasing.PurchaseOrderHeader' table

Column	Property	Value
PurchaseOrderID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	16 048 or 2.67 % of table size
	Minimum value	1
	Average value	2 006.50
	Maximum value	4 012

Column	Property	Value
RevisionNumber	Data type and presentation size	tinyint, 3
	Data length, bytes	1
	Actual data size, bytes	4 012 or 0.67 % of table size
	Minimum value	0
	Average value	0.08
	Maximum value	16

Column	Property	Value
Status	Data type and presentation size	tinyint, 3
	Data length, bytes	1
	Actual data size, bytes	4 012 or 0.67 % of table size
	Minimum value	1
	Average value	3.80
	Maximum value	4

Column	Property	Value
EmployeeID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	16 048 or 2.67 % of table size
	Minimum value	164
	Average value	236.58
	Maximum value	274

Column	Property	Value
VendorID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	16 048 or 2.67 % of table size
	Minimum value	1
	Average value	51.45
	Maximum value	104

Column	Property	Value
ShipMethodID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	16 048 or 2.67 % of table size
	Minimum value	1
	Average value	3.57
	Maximum value	5

Column	Property	Value
OrderDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	64 192 or 10.67 % of table size
	Minimum value	2001-05-17
	Average value	2004-01-28
	Maximum value	2004-10-23

Column	Property	Value
ShipDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	64 192 or 10.67 % of table size
	Minimum value	2001-05-26
	Average value	2004-02-06
	Maximum value	2004-11-17

Column	Property	Value
SubTotal	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	84 252 or 14.00 % of table size
	Minimum value	37.07
	Average value	84 252 or 14.00 % of table size
	Maximum value	997 680.00

Column	Property	Value
TaxAmt	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	84 252 or 14.00 % of table size
	Minimum value	2.96
	Average value	84 252 or 14.00 % of table size
	Maximum value	79 814.39

Column	Property	Value
Freight	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	84 252 or 14.00 % of table size
	Minimum value	0.92
	Average value	84 252 or 14.00 % of table size
	Maximum value	19 953.59

Column	Property	Value
TotalDue	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	84 252 or 14.00 % of table size
	Minimum value	40.96
	Average value	84 252 or 14.00 % of table size
	Maximum value	1 097 448.00

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	64 192 or 10.67 % of table size
	Minimum value	2001-05-26
	Average value	2004-02-07
	Maximum value	2005-09-12

Table: Purchasing.ShipMethod

Property	Value
Table description	Shipping company lookup table.
Analyzed columns	6
Data rows	5
Data size, bytes	470 or 0.00 % of database size
Average row size, bytes	94.00
Minimum row size, bytes	90
Maximum row size, bytes	96

Column Statistics for 'Purchasing.ShipMethod' table

Column	Property	Value
ShipMethodID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	20 or 4.26 % of table size
	Minimum value	1
	Average value	3.00
	Maximum value	5

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	80 or 17.02 % of table size
	Minimum value length	12
	Maximum value length	18

Column	Property	Value
ShipBase	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	105 or 22.34 % of table size
	Minimum value	3.95
	Average value	105 or 22.34 % of table size
	Maximum value	29.94

Column	Property	Value
ShipRate	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	105 or 22.34 % of table size
	Minimum value	0.99
	Average value	105 or 22.34 % of table size
	Maximum value	2.99

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	80 or 17.02 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	80 or 17.02 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Purchasing.Vendor

Property	Value
Table description	Companies from whom Adventure Works Cycles purchases parts or other goods.
Analyzed columns	8
Data rows	104
Data size, bytes	5 601 or 0.01 % of database size
Average row size, bytes	53.85
Minimum row size, bytes	37
Maximum row size, bytes	81

Column Statistics for 'Purchasing.Vendor' table

Column	Property	Value
VendorID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	416 or 7.43 % of table size
	Minimum value	1
	Average value	52.50
	Maximum value	104

Column	Property	Value
AccountNumber	Data type and presentation size	AccountNumber, 15
	Data length, bytes	30
	Actual data size, bytes	1 169 or 20.87 % of table size
	Minimum value length	9
	Maximum value length	12

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	1 915 or 34.19 % of table size
	Minimum value length	5
	Maximum value length	33

Column	Property	Value
CreditRating	Data type and presentation size	tinyint, 3
	Data length, bytes	1
	Actual data size, bytes	104 or 1.86 % of table size
	Minimum value	1
	Average value	1.35
	Maximum value	5

Column	Property	Value
PreferredVendorStatus	Data type and presentation size	Flag, 1
	Data length, bytes	1
	Actual data size, bytes	104 or 1.86 % of table size

Column	Property	Value
ActiveFlag	Data type and presentation size	Flag, 1
	Data length, bytes	1
	Actual data size, bytes	104 or 1.86 % of table size

Column	Property	Value
PurchasingWebServiceURL	Data type and presentation size	nvarchar, 1024
	Data length, bytes	2048
	NULL values	98 or 94.23 %
	Actual data size, bytes	125 or 2.23 % of table size
	Minimum value length	15
	Maximum value length	27

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 664 or 29.71 % of table size
	Minimum value	2001-05-26
	Average value	2002-01-28
	Maximum value	2002-03-21

Table: Purchasing.VendorAddress

Property	Value
Table description	Cross-reference mapping vendors and addresses.
Analyzed columns	4
Data rows	104
Data size, bytes	2 912 or 0.00 % of database size
Table has fixed row size, bytes	28

Column Statistics for 'Purchasing.VendorAddress' table

Column	Property	Value
VendorID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	416 or 14.29 % of table size
	Minimum value	1
	Average value	52.50
	Maximum value	104

Column	Property	Value
AddressID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	416 or 14.29 % of table size
	Minimum value	301
	Average value	352.50
	Maximum value	404

Column	Property	Value
AddressTypeID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	416 or 14.29 % of table size
	Minimum value	3
	Average value	3.00
	Maximum value	3

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 664 or 57.14 % of table size
	Minimum value	2001-05-26
	Average value	2002-01-28
	Maximum value	2002-03-21

Table: Purchasing.VendorContact

Property	Value
Table description	Cross-reference table mapping vendors and their employees.
Analyzed columns	4
Data rows	156
Data size, bytes	4 368 or 0.01 % of database size
Table has fixed row size, bytes	28

Column Statistics for 'Purchasing.VendorContact' table

Column	Property	Value
VendorID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	624 or 14.29 % of table size
	Minimum value	1
	Average value	51.94
	Maximum value	104

Column	Property	Value
ContactID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	624 or 14.29 % of table size
	Minimum value	601
	Average value	758.08
	Maximum value	995

Column	Property	Value
ContactTypeID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	624 or 14.29 % of table size
	Minimum value	2
	Average value	16.06
	Maximum value	19

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	2 496 or 57.14 % of table size
	Minimum value	2001-05-26
	Average value	2002-01-18
	Maximum value	2002-03-21

Table: Sales.ContactCreditCard

Property	Value
Table description	Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.
Analyzed columns	3
Data rows	19 118
Data size, bytes	458 832 or 0.66 % of database size
Table has fixed row size, bytes	24

Column Statistics for 'Sales.ContactCreditCard' table

Column	Property	Value
ContactID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	76 472 or 16.67 % of table size
	Minimum value	2
	Average value	10 388.61
	Maximum value	19 977

Column	Property	Value
CreditCardID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	76 472 or 16.67 % of table size
	Minimum value	1
	Average value	9 567.66
	Maximum value	19 237

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	305 888 or 66.67 % of table size
	Minimum value	2001-07-01
	Average value	2003-08-07
	Maximum value	2004-08-00

Table: Sales.CountryRegionCurrency

Property	Value
Table description	Cross-reference table mapping ISO currency codes to a country or region.
Analyzed columns	3
Data rows	109
Data size, bytes	2 616 or 0.00 % of database size
Table has fixed row size, bytes	24

Column Statistics for 'Sales.CountryRegionCurrency' table

Column	Property	Value
CountryRegionCode	Data type and presentation size	nvarchar, 3
	Data length, bytes	6
	Actual data size, bytes	218 or 8.33 % of table size
	Minimum value length	2
	Maximum value length	2

Column	Property	Value
CurrencyCode	Data type and presentation size	nchar, 3
	Data length, bytes	6
	Actual data size, bytes	654 or 25.00 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 744 or 66.67 % of table size
	Minimum value	1998-06-01
	Average value	2003-08-30
	Maximum value	2004-03-11

Table: Sales.CreditCard

Property	Value
Table description	Customer credit card information.
Analyzed columns	6
Data rows	19 118
Data size, bytes	904 077 or 1.29 % of database size
Average row size, bytes	47.28
Minimum row size, bytes	42
Maximum row size, bytes	50

Column Statistics for 'Sales.CreditCard' table

Column	Property	Value
CreditCardID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	76 472 or 8.46 % of table size
	Minimum value	1
	Average value	9 567.66
	Maximum value	19 237

Column	Property	Value
CardType	Data type and presentation size	nvarchar, 50
	Data length, bytes	100
	Actual data size, bytes	196 711 or 21.76 % of table size
	Minimum value length	5
	Maximum value length	13

Column	Property	Value
CardNumber	Data type and presentation size	nvarchar, 25
	Data length, bytes	50
	Actual data size, bytes	267 652 or 29.61 % of table size
	Minimum value length	14
	Maximum value length	14

Column	Property	Value
ExpMonth	Data type and presentation size	tinyint, 3
	Data length, bytes	1
	Actual data size, bytes	19 118 or 2.11 % of table size
	Minimum value	1
	Average value	6.52
	Maximum value	12

Column	Property	Value
ExpYear	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	38 236 or 4.23 % of table size
	Minimum value	2 005
	Average value	2 006.50
	Maximum value	2 008

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	305 888 or 33.83 % of table size
	Minimum value	1996-07-24
	Average value	2003-06-22
	Maximum value	2004-08-00

Table: Sales.Currency

Property	Value
Table description	Lookup table containing standard ISO currencies.
Analyzed columns	3
Data rows	105
Data size, bytes	3 577 or 0.01 % of database size
Average row size, bytes	34.06
Minimum row size, bytes	25
Maximum row size, bytes	51

Column Statistics for 'Sales.Currency' table

Column	Property	Value
CurrencyCode	Data type and presentation size	nchar, 3
	Data length, bytes	6
	Actual data size, bytes	630 or 17.61 % of table size

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	1 267 or 35.42 % of table size
	Minimum value length	3
	Maximum value length	29

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 680 or 46.97 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Sales.CurrencyRate

Property	Value
Table description	Currency exchange rates.
Analyzed columns	7
Data rows	13 532
Data size, bytes	1 217 880 or 1.74 % of database size
Table has fixed row size, bytes	90

Column Statistics for 'Sales.CurrencyRate' table

Column	Property	Value
CurrencyRateID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	54 128 or 4.44 % of table size
	Minimum value	1
	Average value	6 766.50
	Maximum value	13 532

Column	Property	Value
CurrencyRateDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	216 512 or 17.78 % of table size
	Minimum value	2001-07-01
	Average value	2002-12-18
	Maximum value	2004-07-01

Column	Property	Value
FromCurrencyCode	Data type and presentation size	nchar, 3
	Data length, bytes	6
	Actual data size, bytes	81 192 or 6.67 % of table size

Column	Property	Value
ToCurrencyCode	Data type and presentation size	nchar, 3
	Data length, bytes	6
	Actual data size, bytes	81 192 or 6.67 % of table size

Column	Property	Value
AverageRate	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	284 172 or 23.33 % of table size
	Minimum value	0.60
	Average value	284 172 or 23.33 % of table size
	Maximum value	1 500.00

Column	Property	Value
EndOfDayRate	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	284 172 or 23.33 % of table size
	Minimum value	0.60
	Average value	284 172 or 23.33 % of table size
	Maximum value	1 499.95

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	216 512 or 17.78 % of table size
	Minimum value	2001-07-01
	Average value	2003-01-19
	Maximum value	2004-07-01

Table: Sales.Customer

Property	Value
Table description	Current customer information. Also see the Individual and Store tables.
Analyzed columns	6
Data rows	19 185
Data size, bytes	997 620 or 1.43 % of database size
Table has fixed row size, bytes	52

Column Statistics for 'Sales.Customer' table

Column	Property	Value
CustomerID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	76 740 or 7.69 % of table size
	Minimum value	1
	Average value	19 514.72
	Maximum value	29 483

Column	Property	Value
TerritoryID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	76 740 or 7.69 % of table size
	Minimum value	1
	Average value	5.85
	Maximum value	10

Column	Property	Value
AccountNumber	Data type and presentation size	varchar, 10
	Data length, bytes	10
	Actual data size, bytes	191 850 or 19.23 % of table size
	Minimum value length	10
	Maximum value length	10

Column	Property	Value
CustomerType	Data type and presentation size	nchar, 1
	Data length, bytes	2
	Actual data size, bytes	38 370 or 3.85 % of table size

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	306 960 or 30.77 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	306 960 or 30.77 % of table size
	Minimum value	2004-10-13
	Average value	2004-10-13
	Maximum value	2004-10-13

Table: Sales.CustomerAddress

Property	Value
Table description	Cross-reference table mapping customers to their address(es).
Analyzed columns	5
Data rows	19 220
Data size, bytes	845 680 or 1.21 % of database size
Table has fixed row size, bytes	44

Column Statistics for 'Sales.CustomerAddress' table

Column	Property	Value
CustomerID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	76 880 or 9.09 % of table size
	Minimum value	1
	Average value	19 502.35
	Maximum value	29 483

Column	Property	Value
AddressID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	76 880 or 9.09 % of table size
	Minimum value	9
	Average value	19 882.34
	Maximum value	29 883

Column	Property	Value
AddressTypeID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	76 880 or 9.09 % of table size
	Minimum value	2
	Average value	2.04
	Maximum value	5

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	307 520 or 36.36 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	307 520 or 36.36 % of table size
	Minimum value	2001-07-01
	Average value	2003-08-05
	Maximum value	2004-08-00

Table: Sales.Individual

Property	Value
Table description	Demographic data about customers that purchase Adventure Works products online.
Analyzed columns	4
Data rows	18 484
Data size, bytes	443 616 or 0.63 % of database size
Table has fixed row size, bytes	24

Column Statistics for 'Sales.Individual' table

Column	Property	Value
CustomerID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	73 936 or 16.67 % of table size
	Minimum value	11 000
	Average value	20 241.50
	Maximum value	29 483

Column	Property	Value
ContactID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	73 936 or 16.67 % of table size
	Minimum value	705
	Average value	10 731.82
	Maximum value	19 977

Column	Property	Value
Demographics	Data type and presentation size	xml, 128
	Data length, bytes	0
	Actual data size, bytes	0 or 0.00 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	295 744 or 66.67 % of table size
	Minimum value	2004-10-19
	Average value	2004-10-19
	Maximum value	2004-10-19

Table: Sales.SalesOrderDetail

Property	Value
Table description	Individual products associated with a specific sales order. See SalesOrderHeader.
Analyzed columns	11
Data rows	121 317
Data size, bytes	16 744 872 or 23.96 % of database size
Average row size, bytes	138.02
Minimum row size, bytes	132
Maximum row size, bytes	144

Column Statistics for 'Sales.SalesOrderDetail' table

Column	Property	Value
SalesOrderID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	485 268 or 2.90 % of table size
	Minimum value	43 659
	Average value	57 827.36
	Maximum value	75 123

Column	Property	Value
SalesOrderDetailID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	485 268 or 2.90 % of table size
	Minimum value	1
	Average value	60 659.00
	Maximum value	121 317

Column	Property	Value
CarrierTrackingNumber	Data type and presentation size	nvarchar, 25
	Data length, bytes	50
	NULL values	60398 or 49.79 %
	Actual data size, bytes	731 028 or 4.37 % of table size
	Minimum value length	12
	Maximum value length	12

Column	Property	Value
OrderQty	Data type and presentation size	smallint, 5
	Data length, bytes	2
	Actual data size, bytes	242 634 or 1.45 % of table size
	Minimum value	1
	Average value	2.26
	Maximum value	44

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	485 268 or 2.90 % of table size
	Minimum value	707
	Average value	841.68
	Maximum value	999

Column	Property	Value
SpecialOfferID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	485 268 or 2.90 % of table size
	Minimum value	1
	Average value	1.16
	Maximum value	16

Column	Property	Value
UnitPrice	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	2 547 657 or 15.21 % of table size
	Minimum value	1.32
	Average value	2 547 657 or 15.21 % of table size
	Maximum value	3 578.26

Column	Property	Value
UnitPriceDiscount	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	2 547 657 or 15.21 % of table size
	Minimum value	0.00
	Average value	2 547 657 or 15.21 % of table size
	Maximum value	0.40

Column	Property	Value
LineTotal	Data type and presentation size	numeric, 38
	Data length, bytes	40
	Actual data size, bytes	4 852 680 or 28.98 % of table size
	Minimum value	1.37
	Average value	4 852 680 or 28.98 % of table size
	Maximum value	27 893.61

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	1 941 072 or 11.59 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	1 941 072 or 11.59 % of table size
	Minimum value	2001-07-01
	Average value	2003-08-16
	Maximum value	2004-08-00

Table: Sales.SalesOrderHeader

Property	Value
Table description	General sales order information.
Analyzed columns	27
Data rows	31 465
Data size, bytes	7 431 047 or 10.63 % of database size
Average row size, bytes	236.16
Minimum row size, bytes	216
Maximum row size, bytes	254

Column Statistics for 'Sales.SalesOrderHeader' table

Column	Property	Value
SalesOrderID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	125 860 or 1.69 % of table size
	Minimum value	43 659
	Average value	59 391.00
	Maximum value	75 123

Column	Property	Value
RevisionNumber	Data type and presentation size	tinyint, 3
	Data length, bytes	1
	Actual data size, bytes	31 465 or 0.42 % of table size
	Minimum value	1
	Average value	1.00
	Maximum value	2

Column	Property	Value
OrderDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	503 440 or 6.77 % of table size
	Minimum value	2001-07-01
	Average value	2003-09-22
	Maximum value	2004-08-00

Column	Property	Value
DueDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	503 440 or 6.77 % of table size
	Minimum value	2001-07-13
	Average value	2003-10-04
	Maximum value	2004-08-12

Column	Property	Value
ShipDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	503 440 or 6.77 % of table size
	Minimum value	2001-07-08
	Average value	2003-09-29
	Maximum value	2004-08-07

Column	Property	Value
Status	Data type and presentation size	tinyint, 3
	Data length, bytes	1
	Actual data size, bytes	31 465 or 0.42 % of table size
	Minimum value	5
	Average value	5.00
	Maximum value	5

Column	Property	Value
OnlineOrderFlag	Data type and presentation size	Flag, 1
	Data length, bytes	1
	Actual data size, bytes	31 465 or 0.42 % of table size

Column	Property	Value
SalesOrderNumber	Data type and presentation size	nvarchar, 25
	Data length, bytes	50
	Actual data size, bytes	220 255 or 2.96 % of table size
	Minimum value length	7
	Maximum value length	7

Column	Property	Value
PurchaseOrderNumber	Data type and presentation size	OrderNumber, 25
	Data length, bytes	50
	NULL values	27659 or 87.90 %
	Actual data size, bytes	47 436 or 0.64 % of table size
	Minimum value length	10
	Maximum value length	13

Column	Property	Value
AccountNumber	Data type and presentation size	AccountNumber, 15
	Data length, bytes	30
	Actual data size, bytes	440 510 or 5.93 % of table size
	Minimum value length	14
	Maximum value length	14

Column	Property	Value
CustomerID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	125 860 or 1.69 % of table size
	Minimum value	1
	Average value	16 608.13
	Maximum value	29 483

Column	Property	Value
ContactID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	125 860 or 1.69 % of table size
	Minimum value	1
	Average value	9 503.66
	Maximum value	19 977

Column	Property	Value
SalesPersonID	Data type and presentation size	int, 10
	Data length, bytes	4
	NULL values	27659 or 87.90 %
	Actual data size, bytes	15 224 or 0.20 % of table size
	Minimum value	268
	Average value	33.89
	Maximum value	290

Column	Property	Value
TerritoryID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	125 860 or 1.69 % of table size
	Minimum value	1
	Average value	6.09
	Maximum value	10

Column	Property	Value
BillToAddressID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	125 860 or 1.69 % of table size
	Minimum value	405
	Average value	18 263.15
	Maximum value	29 883

Column	Property	Value
ShipToAddressID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	125 860 or 1.69 % of table size
	Minimum value	9
	Average value	18 249.19
	Maximum value	29 883

Column	Property	Value
ShipMethodID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	125 860 or 1.69 % of table size
	Minimum value	1
	Average value	1.48
	Maximum value	5

Column	Property	Value
CreditCardID	Data type and presentation size	int, 10
	Data length, bytes	4
	NULL values	1131 or 3.59 %
	Actual data size, bytes	121 336 or 1.63 % of table size
	Minimum value	1
	Average value	9 336.00
	Maximum value	19 237

Column	Property	Value
CreditCardApprovalCode	Data type and presentation size	varchar, 15
	Data length, bytes	15
	NULL values	1131 or 3.59 %
	Actual data size, bytes	394 707 or 5.31 % of table size
	Minimum value length	9
	Maximum value length	15

Column	Property	Value
CurrencyRateID	Data type and presentation size	int, 10
	Data length, bytes	4
	NULL values	17489 or 55.58 %
	Actual data size, bytes	55 904 or 0.75 % of table size
	Minimum value	2
	Average value	4 082.64
	Maximum value	12 431

Column	Property	Value
SubTotal	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	660 765 or 8.89 % of table size
	Minimum value	1.37
	Average value	660 765 or 8.89 % of table size
	Maximum value	224 356.48

Column	Property	Value
TaxAmt	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	660 765 or 8.89 % of table size
	Minimum value	0.10
	Average value	660 765 or 8.89 % of table size
	Maximum value	17 948.51

Column	Property	Value
Freight	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	660 765 or 8.89 % of table size
	Minimum value	0.03
	Average value	660 765 or 8.89 % of table size
	Maximum value	5 608.91

Column	Property	Value
TotalDue	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	660 765 or 8.89 % of table size
	Minimum value	1.51
	Average value	660 765 or 8.89 % of table size
	Maximum value	247 913.91

Column	Property	Value
Comment	Data type and presentation size	nvarchar, 128
	Data length, bytes	256
	NULL values	31465 or 100.00 %
	Actual data size, bytes	0 or 0.00 % of table size
	Minimum value length	0
	Maximum value length	0

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	503 440 or 6.77 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	503 440 or 6.77 % of table size
	Minimum value	2001-07-08
	Average value	2003-09-29
	Maximum value	2004-08-07

Table: Sales.SalesOrderHeaderSalesReason

Property	Value
Table description	Cross-reference table mapping sales orders to sales reason codes.
Analyzed columns	3
Data rows	27 647
Data size, bytes	663 528 or 0.95 % of database size
Table has fixed row size, bytes	24

Column Statistics for 'Sales.SalesOrderHeaderSalesReason' table

Column	Property	Value
SalesOrderID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	110 588 or 16.67 % of table size
	Minimum value	43 697
	Average value	60 458.86
	Maximum value	75 123

Column	Property	Value
SalesReasonID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	110 588 or 16.67 % of table size
	Minimum value	1
	Average value	2.58
	Maximum value	10

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	442 352 or 66.67 % of table size
	Minimum value	2001-07-01
	Average value	2003-10-15
	Maximum value	2004-08-00

Table: Sales.SalesPerson

Property	Value
Table description	Sales representative current information.
Analyzed columns	9
Data rows	17
Data size, bytes	2 237 or 0.00 % of database size
Average row size, bytes	131.58
Minimum row size, bytes	111
Maximum row size, bytes	136

Column Statistics for 'Sales.SalesPerson' table

Column	Property	Value
SalesPersonID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	68 or 3.04 % of table size
	Minimum value	268
	Average value	281.64
	Maximum value	290

Column	Property	Value
TerritoryID	Data type and presentation size	int, 10
	Data length, bytes	4
	NULL values	3 or 17.65 %
	Actual data size, bytes	56 or 2.50 % of table size
	Minimum value	1
	Average value	3.94
	Maximum value	10

Column	Property	Value
SalesQuota	Data type and presentation size	money, 19
	Data length, bytes	21
	NULL values	3 or 17.65 %
	Actual data size, bytes	294 or 13.14 % of table size
	Minimum value	250 000.00
	Average value	294 or 13.14 % of table size
	Maximum value	300 000.00

Column	Property	Value
Bonus	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	357 or 15.96 % of table size
	Minimum value	0.00
	Average value	357 or 15.96 % of table size
	Maximum value	6 700.00

Column	Property	Value
CommissionPct	Data type and presentation size	smallmoney, 10
	Data length, bytes	12
	Actual data size, bytes	204 or 9.12 % of table size
	Minimum value	0.00
	Average value	204 or 9.12 % of table size
	Maximum value	0.02

Column	Property	Value
SalesYTD	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	357 or 15.96 % of table size
	Minimum value	0.00
	Average value	357 or 15.96 % of table size
	Maximum value	5 200 475.23

Column	Property	Value
SalesLastYear	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	357 or 15.96 % of table size
	Minimum value	0.00
	Average value	357 or 15.96 % of table size
	Maximum value	2 396 539.76

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	272 or 12.16 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	272 or 12.16 % of table size
	Minimum value	2001-01-28
	Average value	2002-01-16
	Maximum value	2003-06-24

Table: Sales.SalesPersonQuotaHistory

Property	Value
Table description	Sales performance tracking.
Analyzed columns	5
Data rows	163
Data size, bytes	11 899 or 0.02 % of database size
Table has fixed row size, bytes	73

Column Statistics for 'Sales.SalesPersonQuotaHistory' table

Column	Property	Value
SalesPersonID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	652 or 5.48 % of table size
	Minimum value	268
	Average value	280.15
	Maximum value	290

Column	Property	Value
QuotaDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	2 608 or 21.92 % of table size
	Minimum value	2001-07-01
	Average value	2003-01-18
	Maximum value	2004-04-01

Column	Property	Value
SalesQuota	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	3 423 or 28.77 % of table size
	Minimum value	1 000.00
	Average value	3 423 or 28.77 % of table size
	Maximum value	1 898 000.00

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	2 608 or 21.92 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	2 608 or 21.92 % of table size
	Minimum value	2001-05-17
	Average value	2002-12-04
	Maximum value	2004-02-16

Table: Sales.SalesReason

Property	Value
Table description	Lookup table of customer purchase reasons.
Analyzed columns	4
Data rows	10
Data size, bytes	385 or 0.00 % of database size
Average row size, bytes	38.50
Minimum row size, bytes	30
Maximum row size, bytes	54

Column Statistics for 'Sales.SalesReason' table

Column	Property	Value
SalesReasonID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	40 or 10.39 % of table size
	Minimum value	1
	Average value	5.50
	Maximum value	10

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	115 or 29.87 % of table size
	Minimum value length	5
	Maximum value length	25

Column	Property	Value
ReasonType	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	70 or 18.18 % of table size
	Minimum value length	5
	Maximum value length	9

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	160 or 41.56 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Sales.SalesTaxRate

Property	Value
Table description	Tax rate lookup table.
Analyzed columns	7
Data rows	29
Data size, bytes	2 108 or 0.00 % of database size
Average row size, bytes	72.68
Minimum row size, bytes	65
Maximum row size, bytes	90

Column Statistics for 'Sales.SalesTaxRate' table

Column	Property	Value
SalesTaxRateID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	116 or 5.50 % of table size
	Minimum value	1
	Average value	16.10
	Maximum value	31

Column	Property	Value
StateProvinceID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	116 or 5.50 % of table size
	Minimum value	1
	Average value	43.82
	Maximum value	84

Column	Property	Value
TaxType	Data type and presentation size	tinyint, 3
	Data length, bytes	1
	Actual data size, bytes	29 or 1.38 % of table size
	Minimum value	1
	Average value	2.00
	Maximum value	3

Column	Property	Value
TaxRate	Data type and presentation size	smallmoney, 10
	Data length, bytes	12
	Actual data size, bytes	348 or 16.51 % of table size
	Minimum value	5.00
	Average value	348 or 16.51 % of table size
	Maximum value	19.60

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	571 or 27.09 % of table size
	Minimum value length	12
	Maximum value length	37

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	464 or 22.01 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	464 or 22.01 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Sales.SalesTerritory

Property	Value
Table description	Sales territory lookup table.
Analyzed columns	10
Data rows	10
Data size, bytes	1 408 or 0.00 % of database size
Average row size, bytes	140.80
Minimum row size, bytes	134
Maximum row size, bytes	144

Column Statistics for 'Sales.SalesTerritory' table

Column	Property	Value
TerritoryID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	40 or 2.84 % of table size
	Minimum value	1
	Average value	5.50
	Maximum value	10

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	85 or 6.04 % of table size
	Minimum value length	6
	Maximum value length	14

Column	Property	Value
CountryRegionCode	Data type and presentation size	nvarchar, 3
	Data length, bytes	6
	Actual data size, bytes	20 or 1.42 % of table size
	Minimum value length	2
	Maximum value length	2

Column	Property	Value
Group	Data type and presentation size	nvarchar, 50
	Data length, bytes	100
	Actual data size, bytes	103 or 7.32 % of table size
	Minimum value length	6
	Maximum value length	13

Column	Property	Value
SalesYTD	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	210 or 14.91 % of table size
	Minimum value	1 977 474.80
	Average value	210 or 14.91 % of table size
	Maximum value	8 351 296.74

Column	Property	Value
SalesLastYear	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	210 or 14.91 % of table size
	Minimum value	1 307 949.79
	Average value	210 or 14.91 % of table size
	Maximum value	5 693 988.86

Column	Property	Value
CostYTD	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	210 or 14.91 % of table size
	Minimum value	0.00
	Average value	210 or 14.91 % of table size
	Maximum value	0.00

Column	Property	Value
CostLastYear	Data type and presentation size	money, 19
	Data length, bytes	21
	Actual data size, bytes	210 or 14.91 % of table size
	Minimum value	0.00
	Average value	210 or 14.91 % of table size
	Maximum value	0.00

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	160 or 11.36 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	160 or 11.36 % of table size
	Minimum value	1998-06-01
	Average value	1998-06-01
	Maximum value	1998-06-01

Table: Sales.SalesTerritoryHistory

Property	Value
Table description	Sales representative transfers to other sales territories.
Analyzed columns	6
Data rows	17
Data size, bytes	1 016 or 0.00 % of database size
Average row size, bytes	59.76
Minimum row size, bytes	56
Maximum row size, bytes	72

Column Statistics for 'Sales.SalesTerritoryHistory' table

Column	Property	Value
SalesPersonID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	68 or 6.69 % of table size
	Minimum value	275
	Average value	281.29
	Maximum value	290

Column	Property	Value
TerritoryID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	68 or 6.69 % of table size
	Minimum value	1
	Average value	4.58
	Maximum value	10

Column	Property	Value
StartDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	272 or 26.77 % of table size
	Minimum value	2001-07-01
	Average value	2002-03-01
	Maximum value	2003-07-01

Column	Property	Value
EndDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	NULL values	13 or 76.47 %
	Actual data size, bytes	64 or 6.30 % of table size
	Minimum value	2002-07-00
	Average value	2002-10-30
	Maximum value	2003-01-00

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	272 or 26.77 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	272 or 26.77 % of table size
	Minimum value	2001-06-24
	Average value	2002-06-17
	Maximum value	2003-06-24

Table: Sales.ShoppingCartItem

Property	Value
Table description	Contains online customer orders until the order is submitted or cancelled.
Analyzed columns	6
Data rows	3
Data size, bytes	147 or 0.00 % of database size
Table has fixed row size, bytes	49

Column Statistics for 'Sales.ShoppingCartItem' table

Column	Property	Value
ShoppingCartItemID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	12 or 8.16 % of table size
	Minimum value	2
	Average value	3.66
	Maximum value	5

Column	Property	Value
ShoppingCartID	Data type and presentation size	nvarchar, 50
	Data length, bytes	100
	Actual data size, bytes	15 or 10.20 % of table size
	Minimum value length	5
	Maximum value length	5

Column	Property	Value
Quantity	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	12 or 8.16 % of table size
	Minimum value	3
	Average value	4.66
	Maximum value	7

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	12 or 8.16 % of table size
	Minimum value	862
	Average value	872.33
	Maximum value	881

Column	Property	Value
DateCreated	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	48 or 32.65 % of table size
	Minimum value	2003-12-11
	Average value	2003-12-11
	Maximum value	2003-12-11

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	48 or 32.65 % of table size
	Minimum value	2003-12-11
	Average value	2003-12-11
	Maximum value	2003-12-11

Table: Sales.SpecialOffer

Property	Value
Table description	Sale discounts lookup table.
Analyzed columns	11
Data rows	16
Data size, bytes	2 100 or 0.00 % of database size
Average row size, bytes	131.25
Minimum row size, bytes	117
Maximum row size, bytes	146

Column Statistics for 'Sales.SpecialOffer' table

Column	Property	Value
SpecialOfferID	Data type and presentation size	int identity, 10
	Data length, bytes	4
	Actual data size, bytes	64 or 3.05 % of table size
	Minimum value	1
	Average value	8.50
	Maximum value	16

Column	Property	Value
Description	Data type and presentation size	nvarchar, 255
	Data length, bytes	510
	Actual data size, bytes	362 or 17.24 % of table size
	Minimum value length	11
	Maximum value length	34

Column	Property	Value
DiscountPct	Data type and presentation size	smallmoney, 10
	Data length, bytes	12
	Actual data size, bytes	192 or 9.14 % of table size
	Minimum value	0.02
	Average value	192 or 9.14 % of table size
	Maximum value	0.50

Column	Property	Value
Type	Data type and presentation size	nvarchar, 50
	Data length, bytes	100
	Actual data size, bytes	247 or 11.76 % of table size
	Minimum value length	11
	Maximum value length	20

Column	Property	Value
Category	Data type and presentation size	nvarchar, 50
	Data length, bytes	100
	Actual data size, bytes	131 or 6.24 % of table size
	Minimum value length	8
	Maximum value length	11

Column	Property	Value
StartDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	256 or 12.19 % of table size
	Minimum value	2001-06-01
	Average value	2002-08-08
	Maximum value	2004-05-01

Column	Property	Value
EndDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	256 or 12.19 % of table size
	Minimum value	2002-07-00
	Average value	2003-11-10
	Maximum value	2005-01-00

Column	Property	Value
MinQty	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	64 or 3.05 % of table size
	Minimum value	0
	Average value	9.56
	Maximum value	61

Column	Property	Value
MaxQty	Data type and presentation size	int, 10
	Data length, bytes	4
	NULL values	12 or 75.00 %
	Actual data size, bytes	16 or 0.76 % of table size
	Minimum value	14
	Average value	8.62
	Maximum value	60

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	256 or 12.19 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	256 or 12.19 % of table size
	Minimum value	2001-05-02
	Average value	2002-07-09
	Maximum value	2004-04-01

Table: Sales.SpecialOfferProduct

Property	Value
Table description	Cross-reference table mapping products to special offer discounts.
Analyzed columns	4
Data rows	538
Data size, bytes	21 520 or 0.03 % of database size
Table has fixed row size, bytes	40

Column Statistics for 'Sales.SpecialOfferProduct' table

Column	Property	Value
SpecialOfferID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	2 152 or 10.00 % of table size
	Minimum value	1
	Average value	2.71
	Maximum value	16

Column	Property	Value
ProductID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	2 152 or 10.00 % of table size
	Minimum value	680
	Average value	849.47
	Maximum value	999

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	8 608 or 40.00 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	8 608 or 40.00 % of table size
	Minimum value	2001-05-02
	Average value	2001-07-28
	Maximum value	2004-04-01

Table: Sales.Store

Property	Value
Table description	Customers (resellers) of Adventure Works products.
Analyzed columns	6
Data rows	701
Data size, bytes	42 147 or 0.06 % of database size
Average row size, bytes	60.12
Minimum row size, bytes	49
Maximum row size, bytes	81

Column Statistics for 'Sales.Store' table

Column	Property	Value
CustomerID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	2 804 or 6.65 % of table size
	Minimum value	1
	Average value	351.00
	Maximum value	701

Column	Property	Value
Name	Data type and presentation size	Name, 50
	Data length, bytes	100
	Actual data size, bytes	14 107 or 33.47 % of table size
	Minimum value length	9
	Maximum value length	41

Column	Property	Value
SalesPersonID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	2 804 or 6.65 % of table size
	Minimum value	275
	Average value	280.87
	Maximum value	290

Column	Property	Value
Demographics	Data type and presentation size	xml, 128
	Data length, bytes	0
	Actual data size, bytes	0 or 0.00 % of table size

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	11 216 or 26.61 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	11 216 or 26.61 % of table size
	Minimum value	2004-10-13
	Average value	2004-10-13
	Maximum value	2004-10-13

Table: Sales.StoreContact

Property	Value
Table description	Cross-reference table mapping stores and their employees.
Analyzed columns	5
Data rows	753
Data size, bytes	33 132 or 0.05 % of database size
Table has fixed row size, bytes	44

Column Statistics for 'Sales.StoreContact' table

Column	Property	Value
CustomerID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	3 012 or 9.09 % of table size
	Minimum value	1
	Average value	329.52
	Maximum value	701

Column	Property	Value
ContactID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	3 012 or 9.09 % of table size
	Minimum value	1
	Average value	415.62
	Maximum value	956

Column	Property	Value
ContactTypeID	Data type and presentation size	int, 10
	Data length, bytes	4
	Actual data size, bytes	3 012 or 9.09 % of table size
	Minimum value	11
	Average value	13.26
	Maximum value	15

Column	Property	Value
rowguid	Data type and presentation size	uniqueidentifier, 36
	Data length, bytes	16
	Actual data size, bytes	12 048 or 36.36 % of table size

Column	Property	Value
ModifiedDate	Data type and presentation size	datetime, 23
	Data length, bytes	16
	Actual data size, bytes	12 048 or 36.36 % of table size
	Minimum value	2001-07-01
	Average value	2002-08-22
	Maximum value	2004-06-01