#x27;1995-12-31';
++-+
| CustomerID | TimeCreated |
++-+
| 4 | 1992-11-28 08:13:09 |
| 5 | 1987-11-28 08:13:09 |
++-+
-Original Message-
From: gunwant walbe [mailto:[EMAIL PROTECTED]
Sent
--+-+
| CustomerID | TimeCreated |
++-+
| 4 | 1992-11-28 08:13:09 |
| 5 | 1987-11-28 08:13:09 |
++-+
-Original Message-
From: gunwant walbe [mailto:[EMAIL PROTECTED]
S
Thanks Joe,
I have edit the script and added primary key (CustomerID, TimeCreated
)
and did partitionong on (TimeCreated) by range.
I inserted some records according to partition year .
How would i know which partition contains what record?
(as i am using Windows Xp d
Try it and see where the data goes. It amazing how much you learn by doing
it.
The first problem that you will see is the PK and unique keys in
partitioning have to have the partition key as part of the index. So your
PK would have to be CustomerID, TimeCreated
-Original Message-
From
