I have a database with a few tables in it, one of which is quite a big. I decided to partition it. So after studying how I should I do that, I decided to do it by a wizard. In the section which I had to select a column for partitioning, I noticed that just a part of the columns of a table are visible there are fields for which user defined type are not visible for selecting as the partitioning column. For example I have a field named "Date_Register" with Type "Date_Short:smalldatetime". "Date_Short:smalldatetime" is a user defined type with the following specification:
Name: Date_Short
Data type: smalldatetime
precision: 16
storage : 9 byte
is it possible to select Date_Register as partitioning column?
smalldatetime
is 4 bytes not 9. – Martin Smith Aug 6 '16 at 9:43