December 17, 2009 at 8:38 pm
can you partition on
nvarchar column with values mm/dd/yyyy. How to define the part... function, may need some conversion? and fg for part... sche...?
syntax may help.
December 17, 2009 at 10:11 pm
http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx
http://blogs.msdn.com/menzos/archive/2008/06/25/table-partitioning-in-sql-2008.aspx
http://sqlfool.com/2008/11/102/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 18, 2009 at 12:59 am
lakb200 (12/17/2009)
can you partition onnvarchar column with values mm/dd/yyyy.
Wait just a sec. An nvarchar column with a date in it? Why nvarchar and not datetime? If it's a date, it should be stored as datetime.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2009 at 6:33 am
Appreciate your help.
Cannot define as date time.populated by othe application.noticed though defining function in sequential order, it reshuffles from 01/31/2009,02/31/2009...01/31/2010...12/31/2010...12/31/2011 01/31/2009,01/31/2010,02/2009...12/31/2010,12/31/2011 and the values are in the wrong partition
December 18, 2009 at 9:03 am
lakb200 (12/18/2009)
Cannot define as date time.
Why not?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2009 at 9:59 am
Checked further , it is populated in ERP system and they have restrictions on this format. 3rd party. Also there is no dd coming
We just get MM/yyyy.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply