Table: Store Table: Store| Property | Value |
|---|---|
| Name | Store |
| ID | 270624007 |
| Owner | dbo |
| Schema | Sales |
| Filegroup | PRIMARY |
| Data Size (KB) | 808 KB |
| Index Size (KB) | 608 KB |
| Rows | 701 |
| Unused (KB) | 80 KB |
| ANSI Null On |
|
| Quoted Identifier |
|
| Lock Escalation | TABLE |
| Lock On Bulk Load |
|
| Lob Data Space | PRIMARY |
| Filestream Data Space ID | |
| Has Unchecked Assembly Data |
|
| Text In Row Limit (bytes) | Option not set |
| Large Value Types Out Of Row |
|
| FullText Change Tracking On |
|
| Tracked By Cdc |
|
| Published |
|
| Schema Published |
|
| Replicated |
|
| Replication Filter |
|
| Merge Published |
|
| Sync Tran Subscribed |
|
| MS Shipped |
|
| Modify Date | 8/8/2010 5:23:43 PM |
| Create Date | 8/8/2010 5:21:53 PM |
| Name | Value |
|---|---|
| MS_Description | Customers (resellers) of Adventure Works products. |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | BusinessEntityID | int |
|
|
|
| 2 | Name | Name |
|
|
|
| 3 | SalesPersonID | int |
|
|
|
| 4 | Demographics | xml |
|
|
|
| 5 | rowguid | uniqueidentifier |
|
|
|
| 6 | ModifiedDate | datetime |
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK_Store_BusinessEntityID |
|
MS_Description | Primary key (clustered) constraint |
| Name |
|---|
| BusinessEntityID |
| Name | Referenced Object | Update Action | Delete Action |
|---|---|---|---|
| FK_Store_BusinessEntity_BusinessEntityID | Person.BusinessEntity | No action | No action |
| FK_Store_SalesPerson_SalesPersonID | Sales.SalesPerson | No action | No action |
| Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|
| DF_Store_rowguid | rowguid | (newid()) |
|
MS_Description | Default constraint value of NEWID() |
| DF_Store_ModifiedDate | ModifiedDate | (getdate()) |
|
MS_Description | Default constraint value of GETDATE() |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK_Store_BusinessEntityID | CLUSTERED |
|
|
|
|
|
| AK_Store_rowguid | NONCLUSTERED |
|
|
|
|
|
| IX_Store_SalesPersonID | NONCLUSTERED |
|
|
|
|
|
| PXML_Store_Demographics | XML |
|
|
|
|
|
| Name | Key Index ID | Is Disabled | Is Not For Replication | Is Not Trusted | Delete Action | Update Action | Is System Named | Referencing Object |
|---|---|---|---|---|---|---|---|---|
| FK_Customer_Store_StoreID | 1 |
|
|
|
No action | No action |
|
Sales.Customer |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| PK_Store_BusinessEntityID | Aug 8 2010 5:23PM | 701 | 701 | 200 | 1 | 4 |
|
701 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.001426534 | 4 | BusinessEntityID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 292 | 0 | 1 | 0 | 1 |
| 298 | 2 | 1 | 2 | 1 |
| 306 | 3 | 1 | 3 | 1 |
| 314 | 3 | 1 | 3 | 1 |
| 318 | 1 | 1 | 1 | 1 |
| 322 | 1 | 1 | 1 | 1 |
| 330 | 3 | 1 | 3 | 1 |
| 338 | 3 | 1 | 3 | 1 |
| 346 | 3 | 1 | 3 | 1 |
| 350 | 1 | 1 | 1 | 1 |
| 354 | 1 | 1 | 1 | 1 |
| 362 | 3 | 1 | 3 | 1 |
| 370 | 3 | 1 | 3 | 1 |
| 378 | 3 | 1 | 3 | 1 |
| 382 | 1 | 1 | 1 | 1 |
| 390 | 3 | 1 | 3 | 1 |
| 398 | 3 | 1 | 3 | 1 |
| 402 | 1 | 1 | 1 | 1 |
| 406 | 1 | 1 | 1 | 1 |
| 410 | 1 | 1 | 1 | 1 |
| 414 | 1 | 1 | 1 | 1 |
| 418 | 1 | 1 | 1 | 1 |
| 426 | 3 | 1 | 3 | 1 |
| 434 | 3 | 1 | 3 | 1 |
| 442 | 3 | 1 | 3 | 1 |
| 450 | 3 | 1 | 3 | 1 |
| 458 | 3 | 1 | 3 | 1 |
| 466 | 3 | 1 | 3 | 1 |
| 474 | 3 | 1 | 3 | 1 |
| 482 | 3 | 1 | 3 | 1 |
| 490 | 3 | 1 | 3 | 1 |
| 498 | 3 | 1 | 3 | 1 |
| 502 | 1 | 1 | 1 | 1 |
| 510 | 3 | 1 | 3 | 1 |
| 514 | 1 | 1 | 1 | 1 |
| 518 | 1 | 1 | 1 | 1 |
| 522 | 1 | 1 | 1 | 1 |
| 526 | 1 | 1 | 1 | 1 |
| 530 | 1 | 1 | 1 | 1 |
| 534 | 1 | 1 | 1 | 1 |
| 538 | 1 | 1 | 1 | 1 |
| 546 | 3 | 1 | 3 | 1 |
| 554 | 3 | 1 | 3 | 1 |
| 562 | 3 | 1 | 3 | 1 |
| 570 | 3 | 1 | 3 | 1 |
| 578 | 3 | 1 | 3 | 1 |
| 586 | 3 | 1 | 3 | 1 |
| 594 | 3 | 1 | 3 | 1 |
| 598 | 1 | 1 | 1 | 1 |
| 606 | 3 | 1 | 3 | 1 |
| 614 | 3 | 1 | 3 | 1 |
| 618 | 1 | 1 | 1 | 1 |
| 626 | 3 | 1 | 3 | 1 |
| 634 | 3 | 1 | 3 | 1 |
| 642 | 3 | 1 | 3 | 1 |
| 650 | 3 | 1 | 3 | 1 |
| 658 | 3 | 1 | 3 | 1 |
| 666 | 3 | 1 | 3 | 1 |
| 674 | 3 | 1 | 3 | 1 |
| 678 | 1 | 1 | 1 | 1 |
| 686 | 3 | 1 | 3 | 1 |
| 694 | 3 | 1 | 3 | 1 |
| 702 | 3 | 1 | 3 | 1 |
| 710 | 3 | 1 | 3 | 1 |
| 718 | 3 | 1 | 3 | 1 |
| 726 | 3 | 1 | 3 | 1 |
| 734 | 3 | 1 | 3 | 1 |
| 742 | 3 | 1 | 3 | 1 |
| 750 | 3 | 1 | 3 | 1 |
| 758 | 3 | 1 | 3 | 1 |
| 766 | 3 | 1 | 3 | 1 |
| 774 | 3 | 1 | 3 | 1 |
| 778 | 1 | 1 | 1 | 1 |
| 786 | 3 | 1 | 3 | 1 |
| 794 | 3 | 1 | 3 | 1 |
| 802 | 3 | 1 | 3 | 1 |
| 810 | 3 | 1 | 3 | 1 |
| 818 | 3 | 1 | 3 | 1 |
| 822 | 1 | 1 | 1 | 1 |
| 830 | 3 | 1 | 3 | 1 |
| 838 | 3 | 1 | 3 | 1 |
| 842 | 1 | 1 | 1 | 1 |
| 850 | 3 | 1 | 3 | 1 |
| 858 | 3 | 1 | 3 | 1 |
| 866 | 3 | 1 | 3 | 1 |
| 874 | 3 | 1 | 3 | 1 |
| 882 | 3 | 1 | 3 | 1 |
| 890 | 3 | 1 | 3 | 1 |
| 898 | 3 | 1 | 3 | 1 |
| 902 | 1 | 1 | 1 | 1 |
| 910 | 3 | 1 | 3 | 1 |
| 918 | 3 | 1 | 3 | 1 |
| 926 | 3 | 1 | 3 | 1 |
| 930 | 1 | 1 | 1 | 1 |
| 938 | 3 | 1 | 3 | 1 |
| 946 | 3 | 1 | 3 | 1 |
| 950 | 1 | 1 | 1 | 1 |
| 958 | 3 | 1 | 3 | 1 |
| 966 | 3 | 1 | 3 | 1 |
| 974 | 3 | 1 | 3 | 1 |
| 982 | 3 | 1 | 3 | 1 |
| 990 | 3 | 1 | 3 | 1 |
| 994 | 1 | 1 | 1 | 1 |
| 1002 | 3 | 1 | 3 | 1 |
| 1006 | 1 | 1 | 1 | 1 |
| 1010 | 1 | 1 | 1 | 1 |
| 1018 | 3 | 1 | 3 | 1 |
| 1022 | 1 | 1 | 1 | 1 |
| 1026 | 1 | 1 | 1 | 1 |
| 1030 | 1 | 1 | 1 | 1 |
| 1034 | 1 | 1 | 1 | 1 |
| 1038 | 1 | 1 | 1 | 1 |
| 1042 | 1 | 1 | 1 | 1 |
| 1046 | 1 | 1 | 1 | 1 |
| 1050 | 1 | 1 | 1 | 1 |
| 1054 | 1 | 1 | 1 | 1 |
| 1058 | 1 | 1 | 1 | 1 |
| 1062 | 1 | 1 | 1 | 1 |
| 1066 | 1 | 1 | 1 | 1 |
| 1070 | 1 | 1 | 1 | 1 |
| 1074 | 1 | 1 | 1 | 1 |
| 1082 | 3 | 1 | 3 | 1 |
| 1086 | 1 | 1 | 1 | 1 |
| 1092 | 2 | 1 | 2 | 1 |
| 1100 | 3 | 1 | 3 | 1 |
| 1108 | 3 | 1 | 3 | 1 |
| 1116 | 3 | 1 | 3 | 1 |
| 1124 | 3 | 1 | 3 | 1 |
| 1132 | 3 | 1 | 3 | 1 |
| 1140 | 3 | 1 | 3 | 1 |
| 1148 | 3 | 1 | 3 | 1 |
| 1156 | 3 | 1 | 3 | 1 |
| 1164 | 3 | 1 | 3 | 1 |
| 1172 | 3 | 1 | 3 | 1 |
| 1180 | 3 | 1 | 3 | 1 |
| 1188 | 3 | 1 | 3 | 1 |
| 1196 | 3 | 1 | 3 | 1 |
| 1204 | 3 | 1 | 3 | 1 |
| 1212 | 3 | 1 | 3 | 1 |
| 1220 | 3 | 1 | 3 | 1 |
| 1228 | 3 | 1 | 3 | 1 |
| 1236 | 3 | 1 | 3 | 1 |
| 1244 | 3 | 1 | 3 | 1 |
| 1252 | 3 | 1 | 3 | 1 |
| 1260 | 3 | 1 | 3 | 1 |
| 1268 | 3 | 1 | 3 | 1 |
| 1276 | 3 | 1 | 3 | 1 |
| 1284 | 3 | 1 | 3 | 1 |
| 1292 | 3 | 1 | 3 | 1 |
| 1300 | 3 | 1 | 3 | 1 |
| 1308 | 3 | 1 | 3 | 1 |
| 1316 | 3 | 1 | 3 | 1 |
| 1324 | 3 | 1 | 3 | 1 |
| 1332 | 3 | 1 | 3 | 1 |
| 1340 | 3 | 1 | 3 | 1 |
| 1348 | 3 | 1 | 3 | 1 |
| 1356 | 3 | 1 | 3 | 1 |
| 1364 | 3 | 1 | 3 | 1 |
| 1372 | 3 | 1 | 3 | 1 |
| 1380 | 3 | 1 | 3 | 1 |
| 1388 | 3 | 1 | 3 | 1 |
| 1396 | 3 | 1 | 3 | 1 |
| 1404 | 3 | 1 | 3 | 1 |
| 1412 | 3 | 1 | 3 | 1 |
| 1420 | 3 | 1 | 3 | 1 |
| 1428 | 3 | 1 | 3 | 1 |
| 1436 | 3 | 1 | 3 | 1 |
| 1444 | 3 | 1 | 3 | 1 |
| 1452 | 3 | 1 | 3 | 1 |
| 1460 | 3 | 1 | 3 | 1 |
| 1468 | 3 | 1 | 3 | 1 |
| 1476 | 3 | 1 | 3 | 1 |
| 1484 | 3 | 1 | 3 | 1 |
| 1796 | 3 | 1 | 3 | 1 |
| 1804 | 3 | 1 | 3 | 1 |
| 1812 | 3 | 1 | 3 | 1 |
| 1820 | 3 | 1 | 3 | 1 |
| 1828 | 3 | 1 | 3 | 1 |
| 1836 | 3 | 1 | 3 | 1 |
| 1844 | 3 | 1 | 3 | 1 |
| 1852 | 3 | 1 | 3 | 1 |
| 1860 | 3 | 1 | 3 | 1 |
| 1868 | 3 | 1 | 3 | 1 |
| 1876 | 3 | 1 | 3 | 1 |
| 1884 | 3 | 1 | 3 | 1 |
| 1892 | 3 | 1 | 3 | 1 |
| 1900 | 3 | 1 | 3 | 1 |
| 1908 | 3 | 1 | 3 | 1 |
| 1916 | 3 | 1 | 3 | 1 |
| 1924 | 3 | 1 | 3 | 1 |
| 1932 | 3 | 1 | 3 | 1 |
| 1940 | 3 | 1 | 3 | 1 |
| 1948 | 3 | 1 | 3 | 1 |
| 1956 | 3 | 1 | 3 | 1 |
| 1964 | 3 | 1 | 3 | 1 |
| 1972 | 3 | 1 | 3 | 1 |
| 1980 | 3 | 1 | 3 | 1 |
| 1988 | 3 | 1 | 3 | 1 |
| 1994 | 2 | 1 | 2 | 1 |
| 2051 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_Store_rowguid | Aug 8 2010 5:23PM | 701 | 701 | 179 | 1 | 20 |
|
701 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.001426534 | 16 | rowguid |
| 0.001426534 | 20 | rowguid, BusinessEntityID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 276c70d2-c4d6-458e-9a49-0036b93bb544 | 0 | 1 | 0 | 1 |
| 0adcf413-2501-4dcb-bb86-01ce9f6d92be | 6 | 1 | 6 | 1 |
| 132ef67c-f056-4245-8617-03da1b1da9b4 | 3 | 1 | 3 | 1 |
| c3346ce3-ca88-4e5b-8a41-05e76abf4fcf | 1 | 1 | 1 | 1 |
| e71ac59c-b228-49f2-acc2-077aa5dfc9db | 5 | 1 | 5 | 1 |
| 68fc27ad-2ed1-4f61-a068-0aa3debd9931 | 3 | 1 | 3 | 1 |
| eb0f662c-8d87-454e-abad-0cbbb847c171 | 3 | 1 | 3 | 1 |
| 2c9d7f50-6431-4361-9843-0cf1601b23b9 | 1 | 1 | 1 | 1 |
| 72466590-e6b6-4aab-a1f2-0dcb18685a12 | 1 | 1 | 1 | 1 |
| b8e6ef57-7087-4b21-9636-0e657902714e | 3 | 1 | 3 | 1 |
| 88ceecee-7ad3-42e7-9f75-0f5a397083ae | 3 | 1 | 3 | 1 |
| 1f1ebdc9-2874-4a7e-be41-1127cbec7870 | 3 | 1 | 3 | 1 |
| b83544ef-3eac-4e68-b36d-12ab33dcd6b3 | 5 | 1 | 5 | 1 |
| dfed9777-d43c-497d-86d4-14407e43c535 | 3 | 1 | 3 | 1 |
| 4dcdf6f3-84a2-4407-973a-14ae73eb4e7f | 3 | 1 | 3 | 1 |
| d1966056-3822-4f4d-a687-14eba601642c | 1 | 1 | 1 | 1 |
| 623db28f-60da-49d6-b72d-1680aa5e6351 | 1 | 1 | 1 | 1 |
| 634a228b-5268-4789-a687-182151058d39 | 5 | 1 | 5 | 1 |
| 0948efce-69ef-4866-b25e-19ac06159158 | 3 | 1 | 3 | 1 |
| afc82a28-1a27-4899-a413-1b4d32a2df11 | 3 | 1 | 3 | 1 |
| fb89ac44-0cf5-45d1-928e-1beeece05abf | 3 | 1 | 3 | 1 |
| d2a3db53-0901-4322-a7af-1cc77a7b1778 | 3 | 1 | 3 | 1 |
| f848fdfb-b867-4628-b5d9-1df6137103e1 | 3 | 1 | 3 | 1 |
| fa2486e8-99b6-4832-9edf-1f86f1399cfc | 3 | 1 | 3 | 1 |
| 6a2daf2a-19a5-42c5-8dc4-2038561c5ae3 | 3 | 1 | 3 | 1 |
| 7894f278-f0c8-4d16-bd75-213fdbf13023 | 3 | 1 | 3 | 1 |
| 2a953c4e-a056-456a-86fc-21e0dcd7e432 | 3 | 1 | 3 | 1 |
| a8c079a5-40cb-4707-b88d-25b0ffa42664 | 5 | 1 | 5 | 1 |
| cd239474-966c-4474-97a9-25d52289ed52 | 1 | 1 | 1 | 1 |
| ebfc3863-01f0-4614-8a38-25f35f6801e2 | 1 | 1 | 1 | 1 |
| 17906b3f-7ea8-4b87-a60e-278df291a580 | 1 | 1 | 1 | 1 |
| fcafe412-052f-4f3e-b8a5-28f71c755019 | 3 | 1 | 3 | 1 |
| ed883c76-170d-4fb9-a277-295d39d3eaf9 | 1 | 1 | 1 | 1 |
| 10069045-fe16-4eef-bdf8-2aa907c8924d | 1 | 1 | 1 | 1 |
| 8bc88e7c-8f45-4b76-83cf-2b3b4748de76 | 3 | 1 | 3 | 1 |
| b50ca50b-c601-4a13-b07e-2c63862d71b4 | 3 | 1 | 3 | 1 |
| 9ab6652a-8949-4ff5-aa99-2e7252bfd359 | 3 | 1 | 3 | 1 |
| 35ebf652-e9fc-490c-902d-304e4d112ed9 | 3 | 1 | 3 | 1 |
| ac7a83f1-196b-4bbf-a6e0-3165d4c84454 | 3 | 1 | 3 | 1 |
| c8c746de-fc58-4c58-abc1-31e1375be48d | 3 | 1 | 3 | 1 |
| 14aa6ec7-1684-4a9d-bfb9-3405270bc52b | 3 | 1 | 3 | 1 |
| 326d145a-2c37-4f02-aa83-350132148316 | 1 | 1 | 1 | 1 |
| 56795063-f8c7-4550-8a37-357d91cb7c96 | 3 | 1 | 3 | 1 |
| 6a1bea56-dcb7-45cf-8c92-3705e12eb2aa | 3 | 1 | 3 | 1 |
| ee22cf36-5dc3-483e-885a-37ed28508a30 | 1 | 1 | 1 | 1 |
| 9f37eb77-80e4-4ffc-a5dc-3b1808d9af72 | 3 | 1 | 3 | 1 |
| 8874d7b8-9bfb-412a-b19c-3c566c15c03a | 3 | 1 | 3 | 1 |
| df54deb4-58d4-4d01-9288-3f4a14f346b5 | 7 | 1 | 7 | 1 |
| 943a2705-ce9c-47d6-8708-407bd239ed49 | 3 | 1 | 3 | 1 |
| 1489097d-7481-405d-bc93-4274cb5e6a82 | 3 | 1 | 3 | 1 |
| 69a30a7b-7b6a-43e1-a2f2-438909377803 | 3 | 1 | 3 | 1 |
| d41ba195-3da6-42fb-8522-44a96dacb956 | 1 | 1 | 1 | 1 |
| 6ae7f252-55b7-4d73-91b1-4580678cba60 | 3 | 1 | 3 | 1 |
| 608d52aa-1d0d-4d5d-a0a0-47f9977af2af | 3 | 1 | 3 | 1 |
| 57e8e5c9-7a01-485e-ae4b-48dcb41a0dc2 | 3 | 1 | 3 | 1 |
| 1b520861-7d47-4bb2-96ee-4acd2b54ed5e | 3 | 1 | 3 | 1 |
| 093a9472-b613-4214-9c41-4d707cfc38c0 | 3 | 1 | 3 | 1 |
| 59386b0c-652e-4668-b44b-4e1711793330 | 3 | 1 | 3 | 1 |
| 5b3d4ad5-0f11-4f5e-9ed4-4f0aa9472762 | 3 | 1 | 3 | 1 |
| b555436d-e4be-4352-8144-5064a4d62964 | 3 | 1 | 3 | 1 |
| 7c2547ec-e661-4c36-bb47-51f57ac3dbc4 | 3 | 1 | 3 | 1 |
| e0e88a9e-eac4-4e30-8072-534c4c4ac250 | 3 | 1 | 3 | 1 |
| eb847e4a-b183-4385-8de1-57c39d4d3304 | 3 | 1 | 3 | 1 |
| 43fce0d5-7a1b-4316-8c1c-58b9acc57fa2 | 3 | 1 | 3 | 1 |
| b39bf496-3dd4-47af-9f26-5a7b44349127 | 1 | 1 | 1 | 1 |
| f0e72f25-41ef-4c1d-ad51-5af894f852b0 | 3 | 1 | 3 | 1 |
| 5f8c35a3-92f4-4979-a838-5b93c221b9df | 3 | 1 | 3 | 1 |
| 27758a68-359b-4ea6-8689-5cb8b4a5f489 | 3 | 1 | 3 | 1 |
| e33ad5ac-f5ce-4070-bbf0-5f9d3d5dbefb | 3 | 1 | 3 | 1 |
| 841949ed-fe89-4fc6-9e24-605adf88b9cd | 3 | 1 | 3 | 1 |
| acdca9a3-f6f2-4e09-a9af-61f6b9834595 | 1 | 1 | 1 | 1 |
| 4fe6e559-7339-4043-92d9-635f2f3c00b0 | 3 | 1 | 3 | 1 |
| f948f121-09c9-46d4-a783-63ead859a044 | 3 | 1 | 3 | 1 |
| f2bbf7e1-a7eb-4966-bc17-64288e4568f6 | 1 | 1 | 1 | 1 |
| adb430fb-d23b-4a4c-9146-65193a80b9e0 | 3 | 1 | 3 | 1 |
| 4a3c505a-c5ae-4061-b376-67415efcecbb | 3 | 1 | 3 | 1 |
| 1589e17f-1b07-411a-8938-6bcec7d3140f | 7 | 1 | 7 | 1 |
| fc972e23-ab3e-48b2-8270-6defb1b8a796 | 3 | 1 | 3 | 1 |
| b634ae55-e758-4184-bd40-6f0eec1ee566 | 3 | 1 | 3 | 1 |
| 368be6dd-30e5-49bb-9a86-71fd49c58f4e | 3 | 1 | 3 | 1 |
| 7d7911cf-c5dc-4d89-a503-7377a84cb3d9 | 1 | 1 | 1 | 1 |
| a22517e3-848d-4ebe-b9d9-7437f3432304 | 3 | 1 | 3 | 1 |
| 2316f0f6-acf4-4458-9538-74f842c88d11 | 3 | 1 | 3 | 1 |
| 1d65dd5a-a7c8-4ac1-a2b6-76ad4a5946bd | 3 | 1 | 3 | 1 |
| 43a5e3fd-0886-44e3-9640-772616d463b7 | 1 | 1 | 1 | 1 |
| 55b8ce76-1c6a-4181-83cf-786c60cee77f | 3 | 1 | 3 | 1 |
| 7501acfe-c321-41d1-9966-7928ee700b8e | 3 | 1 | 3 | 1 |
| e73e6b44-3824-4c98-a7b1-796f1f1e0de8 | 1 | 1 | 1 | 1 |
| 529d4609-7129-4c41-a88e-7bbe2f25b663 | 3 | 1 | 3 | 1 |
| 43be0e08-95b3-4cfe-b5fe-7c9a7270ffba | 3 | 1 | 3 | 1 |
| 638dfc4e-0c69-4538-8da8-7e82b1b7a9ce | 3 | 1 | 3 | 1 |
| d32d0b60-2a92-4f48-8b49-817466bd7dbd | 3 | 1 | 3 | 1 |
| 6fe30abe-390e-41bb-a85f-82279aa39245 | 3 | 1 | 3 | 1 |
| 785c93ca-4ad3-4427-a790-8437cbb3a3ee | 1 | 1 | 1 | 1 |
| fb6331ea-0148-418a-884a-84d1da20ac3c | 3 | 1 | 3 | 1 |
| 0c2d39a6-b731-4d81-8253-85a0d25acd25 | 1 | 1 | 1 | 1 |
| d03c1cea-5d48-4dd1-98d6-87d06c1f33a1 | 5 | 1 | 5 | 1 |
| e71200e7-e3b5-4a40-bad9-88364de28030 | 1 | 1 | 1 | 1 |
| ad164fae-f4f6-4c0f-852e-889ee6280b41 | 1 | 1 | 1 | 1 |
| 9b88e8ed-c244-484d-8c4f-89f59570ebea | 1 | 1 | 1 | 1 |
| 2211f0a3-5a94-486c-ac43-8b2a76f40db5 | 3 | 1 | 3 | 1 |
| 9cb195b3-45e3-455c-8e5e-8b621010bca8 | 1 | 1 | 1 | 1 |
| a0ee7b0a-7741-4f37-bdec-8d2206467fce | 1 | 1 | 1 | 1 |
| 5642c175-e11f-490a-9590-8d5211692d60 | 1 | 1 | 1 | 1 |
| fe70ecfc-edbb-41ed-910d-8dd39c87e25d | 1 | 1 | 1 | 1 |
| 137fea4b-320d-4676-a548-8efcf1f6b36b | 1 | 1 | 1 | 1 |
| 24f1c5f8-093a-426c-87ce-8fa9af9fac33 | 1 | 1 | 1 | 1 |
| 70cbfdc4-a8fe-4bdd-9571-8fc617bdfcb7 | 1 | 1 | 1 | 1 |
| 7d98c7c7-c155-482e-a2b2-918964a02a05 | 3 | 1 | 3 | 1 |
| 8b93dba7-7742-42ab-81c1-91ffc3b713cb | 3 | 1 | 3 | 1 |
| 5f85023b-d708-4d44-b1a2-927a21c4cbbb | 1 | 1 | 1 | 1 |
| 4e917578-1942-4bab-8e63-932052fdacec | 2 | 1 | 2 | 1 |
| f2c84903-19ed-4549-8b4e-9604c558eab6 | 3 | 1 | 3 | 1 |
| 059b53a3-3394-433b-b916-97265d5a95c5 | 3 | 1 | 3 | 1 |
| 20838797-ec33-4328-bdc0-99190729be4a | 3 | 1 | 3 | 1 |
| ef4de775-b406-45c4-a6dd-9b0b4815fdbf | 3 | 1 | 3 | 1 |
| 1c035fdb-8781-4e4c-9c4e-9cb3ae7b45a9 | 3 | 1 | 3 | 1 |
| 78b4a61e-0999-49b7-a104-9e2faaa8b92f | 3 | 1 | 3 | 1 |
| 7a341a16-8c5b-4a18-84ab-9ef05241d721 | 3 | 1 | 3 | 1 |
| 7f2c3ab3-97ca-46ba-820e-a03f59ec842d | 3 | 1 | 3 | 1 |
| 25c229c0-4e7a-42d2-acb1-a2118361b2f1 | 3 | 1 | 3 | 1 |
| 739999fe-97eb-4f89-ba26-a34771d9af65 | 3 | 1 | 3 | 1 |
| 9fa1609c-9a36-4282-bc80-a562332def1b | 3 | 1 | 3 | 1 |
| 6324fad5-6bc4-4715-85bc-a86c49e527f8 | 7 | 1 | 7 | 1 |
| 16255726-8647-401a-9de9-ab524a839804 | 3 | 1 | 3 | 1 |
| 8b1e2f28-a97f-4b3e-9130-ac855b3f8a42 | 3 | 1 | 3 | 1 |
| 00a7e190-d705-4791-aab5-ad218497dd06 | 3 | 1 | 3 | 1 |
| 3b49ba13-2f39-4481-8153-ad709211834e | 3 | 1 | 3 | 1 |
| 5e3fd434-3d79-4ecd-ab34-af321ee2cfe7 | 3 | 1 | 3 | 1 |
| cbd5d92a-3cff-40b0-9214-b0d337be2a75 | 3 | 1 | 3 | 1 |
| 7c7076c8-2ab9-4810-bbca-b126fc811e32 | 3 | 1 | 3 | 1 |
| 7e5da4c4-23b4-4bd2-8037-b2be46e41c83 | 3 | 1 | 3 | 1 |
| b07b4a19-8960-4a16-914c-b516cb49cce0 | 7 | 1 | 7 | 1 |
| 0cb4fef2-5047-40f7-8848-b59f7a3f3eec | 3 | 1 | 3 | 1 |
| cdd163a9-dc42-44b4-ba95-b5de845813e4 | 3 | 1 | 3 | 1 |
| 65eb45f3-c60f-4bb6-85ce-b8482e68868b | 3 | 1 | 3 | 1 |
| 690b6d1f-f71e-4bb8-b87d-baeb505135ef | 3 | 1 | 3 | 1 |
| 5221dd86-f37e-4f4a-8374-bbcae7e69f4f | 3 | 1 | 3 | 1 |
| a22c02a3-37c8-402a-932f-bc8dd75bea87 | 3 | 1 | 3 | 1 |
| 993c0120-5e56-4ab8-9e1b-bf71be3b7faa | 3 | 1 | 3 | 1 |
| 9240a9e4-b7f9-40f2-9d2a-c01f78c45c3d | 3 | 1 | 3 | 1 |
| 060b2e02-67a3-493e-ac3a-c2a7851498fd | 3 | 1 | 3 | 1 |
| 0e3f4f5a-5dee-4b0a-a5a5-c524f74156ea | 3 | 1 | 3 | 1 |
| 24803781-0abd-47f6-a88c-c5fae0eaa3f7 | 3 | 1 | 3 | 1 |
| d664a5cb-eb27-422e-8c7e-c81814508c73 | 3 | 1 | 3 | 1 |
| 7cbea615-beca-44c6-8c74-cb1541faefa6 | 7 | 1 | 7 | 1 |
| 4372d419-1d5a-4a3d-8803-cb94a930e5d9 | 3 | 1 | 3 | 1 |
| 349c5e18-0492-4ff2-b3b6-ce2c5277d948 | 3 | 1 | 3 | 1 |
| ab32ce06-f2af-4b8a-889a-cfc4db6b150a | 3 | 1 | 3 | 1 |
| a7048720-5bdd-4df4-8685-d14d868ae297 | 7 | 1 | 7 | 1 |
| e06866f7-c659-4952-a1ec-d2b42f80613a | 3 | 1 | 3 | 1 |
| 0d5c741d-a691-4732-93a3-d34ed0ed3716 | 3 | 1 | 3 | 1 |
| c87accfe-02f1-4ecb-8759-d418e0df29ea | 3 | 1 | 3 | 1 |
| 70703845-fb8a-40a5-974f-d54b46943647 | 3 | 1 | 3 | 1 |
| a3140349-57a3-46aa-bf32-d7f4753a06d6 | 3 | 1 | 3 | 1 |
| 65b0d467-0550-4230-9eff-d931a786f5c2 | 3 | 1 | 3 | 1 |
| 5aed8117-0923-489c-864b-db7a601daf33 | 3 | 1 | 3 | 1 |
| ba90930e-259d-4bfe-b558-de00867a4247 | 7 | 1 | 7 | 1 |
| 1baa7f8a-c00a-441e-8d40-e06a4aec1c43 | 3 | 1 | 3 | 1 |
| c8e3c4ed-8f58-4db2-b600-e0cd11d9cfad | 3 | 1 | 3 | 1 |
| 71322a9a-9feb-4c12-947a-e3aeffbfa3e2 | 7 | 1 | 7 | 1 |
| 0d350025-a81c-4aec-a713-e536e2f66ac8 | 3 | 1 | 3 | 1 |
| 2656a532-5879-4092-91eb-e7a2d2cd2ee6 | 7 | 1 | 7 | 1 |
| cde66279-83d8-4340-a83c-e86e15514ac4 | 3 | 1 | 3 | 1 |
| dc610525-e373-49b1-b786-ea040ec25c06 | 3 | 1 | 3 | 1 |
| 8e256f9e-fecd-4695-96f0-ea82e830a79f | 3 | 1 | 3 | 1 |
| 5e7cb5e1-6651-49e6-a5cf-edf584f7ec92 | 7 | 1 | 7 | 1 |
| 02f5437e-f74e-4f8b-92ee-f129c8ac0986 | 7 | 1 | 7 | 1 |
| c32f634b-50be-48bb-a1e4-f39800b04407 | 3 | 1 | 3 | 1 |
| 96a94727-d9cc-4596-a196-f48d0932f5cc | 3 | 1 | 3 | 1 |
| bba21530-ca9c-498e-bda9-f5b62f8c8525 | 3 | 1 | 3 | 1 |
| d2dc2451-e8f2-449b-b94c-f6729dcf110c | 3 | 1 | 3 | 1 |
| df9126a5-9c95-44a2-a31f-f759ea33eea7 | 3 | 1 | 3 | 1 |
| a7788438-9873-4c7b-98e9-f8bbb6c8490e | 3 | 1 | 3 | 1 |
| 01cd6b0b-1c26-4490-bc7b-fa20c8adab95 | 3 | 1 | 3 | 1 |
| 995a09e7-7e7f-4b24-b493-fb70d5b83828 | 3 | 1 | 3 | 1 |
| 5ef7f44b-42fc-4b7d-a1d3-fdf2f906aac1 | 3 | 1 | 3 | 1 |
| 6252826a-91a5-41e4-9348-ff0afc2b669e | 2 | 1 | 2 | 1 |
| a05e0815-2d28-45e6-91e5-ff8053433ebf | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| IX_Store_SalesPersonID | Aug 8 2010 5:23PM | 701 | 701 | 12 | 0.025 | 8 |
|
701 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.07692308 | 4 | SalesPersonID |
| 0.001426534 | 8 | SalesPersonID, BusinessEntityID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 275 | 0 | 77 | 0 | 1 |
| 276 | 0 | 39 | 0 | 1 |
| 277 | 0 | 76 | 0 | 1 |
| 278 | 0 | 40 | 0 | 1 |
| 279 | 0 | 80 | 0 | 1 |
| 280 | 0 | 38 | 0 | 1 |
| 281 | 0 | 79 | 0 | 1 |
| 282 | 0 | 74 | 0 | 1 |
| 283 | 0 | 38 | 0 | 1 |
| 286 | 0 | 40 | 0 | 1 |
| 288 | 0 | 40 | 0 | 1 |
| 290 | 40 | 40 | 1 | 40 |
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Sales].[Store]( [BusinessEntityID] [int] NOT NULL, [Name] [dbo].[Name] NOT NULL, [SalesPersonID] [int] NULL, [Demographics] [xml](CONTENT [Sales].[StoreSurveySchemaCollection]) NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to Customer.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Store', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the store.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Store', @level2type=N'COLUMN',@level2name=N'Name' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the sales person assigned to the customer. Foreign key to SalesPerson.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Store', @level2type=N'COLUMN',@level2name=N'SalesPersonID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Demographic informationg about the store such as the number of employees, annual sales and store type.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Store', @level2type=N'COLUMN',@level2name=N'Demographics' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Store', @level2type=N'COLUMN',@level2name=N'rowguid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Store', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customers (resellers) of Adventure Works products.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Store' |