Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

partitioning in 2008 Expand / Collapse
Author
Message
Posted Thursday, December 17, 2009 8:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 6, 2012 9:52 AM
Points: 9, Visits: 51
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.
Post #836109
Posted Thursday, December 17, 2009 10:11 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 1:05 AM
Points: 1,904, Visits: 2,842
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/


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #836124
Posted Friday, December 18, 2009 12:59 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:53 PM
Points: 42,771, Visits: 35,870
lakb200 (12/17/2009)
can you partition on
nvarchar 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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #836160
Posted Friday, December 18, 2009 6:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 6, 2012 9:52 AM
Points: 9, Visits: 51
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
Post #836275
Posted Friday, December 18, 2009 9:03 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:53 PM
Points: 42,771, Visits: 35,870
lakb200 (12/18/2009)
Cannot define as date time.


Why not?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #836412
Posted Friday, December 18, 2009 9:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 6, 2012 9:52 AM
Points: 9, Visits: 51
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.



Post #836451
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse